20 ETL interview questions and answers

          

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

 

 

 
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring