Dimension Record Comes and Gos

Dealing with Duplicate Dimension Rows

A recent acquisition has added complexity to the Customer dimension and associated fact tables at the company I work for. The root of the problem is that we now have around 20 sources of customer and associated sales facts. We have data quality processe

Handling "Unknown" Dimension atrributes that are Type 2 changes

In the data warehouse we're building, we've got an Employee dimension that has a self referencing attribute called ReportsTo which stores the surrogate key of their line manager who is also in the DW (in most cases). This attribute is a type 2 change as w

Assign default value for a dimension

Hi, We have the following case: For the product code in the source data, lookup the product natural key in the product dimension and assign the surrogate key returned by the lookup to the fact. If the lookup fails, assign the unknown product whose

Large number of snowflake code tables per dimension

Ten(10) or so key dimensions(lets call them base dimensions) each has about 25 parent code tables in the 3rd normal operational source. Each code has a short and long description. In the multidimensional model If a fact table has say 3 base dimensions the

Gigantic 17 x 17 x 17 Rubik's Cube shatters world record, requires huge hands

Tyson Mao might have some sick Rubik's Cube skills, especially when he solves it behind his back with his eyes blindfolded, but I'd like to see him try Shapeway's ginormous 17 x 17 x 17 Rubik's Cube. In only what I believe can be the ultimate geekery,

Questionnaire for medical record entries

Good afternoon, I am currently working on a data warehouse in the health care sector and I currently facing this problem: The aim of this warehouse is to have an overview of a cancer therapy. So, I have created the following fact table

How to record the PDF popUp in Selenium IDE?

Hi, How to record the PDF Popup in selenium IDE. In my application there is link of "Report" on the clicking of which "PDF" popup is populating. IF i'll click 'oK' on POPUP only that pdf will open. But the issue is POpup is not

SSIS SCD Component

We are using (or attempting to use) the Kimball Method SSIS Slowly Changing Dimension Component for SSIS from Todd McDermid (http://kimballscd.codeplex.com/). We have run into a few issues and would appreciate some advice if anyone has used this SSIS

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

Radio 2 in Concert 27-10-11 Manchester Cathedral

Sure there'll be plenty who've recorded it themselves, but if you couldn't and you have posted on this forum at least 5 times, PM me with your email address to be invited to a Dropbox folder. If you're a non-registered 'lurker' who wants access to

Cast of thousands / Leaders deluxe editions

http://www.amazon.co.uk/Leaders-Free-World-Elbow/dp/B005DCWDS2/ref=pd_rhf_p_t_1 http://www.amazon.co.uk/Cast-Thousands-Elbow/dp/B005DCWD8C/ref=sr_1_2?s=music&ie=UTF8&qid=1317203030&sr=1-2 and on

Bridge Table and Customer Hierarchy

Does anyone know of a good detailed reference that discusses populating and maintaining customer hierarchy type bridge tables? The only decent resource I've found is the "The Data Warehouse ETL Tool Kit", but it only briefly shows an example on