what is diffrence b/w joner and union transfermation
- 6 Answers
- 14092 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / murali
JOINER
TRANSFORMATION:
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
mapping.
You cannot use a Joiner transformation in the following
situations:
Either input pipeline contains an Update Strategy
transformation.
You connect a Sequence Generator transformation directly
before the Joiner transformation.
UNION
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 |
Answer / nagaraju bhatraju
joiner:
joiner doesn't require marching ports to join ,
both shoud be from heterogenious sources.
union:
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 |
Answer / dillip
Joiner transformation is horizental transformation
but union is is vertical trans formation
| Is This Answer Correct ? | 4 Yes | 1 No |
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 |
Answer / ashu alle
joiner transformation supports homogenious and
heterogenious data..
union transformation supports only heterogenious data
| Is This Answer Correct ? | 1 Yes | 7 No |
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 |
we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.
How could we generate the sequence of key values without using sequence generator transformation in the target ??
12 Answers TCS, Tech Mahindra,
Define Pmrep command?
What is critical mapping?
i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?
why we use source qualifier transformation?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200
Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
how can we run workflow with pmcmd?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Teradata 
