Interested to Buy Any Domain ? << Click Here >> for more details...
what is the mechanism of the Master-Detail joining
condition?
- 6 Answers
- 10213 Views
- IBM, Patni, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sbvp
the output of the join condition for master detail joining
is . macthed rows in the master source and all rows of the
detail source
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / chinni
it is nothing but the informatica server just returns the
all rows from details table and matched records from master
table.
the table which contains less records taken it as a master n
another table as a detail,b'coz for performance purposes.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Answer / radhakrishnansk
Its full outer join. achieved using joiner transformation.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / shruthi
The data which contains the primary key is called master
source and the source which contains the foriegn key is
called detail source. The joiner transformation joind the
data based on the master detail joining condition...
Hope this helps...
correct me if i was wrong
| Is This Answer Correct ? | 1 Yes | 6 No |
How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.
Can i create a lookup table without cache.
why we use materialized view over view?
What are active and passive transformations?
What is rank transform?
Enlist the tasks for which source qualifier transformation is used.
What is the difference between bitmap and btree index?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is tracing level and what are the types of tracing level?
What are roles and groups and benefits of using them?
i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/
I still need further explanation about the difference between active and passive transformation with some examples.Thank You
Teradata 
