Interested to Buy Any Domain ? << Click Here >> for more details...
what is the mechanism of the Master-Detail joining
condition?
- 6 Answers
- 9918 Views
- IBM, Patni, I also Faced
- E-Mail Answers
Answer Posted / juggernaut
Master: Source with less number of records
Detail: Source with more number of records
For performance tuning: Joiner cache is created to store the data at the run time for Master port.
Join transformation is implemented based on the type of join we choose from the properties tab, using the options in the join type drop down list
1.Normal join: only matches record from both the tables
2.Master outer: All the records from Master table and only matches records from Detail
3.Detail outer: All the records from Detail and only matched records from Master
4.Full outer: Produces set of all records from Master and Detail
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What all join we can perform in LOOKUP transformation?
Write the unconnected lookup syntax?
Explain the use of aggregator cache file?
Where are the source flat files kept before running the session?
What is the way to execute pl/sql script using informatica mapping?
What is a dimensional model?
What is the sql query overwrite in source qualifier in informatica
How to handle decimal places while importing a flatfile into informatica?
What is primary and backup node?
Did u used latest transformations of 8.6.0? for what?
What is the maplet?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is meant by lookup transformation? Explain the types of lookup transformation?
lookup transformation with screenshots
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
