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


Please Help Members By Posting Answers For Below Questions

How are the sources and targets definitions imported in informatica designer?

769


What are the modules in Power Center

1316


Differentiate between a database and data warehouse?

752


Differences between connected and unconnected lookup?

729


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

4981






How many types of sessions are there in informatica.please explain them?

775


What is a shortcut and copy in Informatica and how two are different with each other?

788


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

760


Explain your project of banking domian.

1290


What are the tuning techniques you applied during your last project

1660


How to do unit testing in informatica?

831


Enlist the differences between database and data warehouse.

638


Where is metadata stored?

699


list out all the transformations which use cache?

772


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

751