what is the mechanism of the Master-Detail joining
condition?
Answer Posted / 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 |
Post New Answer View All Answers
What is a repository? And how to add it in an informatica client?
How to load data in informatica ?
Explain pushdown optimization $pushdownconfig parameter - informatica
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is a joiner transformation?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What are the limitations of joiner transformation?
How to create Target definition for flat files?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What are the data movement modes in informatica?
How many ways are there to create ports?
How can we create index after completion of load process?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What are the different options available for update strategy?
Can we create multiple integration service on single repository?