Interested to Buy Any Domain ? << Click Here >> for more details...
what is diffrence b/w joner and union transfermation
- 6 Answers
- 15620 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are batches?
Explain transaction control transformation in informatica
What does refresh system mean, and what are its distinctive choice?
Explain about cumulative Sum or moving sum?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What are active transformations.
Separate from an archive server and a powerhouse?
How will the document be delivered to me?
What is InformaticaPowerCenter?
What are the popular informatica products?
What are the different types of repositories created using informatica?
Global and Local shortcuts. Advantages.
how we can load rejected record's at run time?(not through bad files)
How to delete duplicate row using informatica?
As union transformation gives UNION ALL output, how you will get the UNION output?
