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 a router transformation?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Different qualification between a related rotate toward the sky and isolates look upward?
can we override a native sql query within informatica? How do we do it?
What is the sql query overwrite in source qualifier in informatica
What is lookup change?
What are the new features of Power Center 5.0?
What is the meaning of up gradation of repository?
Enlist the tasks for which source qualifier transformation is used.
how to load dimension table and fact table. plz tell me the steps.
r u done any partitions in ur project?
How can we use batches?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How many dimensions are there in informatica?