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 15499

what are Lookup caches options? Including persistent caches.

1967

Difference between flat files and relational sources?

Satyam,

2230

what is session partitioning?

1 4450

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

CTS,

2 7233

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

2 6022

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

1962

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

1958

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

QualTech,

1 3244

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

2120

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?

1890

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?

1979

how do u set partition points in the mapping?

2590

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

2261

Post New ETL Questions

Un-Answered Questions { ETL }

when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

2174

What are the three tiers in etl?

1108

Compare etl & elt?

1012

Mention few test cases and explain them?

926

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

2203

what are the types in error loging?

2146

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

2426

What is meant by incremental load?

1092

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

2066

how many steps are there in etl process?

978

What are the key benefits of ETL Testing?

1047

What are your responsibilities as an etl tester?

1152

What is the difference between project backlog and product backlog?

1529

Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance

2234

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

966

For More Un-Answered { ETL } Questions Click Here