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

what is the process we used in joiner transformation,there
is no matching column in sources?

Question Posted / narasimha.inf

Answers were Sorted based on User's Feedback



what is the process we used in joiner transformation,there is no matching column in sources?..

Answer / emmanuel

Create a dummy port in both the sq transforamtion and join
based on the dummy values

Is This Answer Correct ?    9 Yes 0 No

what is the process we used in joiner transformation,there is no matching column in sources?..

Answer / anithaks

I think we can use Union Transformation in such case!!

Is This Answer Correct ?    0 Yes 8 No

Post New Answer

More Informatica Interview Questions

What is the difference between IN and Exists in Oracle?

3 Answers   Deloitte,

Partition, what happens if the specified key range is shorter and longer

0 Answers   Cap Gemini,

Hi, Can someone send me the DWH and Informatica FAQ's at vanibv6@gmail.com Thanks in Advance, Vani

2 Answers   Wipro,

What is IQD file?

1 Answers  

Define joiner transformation?

0 Answers  




suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?

3 Answers   TCS,

Hi All can anyone tell me where i will get Informatica training in Mumbai?

3 Answers  

What does cheating measurement mean?

0 Answers  

After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?

3 Answers   TCS,

How to create Target definition for flat files?

0 Answers   Informatica,

what is the predefined port in dynamic lookup

2 Answers  

how u know when to use a static cache and dynamic cache in lookup transformation.

9 Answers   Accenture,

For more Informatica Interview Questions Click Here
Categories