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

The decorator pattern allows behavior to be added to an individual object. Example c#   public abstract class BaseSalad { protected double myPrice; public virtual double GetPrice() { return this.myPrice; } } public abstract class ExtrasDecorator : BaseSalad { protected BaseSalad salad; public ExtrasDecorator(BaseSalad saladToDecorate) { this.salad = saladToDecorate; }Continue Reading