Why we use lookup transformation? - ETL

ETL (extract, transform, and load) Testing Interview Questions

(Continued from previous question...)

83. Why we use lookup transformation? - ETL

Look up Transformations can access data from relational tables that are not sources in mapping. With Lookup transformation, we can accomplish the following tasks.

(Continued on next question...)

Other Interview Questions

• What is a Dimension Modeling? - ETL
• Why is it important to clean data? - ETL
• What is Metadata?- ETL
• What are the types of OLAPs ? - ETL
• What is a Data mart? - ETL
• What is the difference between Data Mining and Data Warehousing? - ETL
• What are the out put files that the informatica server creates during the session running? - ETL
• When do we Analyze the tables? How do we do it? - ETL
• What is Data Acquisition Process? - ETL
• What are Update Strategy’s target table options? - ETL
• More...