1) [=, <, <=, >, >=, !=] operators can be used in join condition 2) Supports left outer join 3) Earlier a Passive transformation, 9 onwards an Active transformation (Can return more than 1 records in case of multiple match) 4) Supports SQL override 5) Connected/Unconnected 6) Supports dynamic cache update 7) Relational/FlatFile source/target
The Power Center Server uses the lookup condition to test incoming values. We compare transformation input values with values in the lookup source or cache, represented by lookup ports. The data types in a condition must match. When we enter multiple conditions, the Power Center Server evaluates each condition as an AND, not an OR.