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.
No Answer is Posted For this Question
Be the First to Post Answer
What is etl tool in hadoop?
Explain the key challenges that you face while performing etl testing.
Is apache nifi an etl tool?
what is session partitioning?
What is etl process?
How can we use external procedural logic in informatica?
Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10
what are the reporting tools and difference between them?
What is staging area referring to?
What are the names of the layers in etl?
What is tracing level and what are the types?
how do u decide whether u need to do aggregations at database level or at Informatica level?