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

Differentiate between joiner and lookup transformation?

0 Answers  


Define informatica repository?

2 Answers   Wipro,


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

0 Answers  


what type of problem you faced insales project or insurance project

1 Answers   Sony,


what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 Answers  






Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

0 Answers  


Diffrence between 7.1,8.1 and 8.6

3 Answers   HCL, Wipro,


create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,


Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

4 Answers   IBM, Infotech,


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

2 Answers   Wipro,


how did u understand business requirement?

2 Answers   TCS,


what is filelist concept in informatica

4 Answers  


Categories