Interested to Buy Any Domain ? << Click Here >> for more details...
what is diffrence b/w joner and union transfermation
- 6 Answers
- 15755 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
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is meant by lookup transformation?
What is the commit type if you have a transaction control transformation in the mapping?
expain about the tune parameters?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What will be the approach?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is the status code in stored procedure transformation?
Describe an informatica powercenter?
What is enterprise data warehousing?
Differences between connected and unconnected lookup?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What do you mean incremental aggregation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
