Interested to Buy Any Domain ? << Click Here >> for more details...
what is the mechanism of the Master-Detail joining
condition?
- 6 Answers
- 10185 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
difference between repository database and repository service?
What are session parameters ? How do you set them?
what is index?how it can work in informatica
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is target designer and target load order?
Design a mapping to load a target table with the following values from the above source?
Explain what are the different types of transformation available in informatica.
How can we use batches?
How do you load alternate records into different tables through mapping flow?
What are the differences between joiner transformation and source qualifier transformation?
How many number of sessions can one group in batches?
What are the tasks that can be performed using sq?
What is a grid in Informatica?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Explain incremental aggregation in informatica
