Interested to Buy Any Domain ? << Click Here >> for more details...
What is the main difference between a Joiner Transformation
and Union Transformation?
- 5 Answers
- 31963 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 is informatica? What exactly are the practical uses in real world
explain about session partitions ?
How do you join more than 3 flat files in informatica?
How can you increase the performance in joiner transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is difference between maplet and reusable transformation?
What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?
What are the types of data warehouses?
how do u move the code from development to production?
I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help
How to update records in Target, without using Update Strategy?
what is DSS?
Teradata 
