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 7093

what is data modeling?

2264

what is the difference steps for data modeling?

2522

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

1938

what is the difference between cardinality and Nullability?

2901

what is Forward,Reverse and Re_engineering?

2128

what is the meant by Normalization and de-normalization?

2 8561

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

2372

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

1 4213

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

1 3869

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 4577

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?

2839

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

2377

how do u set partition points in the mapping?

Quintiles,

2181

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

1 3640

Post New ETL Questions

Un-Answered Questions { ETL }

Mention few test cases and explain them?

889

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

1931

What are the three tiers in etl?

1031

what is pmrep command?

11486

What is a mapping?

937

what is data modeling?

2264

how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)

2626

SCD2 will work on only dimension tables as well as fact Table?

1344

What is tracing level?

1010

what is an ETL or ETT? And what are the different types?

7436

Explain the use lookup tables and Aggregate tables?

929

what is the use of server manager?

2059

what are the concerns of OLTP and DSS systems?

1899

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.

2155

Explain what are the various etl tools in the market?

883

For More Un-Answered { ETL } Questions Click Here