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

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 dashbords?

1 Answers   IBM,


Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?

2 Answers   Infotech,


How to convert flat file into xml file? How to tune joiner?

2 Answers   Accenture,


i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...

4 Answers   Keane India Ltd,


how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z

3 Answers   CTS,






explain one complex mapping with logic? sales project?

0 Answers   Accenture, JPMorgan Chase,


What are the different transaction levels available in transaction control transformation?

0 Answers   Informatica,


What is the sequence generator transformation in informatica?

0 Answers  


how can we check whether a particular cache is static or dynamic?

1 Answers   InfoCepts, TCS,


update strategy transformation in informatica

0 Answers   Informatica,


design of staging area?

0 Answers  


Can you start a session inside a batch individually?

2 Answers  


Categories