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

ETL Interview Questions

Questions Answers Views Company eMail

what is the difference between OLTP database and data warehousing database?

3 7296

what is data modeling?

2325

what is the difference steps for data modeling?

2610

what are the data modeling tools you have used?(polaris)

2004

what is the difference between cardinality and Nullability?

2951

what is Forward,Reverse and Re_engineering?

2206

what is the meant by Normalization and de-normalization?

2 8737

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

2420

how do u decide whether u need to do aggregations at database level or at Informatica level?

1 4309

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

1 3955

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1 4696

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2898

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

2435

how do u set partition points in the mapping?

Quintiles,

2248

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

1 3736

Post New ETL Questions

Un-Answered Questions { ETL }

can be used COM component in Informatica ?

2065

what is the difference between cardinality and Nullability?

2951

Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you

1729

flat filevalidation in informatica

2160

how many maximum session supports to multiload in teradata ??

2123

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2898

what are the data modeling tools you have used?(polaris)

2004

What is virtual Data Warehousing?

987

what are the reporting tools and difference between them?

2101

Explain etl?

990

Difference between flat files and relational sources?

2317

What is initial load and what is full load?

993

What is abap? What are idocs?

974

Can anyone explain me a scenario from banking and finance...more precisely a mapping

2502

Can we create Hierarchies in generic datasources?

2389

For More Un-Answered { ETL } Questions Click Here