what is the mechanism of the Master-Detail joining
condition?
Answer Posted / 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 |
Post New Answer View All Answers
What's the layout of parameter file (what does a parameter file contain?)?
Explain sql transformation in script mode examples in informatica
What are the tasks that can be performed using sq?
What you know about transaction control transformation?
Describe an informatica powercenter?
Explain sessions. Explain how batches are used to combine executions?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is decode in static cache?
What is Index Caches size?
What is the sql query overwrite in source qualifier in informatica
Enlist the tasks for which source qualifier transformation is used.
What is the cumulative sum and moving sum?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.