if i hv 6 table as source table but can i make 12 as a dim
table and 6 as fact table belongs to that src table.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

Separate from an archive server and a powerhouse?

0 Answers  


what is fact table?

9 Answers  


How to view and Generate Metadata Reports?

1 Answers  


I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

5 Answers   Patni,


Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance

3 Answers  






i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow

3 Answers   Wipro,


From where you extract the data, how you did it into informatica? explain....

1 Answers   Accenture, Unisoft Infotech,


How to join three sources using joiner? Explain though mapping flow.

0 Answers  


how can i invoke pmcmd in command line prompt

1 Answers  


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

0 Answers   iGate,


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

0 Answers  


What are the data movement modes in informatcia?

1 Answers  


Categories