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 7647

what are Lookup caches options? Including persistent caches.

1 4724

Difference between flat files and relational sources?

2 6094

what is session partitioning?

2040

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

2 7139

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

2562

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

2 8255

what are the different forms of normalization?

2 5629

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

7436

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

2204

what are the reporting tools and difference between them?

2006

how do u automate Extraction process?

1 4680

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

3 8000

how do u identify the changed records in operational data?

QualTech,

2474

what is SMP AND MPP?

8 64130

Post New ETL Questions

Un-Answered Questions { ETL }

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

2142

Explain about round-robi?

1080

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

2562

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

1906

Compare ETL & Manual development?

897

How can we use external procedural logic in informatica?

873

Can we create Hierarchies in generic datasources?

2328

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

965

what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?

2568

What is meant by incremental load?

1017

What are the modules in Power Mart?

894

Explain about the data integration suite features?

877

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

4860

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

891

how do use session mapping parameters ?(in which transformation)

1944

For More Un-Answered { ETL } Questions Click Here