|
Merge Transformation
|
Merge
JOIN Transformation
|
|
Data
from 2 input paths are merged into one
|
The
data from 2 inputs are merged with common column
|
|
Works
as UNION ALL
|
JOIN
(LEFT, RIGHT OR FULL)
|
|
Supports
2 Datasets
|
1
Dataset
|
|
Metadata
for all columns needs to be same
|
In
this Key column data type need to be same
|
|
Does
not support error handling
|
Does
not support error handling.
|
Tuesday, June 10, 2014
Difference Between Merge and Merge Join in SSIS
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment