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 15280

what are Lookup caches options? Including persistent caches.

1895

Difference between flat files and relational sources?

Satyam,

2176

what is session partitioning?

1 4367

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

CTS,

2 7110

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

2 5893

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

1906

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

1921

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

QualTech,

1 3161

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

2077

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?

1846

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?

1956

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

1932

how do u set partition points in the mapping?

2527

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

2216

Post New ETL Questions

Un-Answered Questions { ETL }

What do you understand by active and passive transformations?

883

What is partitioning? Explain about round-robin, hash partitioning.

897

How to delete data which is not in source table?

1269

Explain about enterprise scalability and roi of data integration suite?

833

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

2378

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

915

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

2142

flat filevalidation in informatica

2091

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4050

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.

2004

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

892

how do u handle performance issues in Informatica . where can u monitor the performance ?

4691

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?

1821

What is the difference between round-robin partitioning and hash partitioning?

918

What are snapshots?

931

For More Un-Answered { ETL } Questions Click Here