To use this option, while creating the transformation, we must configure the Lookup transformation property "Lookup Policy on Multiple Match" to Use All Values. Once created we cannot change the mode between passive and active. When ever theLookup policy on multiple match attribute is set to Use All Values. The property becomes read-only.
Implementing a Lookup As Active:
- We cannot return multiple rows from an unconnected Lookup transformation
- We cannot enable dynamic cache for a Active Lookup transformation.
- Active Lookup Transformation that returns multiple rows cannot share a cache with a similar Passive Lookup Transformation that returns one matching row for each input row.