How to create transactions SCD2 from many SCD tables

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

Building aggregate fact tables from staging

Hi, Is it acceptable to create an aggregate fact table from the staging tables after you have cleaned out the data in staging? I know usually you're supposed to create aggregate fact tables from the fact/dimension tables, however can it be done straigh

SCD2 and RowStartDate, RowEndDate stamping?

When maintaining a SCD2, Kimball recommends that the expiration (expiry) date (aka RowEndDate) of a given row should equal the RowStartDate of the newly inserted row. I'm confused by this idea. For example, if someone's region has changed from

How to create BB tables

Well, sorry about the title, I can't think of any good title. I've got a question and that is: "How to create the 'borders' like below?" You know, the borders for the announcements and important announcements. I've deleted the content so

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

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

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

SET1/Q.3 Journalize the following transactions –

Q.3 Journalize the following transactions – Jan 1st – Mr. Shetty started his business with Rs. 80,000/- which he bought as his capital in cash Jan 10th – He purchased goods worth Rs. 30,000/- in cash and Rs. 20000/- on credit. Jan 12th – He paid wages

SET2/Q.3 Journal the following transactions and...

Q.3 Journal the following transactions and post them to the various ledger accounts and prepare the trial balance as on 31st January 2004 January 1 Rao Commenced business with Rs.5000 2 Bought goods for cash Rs.2500 3 Bought office furniture for cash

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

NEW CONTEST : Create a video for Forumotion and Twilight !

NEW CONTEST : Create a video for Forumotion and Twilight ! Forumotion New Contest for Twilight Eclipse Like every major event, Forumotion has a pleasure to organize a new competition to highlight your creative talents! 1- Competition rules:

Bridge Table and Customer Hierarchy

Does anyone know of a good detailed reference that discusses populating and maintaining customer hierarchy type bridge tables? The only decent resource I've found is the "The Data Warehouse ETL Tool Kit", but it only briefly shows an example on

Regarding Factless Fact Tables

Some time ago I was asked to build the BI platform for a road safety organization. The warehouse was built of three primary fact tables, each with a collection of associated dimensions. I am now trying to branch out into ETL and Warehouse design, and from