Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

what is diffrence b/w joner and union transfermation

Answers were Sorted based on User's Feedback

what is diffrence b/w joner and union transfermation..

Answer / murali


to join source data from two related heterogeneous sources
residing in different locations or file systems. Or, you
can join data from the same source.

If you need to join more than two sources, you can add more
Joiner transformations to the

You cannot use a Joiner transformation in the following
Either input pipeline contains an Update Strategy
You connect a Sequence Generator transformation directly
before the Joiner transformation.


The Union transformation is a multiple input group
transformation that you can use to merge data from multiple
pipelines or pipeline branches into one pipeline branch.

The Union transformation merges sources with matching ports
and outputs the data from one output group with the same
ports as the input groups.
Similar to the UNION ALL statement, the Union
transformation does not remove duplicate rows.

Is This Answer Correct ?    16 Yes 1 No

what is diffrence b/w joner and union transfermation..

Answer / nagaraju bhatraju

joiner doesn't require marching ports to join ,
both shoud be from heterogenious sources.

union requires two flows with same no of columns and both
columns of the two flows orders should be same to produce
the combined flow .

Is This Answer Correct ?    18 Yes 4 No

what is diffrence b/w joner and union transfermation..

Answer / dillip

Joiner transformation is horizental transformation
but union is is vertical trans formation

Is This Answer Correct ?    4 Yes 1 No

what is diffrence b/w joner and union transfermation..

Answer / chandrp

At the maximum a join trasformation can join only 2 tables.
but union transformation will join more than two tables at
a time.

Is This Answer Correct ?    10 Yes 8 No

what is diffrence b/w joner and union transfermation..

Answer / ashu alle

joiner transformation supports homogenious and
heterogenious data..

union transformation supports only heterogenious data

Is This Answer Correct ?    1 Yes 7 No

what is diffrence b/w joner and union transfermation..

Answer / singh.

hello Chandrp . ur answer is wrong.
in my view join T/r can join more than 2 tables
try with 3 flat files. then u will get the result.

Is This Answer Correct ?    3 Yes 21 No

Post New Answer

More Informatica Interview Questions

How can we use mapping variables in informatica?

0 Answers  

In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?

6 Answers  

write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,

If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

2 Answers   TCS,

What is a candidate key?

7 Answers   CTS,

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,

What are the scheduling options to run a sesion?

2 Answers  

what is a transforamation?

5 Answers  

if the column name in sql override is diff from the column name in source qualifier,what is the impact?

5 Answers   TCS,

what is normalizer transformation?

4 Answers   Wipro,

Does an informatica transformation support only aggregate expressions?

0 Answers  

1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),

10 Answers   Cap Gemini,