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.

2056

what is the difference between date cache and lindex cache?

1 3886

when should one create lookup transformation ?

2 5468

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

4737

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

2108

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 6343

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

2440

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

2017

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

2047

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

2014

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 4229

what is dynamic insert?

2202

what is pmrep command?

2435

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

1945

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

1 3440

Post New ETL Questions

Un-Answered Questions { ETL }

what is data modeling?

2314

What are the different Lookup methods used in Informatica?

918

explain the methodology of Data Warehousing?(Polaries)

2293

What is etl tool in hadoop?

894

What are snapshots?

980

What are the differences between sql override and update override?

1100

Difference between flat files and relational sources?

2309

how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

2537

In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?

933

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2035

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

2199

Explain different types of partitioning?

1042

What are your responsibilities as an etl tester?

1160

What is a materialized view log?

998

how do u really know that paging to disk is happening while u are using a lookup transform?

1983

For More Un-Answered { ETL } Questions Click Here