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

ETL Interview Questions

Questions Answers Views Company eMail

Can there be sub steps of etl steps?

1031

What are the etl testing operations includes?

1115

What are the various tools used in etl?

1050

What is partitioning? Explain different types of partitioning?

1245

What do you understand by active and passive transformations?

946

What are the names of the layers in etl?

1002

What are the different etl testing categories as per their function?

1082

how many steps are there in etl process?

983

What is meant by incremental load?

1100

Compare etl & elt?

1017

Explain etl?

988

When do we analyze the tables?

978

What is full load & incremental or refresh load?

1209

What is tracing level?

1076

what is a worklet?

999

Post New ETL Questions

Un-Answered Questions { ETL }

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

1970

what are the data modeling tools you have used?(polaris)

2002

what is a worklet?

999

Compare etl & elt?

1017

what is data modeling?

2322

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

2036

What is data modeling and data mining?

982

What are the different Lookup methods used in Informatica?

920

What are your responsibilities as an etl tester?

1166

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

1937

what are the session parameters? How do u set them?

2051

What is tracing level?

1076

Explain about round-robi?

1157

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

4933

Explain me ETL project architecture in Detail?

2375

For More Un-Answered { ETL } Questions Click Here