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

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,


If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

2 Answers  


what is hash table in informatica?

1 Answers   Zensar,


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

3 Answers  


What is depict expression change?

0 Answers  






A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?

4 Answers  


I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?

1 Answers  


My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...

2 Answers   Accenture,


From where we can start or use pmcmd?

3 Answers  


How can we integrate different flat file data in a single mapping and with in a single execution

1 Answers  


hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 Answers  


source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?

4 Answers   Polaris,


Categories