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.

what is the difference between date cache and lindex cache?

when should one create lookup transformation ?

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

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

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.

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

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

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

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

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?

what is dynamic insert?

what is pmrep command?

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

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