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.
1620list and discuss two approaches for updation of target table in Informatica and how they are different.
1720you 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 5139where are the log files generally stored.Can you change the path of the file.what can the path be?
1918what 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 3537
What is a lookup table in etl?
tell me few points when u become TL
What are dimensions?
what are the reporting tools and difference between them?
List few etl bugs?
When do we go for the tools in the market?
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.
Explain do we need an etl tool?
State the differences between shortcut and reusable transformation
Explain what is etl process? How many steps etl contains explain with example?
how would u estimate the size of Lookup transform data and index cache?
what is the difference between cardinality and Nullability?
how many steps are there in etl process?
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
What is abap? What are idocs?
