Explain about Union Transformation
Union Transformation is an active transformation which combine the data record s vertically from multiple sources having same metadata
The Union transformation also supports heterogeneous joins
Heterogeneous join Ex: Emp(Oracle) + Employee (SQL Server)
The Union Transformation is created with two groups
1. Input Group: It can receive the data from source pipeline
2. Output Group: It provides the data for further processing or loading
All the input and output groups should have matching ports. The precision, datatype and scale should be same for all the groups
The Union Transformation functions as "UNION ALL" operator in SQL
UNION ALL allows duplicates
Differences between Sorter and Union Transformation
http://prashanthobiee.blogspot.in/2013/02/difference-between-joiner-and-union.html
Union Transformation is an active transformation which combine the data record s vertically from multiple sources having same metadata
The Union transformation also supports heterogeneous joins
Heterogeneous join Ex: Emp(Oracle) + Employee (SQL Server)
The Union Transformation is created with two groups
1. Input Group: It can receive the data from source pipeline
2. Output Group: It provides the data for further processing or loading
All the input and output groups should have matching ports. The precision, datatype and scale should be same for all the groups
The Union Transformation functions as "UNION ALL" operator in SQL
UNION ALL allows duplicates
Differences between Sorter and Union Transformation
http://prashanthobiee.blogspot.in/2013/02/difference-between-joiner-and-union.html
Pretty good post. I just came across your site and wanted to say that I’ve really enjoyed reading your posts. In any case I’ll be subscribing to your feed and I hope you will keep a good work!Cheer!
ReplyDeleteWow it is really wonderful and awesome thus it is very much useful for me to understand many concepts and helped me a lot in SAP CS Online Training. it is really explainable very well and i got more information from your blog.
ReplyDeleteGreat article power bi training
ReplyDelete