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

3 7806

what are Lookup caches options? Including persistent caches.

1 4835

Difference between flat files and relational sources?

2 6261

what is session partitioning?

2133

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

2 7278

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

2619

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

2 8389

what are the different forms of normalization?

2 5778

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

7496

how do u extract data from different data sources explain with an example?

2245

what are the reporting tools and difference between them?

2092

how do u automate Extraction process?

1 4813

without using ETL tool can u prepare a Data warehousing and maintaining?

3 8143

how do u identify the changed records in operational data?

QualTech,

2527

what is SMP AND MPP?

8 64488

Post New ETL Questions

Un-Answered Questions { ETL }

What are the three tiers in etl?

1113

How to delete data which is not in source table?

1338

Do we need an etl tool?

1010

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

2413

What is a mapping, session, worklet, workflow, mapplet?

986

what is different between sequential batch and concurrent batch and which is recommended and why?

4929

How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

1198

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

1962

what is the meant by Normalization and de-normalization?

2718

Explain do we need an etl tool? When do we go for the tools in the market?

1014

What is the difference between project backlog and product backlog?

1536

Difference between flat files and relational sources?

2310

What is meant by incremental load?

1097

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

2178

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?

2175

For More Un-Answered { ETL } Questions Click Here