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 7133

what is data modeling?

2276

what is the difference steps for data modeling?

2543

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

1954

what is the difference between cardinality and Nullability?

2911

what is Forward,Reverse and Re_engineering?

2146

what is the meant by Normalization and de-normalization?

2 8586

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

2387

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

1 4233

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

1 3887

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 4610

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?

2851

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

2392

how do u set partition points in the mapping?

Quintiles,

2198

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

1 3672

Post New ETL Questions

Un-Answered Questions { ETL }

flat filevalidation in informatica

2104

Can u access a repository created in previous version of Informatica?

1824

When do we go for the tools in the market?

901

how do use session mapping parameters ?(in which transformation)

1967

what are the cubes developed in a sap bw project and what is the requirement for developing it?

2026

what is the meaning of upgradation of Repository?

3709

what are the concerns of OLTP and DSS systems?

1914

Explain and compare etl & manual development?

886

Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.

2173

Explain different types of partitioning?

981

what are the types in error loging?

2113

can be used COM component in Informatica ?

2029

two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

2022

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

1932

how many steps are there in etl process?

935

For More Un-Answered { ETL } Questions Click Here