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.

2003

what is the difference between date cache and lindex cache?

1 3806

when should one create lookup transformation ?

2 5351

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

4691

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

2060

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 6188

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

2374

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

1964

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

1985

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

1944

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 4142

what is dynamic insert?

2132

what is pmrep command?

2367

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

1881

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

1 3363

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

Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code

1950

What is tracing level and what are the types?

891

if i have a query as flat file how can we load data to target table

1337

how many steps are there in etl process?

919

Explain about etl data integration software?

843

What is abap? What are idocs?

917

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

2216

Explain the use lookup tables and Aggregate tables?

929

what are the concerns of OLTP and DSS systems?

2396

can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge

1746

Can there be sub steps of etl steps?

940

how do u set partition points in the mapping?

2527

Is hadoop a etl tool?

882

what is a worklet?

921

For More Un-Answered { ETL } Questions Click Here