Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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.

1474

what is the difference between date cache and lindex cache?

1 2877

when should one create lookup transformation ?

2 4264

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

4110

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

1578

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 4689

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

1740

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

1407

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

1362

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

1295

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 3263

what is dynamic insert?

1570

what is pmrep command?

1821

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

1392

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

1 2584


Post New ETL Questions

Un-Answered Questions { ETL }

What are the three tiers in etl?

416


How many steps etl contains?

366


what is the difference between cardinality and Nullability?

2636


What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

415


what is a worklet?

392






What is abap? What are idocs?

371


what is the use of server?

1584


what are the concerns of OLTP and DSS systems?

1801


what is Forward,Reverse and Re_engineering?

1590


how do u implement configuration management in Informatica?

4229


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

1295


how would u estimate the size of Aggregator transform data and index cache?

1852


What is the difference between Data Warehousing and Data Mining?

403


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

402


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

4298