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 ...
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.
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
If i delete one record in master table, then the same record is also deleted in dependent table, for this which transformation can we use.
when can we use stored procedure transformations.
Latest Answer : Whenever you need value from SP, that time you have to use store pro. transformation. Or whenever you would like to preform some activity on the DB after loading the data or before loading data through ETL process. It can be done through Shell scripts ...
