Kimball or not Kimball type 2 dimension (sk as primary key)

SCD Type II Design Decision

Hi, I am fairly new to dimensional modelling and have been struggling with a problem for a couple of days now. I currently have a fact table which stores incidents/problems with orders that are sent to customers. The system from which this incident dat

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

Primary Key of Dimension and Fact Tables

I've seen several people give presentations which purport to represent the Kimball Method and I've seen this done two ways. What is the current position on what should be the primary key of a dimension table? I was under the impression that we

SQL Server 2008 Date data type as dimension key

We are getting ready to migrate from Microsoft SQL Server 2005 to 2008. Currently we use an integer (in YYYYMMDD format) as the SK on our date dimension table. I am very tempted to start using the new 3-byte Date data type (which stores only the date

rationale behind dimension with Type 0 and missing Type 5

Can anyone explain in detail on what is the rationale behind having the dimension start with Type 0 and also for the missing type 5

How to handle a Type I or II dimension with a snowflaked customer sub dimension (kimball book page 337, 338)

Hello, Within Ralph his new book he describes recommanded situations for snowflaking a dimension. His example is a large customer (visitor) dimension. (page 337, 338 and figure 10-6). I find the artical good, but there is missing one part of this

Sparse dimensions, how to handle?

I've purchased the book "The Microsoft Data Warehouse Toolkit" and have reviewed it in order to build out a data warehouse solution I am currently designing. I am stuck in a spot that I don't seem to find any examples of , or am not abl

Audit Dimension Help

Hello all. I'm at the stage now where im building the audit dimension for my warehouse. I am having a little trouble figuring out a few things though. How do you aggregate the data from the error event fact table into the audit dimension? Some records

Flexiblity To Add Attributes To A Dimension And Not Process The Whole Cube/s

Hello, We are in the process of designing a DW for Games and have run into a business problem : Business users want to add attributes to a dimension and decide its level in the hierarchy on the fly. The new attributes should be availabe in reports

2 sources using Dimensional Modeling Workbook

We are using Kimballs Generic Dimensional Modeling Workbook and it is really great! But now we have 2 sources to the same target and are not sure about how to document that. Anyone now about a best practice for how to document this in the Generic

Type it Backwards

All you have to do is type the sentence above you backwards.

eswap type feature

This is a feature where your members can trade items with each other. iScripts eSwap Features # Users can swap, buy and sell items # Users can add their wish list # eBay style peer to peer feedbacks for reliability # Supports unlimited

SET1/Q. 3 Explain the different types of reading that you have to engage in as a business executive.

Q. 3 Explain the different types of reading that you have to engage in as a business executive.