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

What is Java Transformation? what are the uses of it?

0 Answers   TCS,


How to find from a source which has 10,000 records, find the average between 500th to 600th record?

3 Answers  


What is IQD file?

1 Answers  


how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me

16 Answers   Cap Gemini, IBM,


What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

0 Answers   IBM,






What are events in workflow manager?

1 Answers   Accenture, IBM,


While migrating the data from one environment to another environment how would you manage the connections?

0 Answers  


What are the popular informatica products?

0 Answers  


What could be the possible resons of locks by user?

0 Answers  


Limitation of REPLACESTR. Is there any character limitation to it.

1 Answers   CTS,


How many cubes create from a single model?

1 Answers  


what is galaxy repository?

2 Answers  


Categories