On:
In: Database

Normal (exact only) Lookup transformations perform exact lookups by joining data in input columns with columns in a reference dataset. Exact matching return one and only one match in the reference dataset. Exact lookup matching can use any DTS data type except DT_TEXT, DT_NTEXT, and DT_IMAGE,  DT_R4, DT_R8. In Contrast: Fuzzy Lookup transformations alsoContinue Reading