Archive

Posts Tagged ‘Datawarehouse’

Assigning surrogate keys to early arriving facts using Integration Services

May 14th, 2009 Kasper de Jonge No comments

SQLCAT has created a great guid on how to  Assigning surrogate keys to early arriving facts using Integration Services, 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.

Read the entire article here:  http://sqlcat.com/msdnmirror/archive/2009/05/13/assigning-surrogate-keys-to-early-arriving-facts-using-integration-services.aspx

Categories: BI Technical, SSIS Tags: ,

MS releases "Fast track track datawarehouse" reference architectures

February 26th, 2009 Kasper de Jonge 1 comment
Microsoft just released the press release detailing their first push into the high end, appliance DWH market. The reference architecture is preconfigured hardware running SQL Server 2008 Enterprise Edition with the following benefits to customers:
  • Per terabyte pricing
  • Linear and predictable performance
  • 1.6-32 terabytes capacity
  • A very competitive $/terabyte offering starting at around $13K (32 TB capacity) and ending at $25K (4 TB capacity)

Read more at Peter Koller:
http://peterkol.spaces.live.com/Blog/cns!68755AEAC31F9A6C!1022.entry

Categories: BI Technical, SQL Server Tags: ,