what is the mechanism of the Master-Detail joining
condition?
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 |
i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?
Could any one to tell Fact table Partitioning?
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
What are the types of data warehouses?
how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
i have 2 mapings for this 2 mapings i want use only one lookupt/r how?
What is the fact table?
if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.
What is sorter transformation?
What are the different threads in DTM process?
Howmany ways yoU can update a relational source defintion and what are they?