Friday, January 9, 2015

Difference between tMap and tJoin

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


  1. Unique Match
  2. First Match
  3. All Matches


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

Contact Us

Name

Email *

Message *