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