Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - In joiner, how to load Master table in Target?

asked marvit September 20, 2014 07:58 AM  

In joiner, how to load Master table in Target?


1 Answers

answered By vishnoiprem   0  
Detail outer :keeps all the rows from master and only matching rows from detail.for confirmation see join types in joiner transformation designer guide.
Just in joiner,go to join condition ,put the condition as master outer join,then you get then data of matched rows from both the tables and unmatched rows from master table, then you get the data of master table,then u connected to tgt table.
   add comment

Your answer

Join with account you already have



Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!