Home > ETL Best Practices > Slowly Changing Dimensions – No Worry (2)

Slowly Changing Dimensions – No Worry (2)

I guess this changes my design a little bit in the source data extraction stage. Instead of tracking the change histories for various dimensions, I would just get a daily snapshot copy of the source data.

So instead of implementing the source data extraction (based on last update date) like this (Inventory is a fact table).

image

A simple truncate and insert will do:

image

Similarly, when loading the dimension tables, instead of tracking the change history like this: (Note that the dimension table has an Identity column that is used as a surrogate key)

image

A simple truncate/insert will do:

image

Categories: ETL Best Practices
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: