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.
1474list and discuss two approaches for updation of target table in Informatica and how they are different.
1578you 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 4689where are the log files generally stored.Can you change the path of the file.what can the path be?
1740what 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 are the three tiers in etl?
How many steps etl contains?
what is the difference between cardinality and Nullability?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
what is a worklet?
What is abap? What are idocs?
what is the use of server?
what are the concerns of OLTP and DSS systems?
what is Forward,Reverse and Re_engineering?
how do u implement configuration management in Informatica?
how do use session mapping parameters ?(in which transformation)
how would u estimate the size of Aggregator transform data and index cache?
What is the difference between Data Warehousing and Data Mining?
What is the difference between round-robin partitioning and hash partitioning?
what is different between sequential batch and concurrent batch and which is recommended and why?
