SQL Feeds - All your SQL feeds in one place.

Wednesday, May 13, 2009

Assigning surrogate keys to early arriving facts using Integration Services

by tkejser via Microsoft SQL Server Development Customer Advisory Team on 5/13/2009 5:26:00 PM

In data warehouses, it is quite common that fact records arrive with a source system key that has not yet been loaded in the dimension tables. This phenomena is known as “late arriving dimensions” or “early arriving facts” in Kimball terminology. When you see a fact record that cannot be resolved to a dimension surrogate key, the typical solution is this: Create a dummy member in the dimension table using the source system key Assign a surrogate key to this dummy member Use the newly create s ...

[ read more ]

Are We There Yet, Mom?

by KKline via Kevin Kline on 5/13/2009 5:04:00 PM

You've probably heard by now that Microsoft just announced at TechEd 2009 the next release of SQL Server, called SQL Server 2008 R2, will have a focused set of features around BI self-service and some enhancements in multi-server management.  SQLMag has a nice summary here: http://www.sqlmag.com/Article/ArticleID/102089/102089.html.  These features implement some very nice increments in functionality across the board, while continuing to advance SQL Server's lead in the BI space. Howev ...

[ read more ]

Are We There Yet, Mom?

by KKline via Kevin Kline on 5/13/2009 5:04:00 PM

You've probably heard by now that Microsoft just announced at TechEd 2009 the next release of SQL Server, called SQL Server 2008 R2, will have a focused set of features around BI self-service and some enhancements in multi-server management.  SQLMag has a nice summary here: http://www.sqlmag.com/Article/ArticleID/102089/102089.html.  These features implement some very nice increments in functionality across the board, while continuing to advance SQL Server's lead in the BI space. Howev ...

[ read more ]

Subscribe

New Feed

Product Spotlight

Recently Updated Sources

Legal Note

The content of the postings is owned by the respective author. SQL Feeds is not responsible for the contents of the postings. This site is automatically generated and cannot be reviewed for abusive content. If you find abusive content on SQL Feeds, please contact us. Designated trademarks and brands are the property of their respective owners. All rights reserved.

Advertise with us