ETL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

ETL Interview Questions

Questions Answers Views Company eMail

When do we analyze the tables? How do we do it?

963

When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

985

What is etl process? How many steps etl contains?

1037

How many steps etl contains?

949

What is a mapping?

995

What are materialized views & where do we use them?

1004

State the differences between shortcut and reusable transformation

1060

Explain about round-robi?

1157

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

1078

What is a materialized view log?

1004

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?

936

What are snapshots?

988

What are the differences between sql override and update override?

1105

What is partitioning? Explain about round-robin, hash partitioning.

969

Explain about hash partitioning?

1004

Post New ETL Questions

Un-Answered Questions { ETL }

what do u do when DB time takes more?in sap bi

2206

what are the concerns of OLTP and DSS systems?

1963

What is etl tool in hadoop?

897

how would u estimate the size of Aggregator transform data and index cache?

1965

What are the names of the layers in etl?

1002

what is session partitioning?

1884

What are the three tiers in etl?

1115

What are the different Lookup methods used in Informatica?

920

what is session partitioning?

2148

what is the difference between cubes and package in cognos

4953

List few etl bugs?

952

What is etl process?

944

how do u really know that paging to disk is happening while u are using a lookup transform?

2432

what is the difference steps for data modeling?

2607

What is data modeling and data mining?

982

For More Un-Answered { ETL } Questions Click Here