JOINER
|
UNION
|
Using joiner we can remove
duplicate rows
|
Union will not remove duplicate rows
|
Joiner can be Normal, Right
Outer, Left Outer, Full Outer Join
|
Union is equivalent to UNION ALL in SQL
|
In Joiner we have one
input group and one output group
|
In Union we have multiple input groups and one
output group.
|
Joiner implemented by
using Joiner Transformation in Informatica.
|
Union implemented by using Union Transformation in Informatica
|
Joiner Transformation
combines data record horizontally based on a join condition
|
Union Transformation combines data record
vertically from multiple sources
|
Joiner supports both homogenous
and heterogeneous
|
Union also supports heterogeneous(different sources)
|
Wednesday, January 30, 2013
Difference between Joiner and Union Transformation in Informatica?
Subscribe to:
Post Comments (Atom)
Tags
Architecture of UNIX
(1)
Basic Unix Commands
(1)
Data warehousing Quiestions1
(1)
Debugger
(1)
Downloads
(1)
ETL Process
(1)
Fundamentals of UNIX
(1)
Get top 5 records to target without using rank
(1)
Home
(1)
How do you perform incremental logic or Delta or CDC
(1)
Incremental Loading for Dimension Table
(1)
Informatica Complete Reference
(1)
Informatica Functions
(1)
Informatica Powercenter Architecture
(1)
informatica project
(1)
Informatica Quiestions
(1)
Informatica Quiestions3
(1)
Informatica Real time Scenarios
(2)
Informatica scenarios
(3)
Integration Testing
(1)
Introduction of Unix
(1)
Oracle Queries
(1)
Power center Client
(1)
Separate rows on group basis
(1)
TESTING-User Acceptance Test
(1)
Unit Testing
(1)
Unix
(2)
What is informatica
(1)
No comments:
Post a Comment
Thank you :
- kareem