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

Informatica - How many joins in Informatica?




664
views
asked marvit September 20, 2014 08:04 AM  

How many joins in Informatica?


           

1 Answers



 
answered By Mswami   0  
Four types of joins in Informatica:

1) Normal Join – Normal join discards all the rows of data from the master and detail source that do not match, based on the condition.

2) Master Join – Master outer join discards all the unmatched rows from the master source and keeps all the rows from the detail source and the matching rows from the master source.

3) Detail Join – Detail outer join keeps all rows of data from the master source and the matching rows from the detail source. It discards the unmatched rows from the detail source.

4) Full Outer Join – Full outer join keeps all rows of data from both the master and detail sources.
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