Interested to Buy Any Domain ? << Click Here >> for more details...
what is the mechanism of the Master-Detail joining
condition?
- 6 Answers
- 10107 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
How can you differentiate between powercenter and power map?
Where can we find the throughput option in informatica?
What is an unconnected transformation?
design of staging area?
Explain direct and indirect flat file loading (source file type) - informatica
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is the Process to creating lookup transformation in informatica
How many dimensions are there in informatica?
What is rank transformation in informatica
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What are the new features of Power Center 5.0?
What are batches?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is the difference between informatica 7.0 and 8.0?
