Category Archives: Data Quality

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