Tag Archives: Lookup

Lookup Transformation

Posted on June 28, 2011 by

Searching a reference key value to fetch the related data from another dataset is a common database manipulation. Lookup Transformation Lookup Transformation task lookups input column with the reference dataset. Lookup transformation needs separate datasource connection. It may be a ole … Continue reading →

Posted in SSIS | Tagged , , | Leave a comment

Lookup Table

Posted on May 9, 2011 by

Just a concept. It has been already discussed by data management experts. But, I just renew the thoughts. What is OTLT (One True Lookup Table) or common lookup table or single source lookup table? It is a place or a … Continue reading →

Posted in Data Warehouse, SSIS | Tagged , | Leave a comment