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 7087

what is data modeling?

2261

what is the difference steps for data modeling?

2519

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

1936

what is the difference between cardinality and Nullability?

2898

what is Forward,Reverse and Re_engineering?

2125

what is the meant by Normalization and de-normalization?

2 8554

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

2369

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

1 4209

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

1 3864

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 4574

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?

2836

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

2374

how do u set partition points in the mapping?

Quintiles,

2177

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

1 3633

Post New ETL Questions

Un-Answered Questions { ETL }

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4048

What is abap? What are idocs?

915

How etl testing is different from database testing?

964

where are the log files generally stored.Can you change the path of the file.what can the path be?

2371

list and discuss two approaches for updation of target table in Informatica and how they are different.

2056

What is grain of fact?

900

What is lookup table in etl testing?

1116

how do u extract data from different data sources explain with an example?

2202

where is the cache (lookup, index) created and how can you see it.

1963

Explain me ETL project architecture in Detail?

2309

explain the methodology of Data Warehousing?(Polaries)

2220

Is apache nifi an etl tool?

907

What is initial load and what is full load?

900

What are the different Lookup methods used in Informatica?

852

Explain and compare etl & manual development?

867

For More Un-Answered { ETL } Questions Click Here