ETL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

ETL Interview Questions

Questions Answers Views Company eMail

Eliminating of duplicate records without using dynamic lookups

IBM,

4 15519

what are Lookup caches options? Including persistent caches.

1974

Difference between flat files and relational sources?

Satyam,

2241

what is session partitioning?

1 4459

how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

CTS,

2 7244

Identifying the bottlenecks in various components of Informatica and resolving them.

2 6028

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

1965

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

1961

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

QualTech,

1 3251

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

2128

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?

1893

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?

2035

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

1983

how do u set partition points in the mapping?

2596

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

2263

Post New ETL Questions

Un-Answered Questions { ETL }

if i have a query as flat file how can we load data to target table

1398

what is Forward,Reverse and Re_engineering?

2196

1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?

2117

what do u do when DB time takes more?in sap bi

2205

what is the use of server manager?

2137

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?

2035

What are the etl testing operations includes?

1111

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

2440

Give the benefits of data integration suite?

921

Explain the use lookup tables and Aggregate tables?

977

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.

2212

how do u set partition points in the mapping?

2596

can be used COM component in Informatica ?

2059

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

961

What are the names of the layers in etl?

1001

For More Un-Answered { ETL } Questions Click Here