20 ETL interview questions and answers

1. What is ETL process? How many steps ETL contains?

2.What is Full load & Incremental or Refresh load? - ETL

3.What is a three tier data warehouse? - ETL

4.What are snapshots? What are materialized views & where do we use them? What is a materialized view log? - ETL

5.What is partitioning? Explain about Round-Robin, Hash partitioning. - ETL

6.What is partitioning? Explain about Round-Robin, Hash partitioning. - ETL

7.What is a mapping, session, worklet, workflow, mapplet? - ETL

8.What is Operational Data Store? - ETL

9.When do we Analyze the tables? How do we do it? - ETL

10.How to fine tune mappings? - ETL

11.What are the differences between Connected and Unconnected lookup? - ETL

12.When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between Stop and Abort - ETL

13.What is tracing level? How many types of transformations supported by sorted input? - ETL

14.What are the differences between SQL Override and Update Override? - ETL

15.What is factless fact schema? - ETL

16.In Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how do I do this? - ETL

17.Why can't we see the data in dataset? - ETL

18.How DTM buffer size and buffer block size are related? - ETL

19.State the differences between shortcut and reusable transformation - ETL

20.What are the out put files that the informatica server creates during the session running? - ETL

Write your comment - Share Knowledge and Experience Discussion Board Validating the legacy file and Oracle Once Legacy File will move to Staging Area , From Staging Area to Target Tables, Will write the test scenarions to cover the Table Strucutre , Table count and Field-to-field validation.Convert the Legacy file into excel or flat file and compare the Target files with the source files Priya 07-7-2015 04:24 PM etl interview question answer Let's suppose we are migrating the data from legacy file system to oracle database tables. How would you validate that the data is migrated properly? Tell me the test scenario and test cases you will write to test this requirement. ?? answer: if its large data we go with count or need to validate whether the data is migrated or not copy paste method in excel sheet ramraj 02-11-2015 12:44 PM ETL Testing Interview Question ETL Testing Interview Question Let's suppose we are migrating the data from legacy file system to oracle database tables. How would you validate that the data is migrated properly? Tell me the test scenario and test cases you will write to test this requirement. ?? Please give a thought to this question. Uttam Kedia Data Warehouse Engineer http://techloverforum.blogspot.com/ Uttam 02-25-2014 11:15 PM ETL Testing Interview Question Let's suppose we are migrating the data from legacy file system to oracle database tables. How would you validate that the data is migrated properly? Tell me the test scenario and test cases you will write to test this requirement. ?? Please give a thought to this question. Uttam Kedia Data Warehouse Engineer techloverforum.blogspot.com/ Uttam 02-20-2014 10:46 PM ETL Testing Interview Question Let's suppose we are migrating the data from legacy file system to oracle database tables. How would you validate that the data is migrated properly? Tell me the test scenario and test cases you will write to test this requirement. ?? Please give a thought to this question. Uttam Kedia Data Warehouse Engineer techloverforum.blogspot.com/ Uttam 02-20-2014 10:46 PM