SCD2 and RowStartDate, RowEndDate stamping?

SCD2 Type Change Question

Guys, Need your help related to SCD2 type change. I have a table MotorCarrier and we need to keep historical records. The primary key is a column with Identity values (Primary key col name is MCId). There are multiple members belonging to a motorcarrier

Adding new fields to a live system

So, the DW DB is loaded with data of various SCD types. The data is in live use. New requirements arise that require new SCD 2 fields to be added. Backups exist of the source systems. Are there any design tips, experiences that anyone can share on

How to create transactions SCD2 from many SCD tables

Hello, During the design of a HR data mart I had a problem that was repeated in every dimension: All the dimensions are SCD type 2 and their sources are few operational tables that each table has a history records. For example: Dim Employee is buil

Business keys in Fact. Is this accepted?

It is a data warehouse optimization project and a very basic data warehouse is in place. There are a couple of dimensions with only 2, 3 columns only (<30 rows) and where the Business key can be easily interpreted. Ex: Event_Type_DIM: this has 2

SCD 2 Audit / Metadata Columns

What are the standard audit columns / meta data columns that you will create in a SCD 2 Dimension table. potentially we will get more than one data feed from the same vendor for any given day and we need to track the versions / historical changes to

Montly Snapshot views with transactional Fact table w/SCD2

I am a new at working with Dimensional Database design. I am struggling with something that probley is real easy to do, but just can't find documentation that will explain it. I want to create a monthly snapshot view of my transactional Fact table with

Combination of SCD2, partial snowflake, Effective and end dates in fact table

We are creating dataware housing for multitanant based systems for HR module. Requirement ?Able to report on historical data for any given data time. Active employees headcount till given date. (as of that day) Onhire and termination based on perticula

SSIS SCD Component

We are using (or attempting to use) the Kimball Method SSIS Slowly Changing Dimension Component for SSIS from Todd McDermid (http://kimballscd.codeplex.com/). We have run into a few issues and would appreciate some advice if anyone has used this SSIS

Require comprehensive test cases for SCD Type2