Interested to Buy Any Domain ? << Click Here >> for more details...
what is diffrence b/w joner and union transfermation
- 6 Answers
- 15386 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 |
Why we need XMLs?
which quality process u can approach in ur project
There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks...
I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have, source having 10records. Same with incrementally. Please answer me ASAP.
Name 4 output files that informatica server creates during session running?
when informatica 8 series released ?
What is limitations of truncate and load option
What does role playing dimension mean?
i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...
Explain pushdown optimization and types in informatica
My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000
Teradata 
