how to load the data to fact table?
No Answer is Posted For this Question
Be the First to Post Answer
what is the difference between OLTP database and data warehousing database?
in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?
What is lookup table in etl testing?
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 are the session parameters? How do u set them?
What is the main difference between peek stage and copy stage
In Which Transformation We Can Use Having Clause In Informatica?
how do u really know that paging to disk is happening while u are using a lookup transform?
how would u estimate the size of Lookup transform data and index cache?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
what are business components in Informatica?
How to Check the source record count from traget table.