Top Posts & Pages
- MAT (Moving Annual Total), YTD (Year to date) calculation using BottomCount, Tail, Properties function in MDX
- Dynamic Column Mapping in SSIS : Part 1
- Dynamic Column Mapping in SSIS : Part 2 (using dts variable)
- Restore SQL Server database using SAS from Azure Blob Storage
- Load Excel File Dynamically Into Database Using SQLBulkCopy and GetOleDbSchemaTable in C#
-
Recent Posts
Categories
Tag Archives: scd
Slowly Changing Dimension in SSAS Cube
This is a simple example of SCD (Type-2) in OLAP cube. We have a Dimension table for Employee and their Departments. This dimension is an SCD. One employee worked in different department over the course of time. EmpID is … Continue reading