Fuzzy Lookup vs Normal Lookup – SSIS
2018-06-29
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