Category Archives: DataWareHousing

How to check for Contiguous Dates

Let’s say we have an SCD 2 Dimension called Dimension.Store. ┬áLets assume the Business Key is BranchCode and the type II rows is versioned using RowStartDate & RowEndDate ┬ácolumns. How do we verify if the dates are contiguous with no … Continue reading

Posted in Data Quality, DataWareHousing, Uncategorized | Leave a comment

SSIS ETL Framework

  In my current job, we have a custom ETL framework to control the execution of SSIS packages. Some of the features of our ETL framework is as follows: a) Control the execution of packages using metadata tables We use … Continue reading

Posted in BusinessIntelligence, DataWareHousing, SSIS | Leave a comment