1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

In Joiner Transformation, how to identify the master and
detail tables if one is from Oracle and the other is from
Sybase.

Question Posted / suresh

Answers were Sorted based on User's Feedback



In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and t..

Answer / 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

In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and t..

Answer / naidu+.k

In Joiner Transformation it maintains two sources master and
detail source.Matser Source contains less number of Records
and its supports conditional values and detail source is an
output values stores.

Is This Answer Correct ?    9 Yes 4 No

Post New Answer

More Informatica Interview Questions

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?

2 Answers   Span Systems,

HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?

11 Answers   Cap Gemini,

What is the meaning of decode in informatica?

0 Answers  

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

0 Answers  

with out using update strategy transnsformation how to update the data in mapping level

1 Answers  




Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?

6 Answers  

why we are using level option in normalizer transformation

1 Answers   TCS, Wells Fargo,

I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,

What are the different types of code pages available in informatica & how to implement it in your project?

1 Answers   TCS,

What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?

4 Answers   Cap Gemini, IBM,

I still need further explanation about the difference between active and passive transformation with some examples.Thank You

5 Answers  

What is active and passive transformation?

10 Answers  

For more Informatica Interview Questions Click Here
Categories