 Related Questions Latest Answer : Aggregator Transformation Expression Transformation Filter Transformation Joiner Transformation Lookup Transformation Normalizer Transformation Rank Transformation Router Transformation Sequence Generator ... 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 : Metadata is simply documentation for a digital geospatial dataset. It is a text document that describes the who, what, when, where, why and how questions about the data, so that a potential data user can decide whether or not the data is appropriate for ... 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 (2) | 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 table will be executed first.Trunc. table gets esecuted before the table starts loading and post SQL executes after the session is completed (table loaded) ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
