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

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

Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

2 Answers  


without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,


Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.

3 Answers   IBM,


Explain how to import oracle sequence into informatica?

0 Answers  


How to display null values on a target & non-null values on a target?

3 Answers  






What is a joiner transformation and why it is an active one?

0 Answers  


what is the hint? how to use it to reduce the query processing in program?

3 Answers   Cegedim,


How to Create a folder using pmrep command?

0 Answers  


What is main use of mapplet?

0 Answers  


what is the difference between static and dynamic

4 Answers   TCS, Wipro,


Without source how to insert record to target?

6 Answers  


Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

6 Answers   IBM,


Categories