1. Categories >> Software >> Data Warehouse >> ETL
  2. Suggest New Category
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.

 1635

what is the difference between date cache and lindex cache?

 1 3154

when should one create lookup transformation ?

 2 4627

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

 4270

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

 1739

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 5182

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

 1934

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

 1567

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

 1516

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

 1444

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 3561

what is dynamic insert?

 1715

what is pmrep command?

 1958

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

 1549

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

 1 2829

Post New ETL Questions

Un-Answered Questions { ETL }

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

1444

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

1659

What are the etl testing operations includes?

588

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

2049

what are the reporting tools and difference between them?

1591




Can we create Hierarchies in generic datasources?

1930

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

4457

What is fact? What are the types of facts?

537

what are the production issues in datastage?

9742

Explain about hash partitioning?

543

What are cubes and olap cubes?

589

Mention few test cases and explain them?

550

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

978

Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?

3321

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.

1639

For More Un-Answered { ETL } Questions Click Here