Interested to Buy Any Domain ? << Click Here >> for more details...
What is the main difference between a Joiner Transformation
and Union Transformation?
- 5 Answers
- 31884 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / raj
Join Transformation combines data record horizontally based on
join condition.
And combine data from two different sources having different metadata.
Join transformation supports heterogeneous, homogeneous data source.
Union Transformation combines data record vertically from multiple sources, having same metadata.
Union transformation also support heterogeneous data source.
Union transformation functions as UNION ALL set operator
| Is This Answer Correct ? | 30 Yes | 2 No |
Answer / medatati satya teja ravi kiran
UNION:1)we can create multiple input groups,but only one
out put group
2)we can connect heterogeneous sources to a union
transformation
3)The union tf does not remove duplicate rows.To remove
duplicte rows, we must add another tf such as router or
filter tf
JOIN:1)Used to join source data from two related
hetorogeneous sources residing in different locations or we
can join data from the same source
2)The joiner tf remove duplicate rows...
| Is This Answer Correct ? | 8 Yes | 3 No |
Answer / ash.gadgi
Joiner Transformation merge horizontally
Union Transformation merge vertically
| Is This Answer Correct ? | 13 Yes | 9 No |
Answer / yaseen
we can create multiple input groups,but only one
out put group
Union Transformation combines data record vertically from multiple sources, having same metadata.
The structure and Data types should be same while using Union transformation
Join Transformation combines data record horizontally based on
join condition.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / swapna
A joiner Transformation is used to join data from
hertogenous database ie (Sql database and flat file )
where has Union transformation is used to join data from
the same relational sources.....(oracle table and another
Oracle table )
| Is This Answer Correct ? | 10 Yes | 32 No |
what are the real time problems generally come up while doing or running mapping or any transformation?
How does a sorter cache works?
What is the difference between OLTP and ODS?
i have source in oracle 10g,oracle 8i how will u take the data from two sources
difference between informatica 8.1.1 and 8.6
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Did u used latest transformations of 8.6.0? for what?
What are the performance considerations when working with aggregator transformation?
delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses
How to start a workflow using pmcmd command?
What is informatica metadata and where is it stored?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Teradata 
