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 7124

what is data modeling?

2276

what is the difference steps for data modeling?

2540

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

1952

what is the difference between cardinality and Nullability?

2909

what is Forward,Reverse and Re_engineering?

2143

what is the meant by Normalization and de-normalization?

2 8580

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

2385

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

1 4229

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

1 3883

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 4606

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?

2848

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

2390

how do u set partition points in the mapping?

Quintiles,

2196

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

1 3668

Post New ETL Questions

Un-Answered Questions { ETL }

What is tracing level? How many types of transformations supported by sorted input?

930

A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?

1832

Do we need an ETL tool? When do we go for the tools in the market?

904

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

932

A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?

2182

What are the key benefits of ETL Testing?

998

What is initial load and what is full load?

919

Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?

3729

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

1026

where we cannot use sorter Transformation. if we use then we will not get correct data?

2150

diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture

2504

What is data modeling and data mining?

931

What is etl process. How many steps etl contains explain with example?

910

how many steps are there in etl process?

932

What are snapshots?

939

For More Un-Answered { ETL } Questions Click Here