Interested to Buy Any Domain ? << Click Here >> for more details...
what is diffrence b/w joner and union transfermation
- 6 Answers
- 15387 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 is the difference between a connected look up and unconnected lookup?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
How to use procedural logic inside infromatica?
What do you mean by blocking transformation?
What is the maplet?
What are the different lookup cache(s)?
Define mapping and session?
Define the various join types of joiner transformation?
Slowly changing dimensions, types and where will you use them
Why update strategy and union transformations are active?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is fact table? Explain the different kinds of facts.
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What are the different types of repositories created using informatica?
