Incremental loading pattern for your data warehouse

When you are tasked to build a data warehouse, you will come across the incremental loading pattern. With incremental loading you want to update (or delete) existing rows and insert new rows into your data warehouse dimensions or fact tables. Andy Leonard has done a great job posting some patterns you could follow here.

Advertisements
This entry was posted in SQL Server 2014 and tagged . Bookmark the permalink.

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