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
- 1637 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
what is data modeling?
list and discuss two approaches for updation of target table in Informatica and how they are different.
What is data modeling and data mining?
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 load the data to fact table?
what are the types in error loging?
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 is pmrep command?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
What is full load & incremental or refresh load?
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
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
Teradata 
