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

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




445
views
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.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


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!

Alert