Thursday, November 7, 2013

Q: Different Types of Joiners in Informatica?

Ans: There are Four Types of JOiners in Informatica.

1. Normal Join: only Gives Matching Rows from Master and Detail Tables.
2. master Outer: All the Rows in Detail Table and matched Rows from master Table.
3. Detail outer: All The Rows in Master Table and matching Rows from Detail table.
4.Full Outer: All the Rows from Master and Detail Tables.(Including Non Matching Rows)

No comments:

Post a Comment