How to load dimension and fact in same mapping at same
time.explain me the logic used for that scenario.



How to load dimension and fact in same mapping at same time.explain me the logic used for that sce..

Answer / isha

We can use contraint based loading in that case and after loading all the dimensions table we can load the data into fact table.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

scenario where i can use only concurrent execution of workflow.

1 Answers   Cognizant,


what is SDLC way of code development?

1 Answers  


what is lookupoverriding?

1 Answers  


I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

119 Answers   Accenture, Gcs, TCS,


What you know about transaction control transformation?

1 Answers  


what is upstream and downstream transformation?

7 Answers  


How to get EVEN & ODD numbers separately?

8 Answers  


How can informatica be used for an organization?

1 Answers  


my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4

2 Answers   Zensar,


I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?

5 Answers   Syntel,


What is union transformation?

1 Answers  


my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer

5 Answers   IBM, TCS,


Categories