We recently used the lookup transform to retrieve foreign keys in a data warehouse project, and were plain lucky to notice the following issue: When looking up padded varchar strings, the records the lookup transform considers equal differs depending
Read More...