Category Archives: Uncategorized

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

Blog on Microsoft BI

Hi, I am Jegan, working as a BI developer in Bristol, UK. This is a blog focussing on BI- specifically Microsoft BI -SSIS, SSRS, SSAS. I will also be covering Automated deployment using MSBuild, Automated testing of SSRS reports & SSIS packages, internals … Continue reading

Posted in Uncategorized | Leave a comment