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

ETL Interview Questions

Questions Answers Views Company eMail

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.

2061

what is the difference between date cache and lindex cache?

1 3897

when should one create lookup transformation ?

2 5483

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

4744

list and discuss two approaches for updation of target table in Informatica and how they are different.

2118

you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.

3 6364

where are the log files generally stored.Can you change the path of the file.what can the path be?

2446

where is the cache (lookup, index) created and how can you see it.

2017

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

2054

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

2023

what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?

1 4237

what is dynamic insert?

2211

what is pmrep command?

2441

what happens if the info.server doesn't find the session parameter in the parameter file?

1954

Can u access a repository created in previous version of Informatica?

1 3452

Post New ETL Questions

Un-Answered Questions { ETL }

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

977

SCD2 will work on only dimension tables as well as fact Table?

1406

Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.

2223

What do you understand by the term ‘transformation’?

1049

Mention few test cases and explain them?

935

What is partitioning? Explain different types of partitioning?

1247

what is a worklet?

999

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

1025

When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

988

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

1205

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

2054

Explain about etl data integration software?

897

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2044

What is cube grouping?

1089

What are three tier systems in etl?

1070

For More Un-Answered { ETL } Questions Click Here