what is diffrence b/w joner and union transfermation
- 6 Answers
- 13617 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
write a query to retrieve the latest records from the table sorted by version(scd)
What are the popular informatica products?
How to create a non-reusable instance of reusable transformations?
what is the Default Source Option For Update Strategy Transformation?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is informatica worklet?
How do you promote a non-reusable transformation to reusable transformation?
What are the settings that you use to configure the joiner transformation?
What is joiner change?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How many transformations can be used in mapplets.
Partition, what happens if the specified key range is shorter and longer
Define the various join types of joiner transformation?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
