Interested to Buy Any Domain ? << Click Here >> for more details...
In Joiner Transformation, how to identify the master and
detail tables if one is from Oracle and the other is from
Sybase.
- 2 Answers
- 11657 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / priyank
Its completely on a developer's discretion to decide which
source would be the master and which would be the detail.
Generally keeping in mind the performance factor, we tend to
make the source with less number of ports as the master.
| Is This Answer Correct ? | 11 Yes | 4 No |
Answer / naidu+.k
In Joiner Transformation it maintains two sources master and
detail source.Matser Source contains less number of Records
and its supports conditional values and detail source is an
output values stores.
| Is This Answer Correct ? | 9 Yes | 4 No |
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance
Can anyone please distinguish what is Inner join and Outer join
How do you set a varible in incremental aggregation
what is $$$$?
What are the basic needs to join two sources in a source qualifier?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
What are the disadvantages of Sequence Generator T/R?
How to generate a single mapping for both the historical and incremental load.
How to Create a folder using pmrep command?
What is source qualifier transformation in informatica?
what is upstream and downstream transformation?
What is event and what are the tasks related to it?
Teradata 
