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 the difference between Active and Passive transformation?
Explain the different dimensions.
Explain what is informatica metadata and where is it stored?
What is domain and gateway node?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
How to go to the older version for a mapping?
can u any challenge your project?
draw informatica architecture 8.6 ?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is meant by active and passive transformation?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What are mapplets?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
where to store informatica rejected data? How to extract the informatica rejected data?
What are the main features of Oracle 8i with context to datawarehouse?