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

What is InformaticaPowerCenter?

679


What is Session and Batches?

658


what is index?how it can work in informatica

1576


Explain Dataware house architecture .how data flow from intial to end?

2120


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1647






my source is junk data how will u remove that junk data by using unix please any one replay me

3235


wf dont have integration severances how you can run?

1539


what is SDLC way of code development?

1554


Where are the source flat files kept before running the session?

620


What are multi-group transformations?

556


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

621


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

716


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1843


Differentiate between source qualifier and filter transformation?

992


Did u used latest transformations of 8.6.0? for what?

1471