In Joiner Transformation, how to identify the master and
detail tables if one is from Oracle and the other is from
Sybase.
Answer Posted / 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 |
Post New Answer View All Answers
what is song in infrmatica...?
What if the source is a flat-file?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How to join three sources using joiner? Explain though mapping flow.
What are session parameters ? How do you set them?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What do you mean by filter transformation?
How you prepared reports for OLAP?
what is the Default Source Option For Update Strategy Transformation?
What is rank transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is xml source qualifier transformation in informatica?
What are batches?
Explain about Informatica server process that how it works relates to mapping variables?
What is data transformation manager process?