Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 0 Answers
- 2046 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Explain do we need an etl tool? When do we go for the tools in the market?
What is tracing level?
Hi, Lookup() is what kind of join ?
how do u really know that paging to disk is happening while u are using a lookup transform?
what are Lookup caches options? Including persistent caches.
what are business components in Informatica?
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 happens if the info.server doesn't find the session parameter in the parameter file?
What do you understand by the term ‘transformation’?
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.
what happens if the info.server doesn't find the session parameter in the parameter file?
What are the names of the layers in etl?
Teradata 
