|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions Latest Answer : can u plz send the detailed description of each transformationthanx ... Answered by kiran on 2005-05-08 09:32:14: An active transformation can change the number of rows as output after a transformation, while a passive transformation does not change the number of rows and Latest Answer : Active transformation is nothing but it will change the no of rows passing through it (example) Filter transformation .In it when we have 1000 rows as input after filter transformation according to the condition the output will be modifiedPassive ... Answered by kiran on 2005-05-08 09:20:30: Informatica Metadata contains all the information about the source tables, target tables, the transformations, so that it will be useful and easy to perform transformations Latest Answer : All informations about the mappings,workflows such as Source,target,transformations are converted into metadata format and it is stored in the Repository database.The repository database is a open database,which can be accessible by the Repositoy server ... Tags : Metadata Latest Answer : You cannot lookup from a source qualifier directly. However, you can override the SQL in the source qualifier to join with the lookup table to perform the lookup. ... Read Answers (3) | Asked by : asha Lets suppose we have some 10,000 odd records in source system and when load them into target how do we ensure that all 10,000 records that are loaded to target doesn't contain any garbage values. How do we test it. We can't check every record as number of records are huge. Read Answers (8) | Asked by : Ram In real time scenario where update strategy transformation is used?if we dml operations in session properties then what is the use of update strategy transforamtion ? How you capture changes in data if the source system does not have option of storing date/time field How you capture changes in data if the source system does not have option of storing date/time field in source table from where you need to extract the data? The DW database can be Oracle or Teradata. The requirement here is to pull data from source system and ETL need to device a mechanism to identify the changes or new records. The source system can be a Read Answers (1) | Asked by : GeekNo1 Latest Answer : Update strategy transformation determines whether to insert, update, delete or reject a record for the target. We can bypass update strategy transformation by creating a router to divide rows based on insert, update, etc and connecting ... In What scenario ETL coding is preferred than Database level SQL, PL/SQL coding? What is the methodology and process followed for ETL testing in Data warehouse environment? Develop a mapping to extract the employee drawing maximum salary where deptno = department drawing... If LKP on target table is taken, can we update the rows without update strategy transformation? How you capture changes in data if the source system does not have option of storing date/time field... What is the Difference between Read Answers (1) | Asked by : srihari What is the first one executed in a session? Is it the Truncate Target Table option or the Post SQL? Explain Latest Answer : Truncate Target table:Integration Service truncate target tables before running a session.Depending on the target database and primary key-foreign key relationships in the session target, the Integration Service might issue a delete or truncate command.Post ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
