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

How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

2 Answers   Puma,


What is hash partition?

2 Answers  


How can yoU create or import flat file definition in to the warehouse designer?

2 Answers  


How can you change from reusable session into non-reusable session.

5 Answers   Cap Gemini,


What are the types of presistent cache in look up tr.

1 Answers   IBM,


What is surrogate key?

9 Answers  


how do u use sequence created in oracle in informatica? Explain with an simple example

6 Answers   CTS,


How can informatica be used for an organization?

1 Answers  


My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?

3 Answers  


What is informatica powercenter repository?

1 Answers  


Which gives the more performance when compare to fixed width and delimited file ? and why?

3 Answers   HP,


in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?

2 Answers   Cap Gemini,


Categories