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 7289

what is data modeling?

2322

what is the difference steps for data modeling?

2606

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

2002

what is the difference between cardinality and Nullability?

2950

what is Forward,Reverse and Re_engineering?

2203

what is the meant by Normalization and de-normalization?

2 8731

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

2416

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

1 4305

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

1 3952

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 4689

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?

2896

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

2432

how do u set partition points in the mapping?

Quintiles,

2245

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

1 3729

Post New ETL Questions

Un-Answered Questions { ETL }

what is pmrep command?

2443

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1970

What are cubes and olap cubes?

989

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1958

What is tracing level and what are the types?

968

can be used COM component in Informatica ?

2065

How many steps etl contains?

949

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

2183

Explain about etl data integration software?

894

what is the meaning of upgradation of Repository?

3748

Explain about round-robi?

1157

Can we create Hierarchies in generic datasources?

2387

What is fact? What are the types of facts?

1120

What are the etl testing operations includes?

1115

can cubes contain measures ?

2034

For More Un-Answered { ETL } Questions Click Here