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 are the differences between sql override and update override?
How can write SQL Overwrite to get Daynamic rows from the source in SQ transformation!(Any Example)
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
what are Lookup caches options? Including persistent caches.
Can anyone please send me the latest informatica dumps (power center 8.1.1) for all the three exams? My mail id is yokilamai@gmail.com
how to answer the question "explain project architecture" in informatica pls any one who has the answer pls send the answer to this mail id "karumanchisrinu@gmail.com
How to increase performance without changing anything in mapping.( In prod)
0 Answers IBM, Saama Tech, Wipro,
How to fine tune mappings?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
how do u set the size of block buffer?
what is session partitioning?