what is the mechanism of the Master-Detail joining
condition?
- 6 Answers
- 9062 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
can anyone suggest best free Talend data integration training online
what is informatica metadata?
Explain the pipeline partition with real time example?
Enlist few areas or real-time situations where informatica is required.
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What are the different clients of powercenter?
What is the difference between source qualifier transformations source filter to filter transformation?
What is depict expression change?
What are the various types of transformation?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is a joiner transformation?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is a joiner transformation and why it is an active one?
