Interested to Buy Any Domain ? << Click Here >> for more details...
what is the mechanism of the Master-Detail joining
condition?
- 6 Answers
- 10374 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 is the format of informatica objects in a repository?
How to generate sequence numbers without using the sequence generator transformation?
What are the guidelines to be followed while using union transformation?
What are the different components of powercenter?
What is enterprise data warehousing?
what is the -ve test case in your project.
define galaxy repository in informatica
what are the Methods For Creating Reusable Transformations?
How can we delete duplicate rows from flat files?
generate date / time dimension in informatica
How do you handle two sessions in Informatica
Explain what is informatica metadata and where is it stored?
How are indexes created after completing the load process?
Why filter transformation is an active one?
What is Index Caches size?
