tMap is frequently used component for joins and lookup purpose, it is also use for verity of operations and transformations, whereas tJoin is used for join and look-ups only.
tMap
|
tJoin
|
It accepts more than one input one is main and rests of the lookups.
|
It accepts only two inputs and only one is main and other one is lookup.
|
We can create more than one output
|
It has two default outputs one is "Main" and another one is " Inner join reject"
|
tMap has "inner join " and " left outer join" joining model
|
tJoin offer`s only "inner join"
|
tMap offers three match model
|
tJoin defaulted with Unique match
|
tMap allows to store data on file option for lookup data processing
|
tJoin doesn`t offer this feature
|
In tMap you can filter data using filter expression
|
tJoin doesn`t offer this feature
|
You can write transformation using expression builder at each column level
|
tJoin doesn`t offer this feature
|
No comments:
Post a Comment