Multivalued Dimension, bridge table, and constraints using SQL Serv...

Remedy for a Bridge Table?

Hi folks, I'm looking to get rid of my bridge table. (yes I know why whould I want to do that?) Reason being that I am using Mondrian and as far as I can tell bridge tables don't fit. My Situation: I have many facts and many Participants each

Foreign Key Constraints

Hi What is the norm in data warehouses when implementing FK constraints, is it beneficial to create them or not have them at all (SQL Server 2008) Regards Tim

Dimension with multivalue attributes

I can't seem to wrap my brain around this one, need some help. Data model is simplified for the example given here: fact: Interview dimension: applicant The grain is obviously interviews, however the users want to be able to report interview

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

Confusion - star, snowflake, bridge table

Appreciate your expert comment on following: Entities: Quote, Trade, DIRequest, Order User, Customer, Trader, Sales or Marketer and Product - User is a user who is using the system or interfacing with the system. i.e. requesting quote or placing a

Dimension Design with Multiple Data Sources (ORACLE and SQL Server)

Hi All. We have a client that is currently migrating from a legacy SQL Server (6.5) based ERP to Oracle e-Business Suite. The old legacy system was distributed in both application and database, however the application and database structure was (almost

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

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

Multi valued dimension attributes, weighting factor and cognos

Hi, we have several attributes in our product and customer dimension which might by multi valued. We modelled these as multi valued dimension attributes using bridge tables and weighting factors therein. Can anybody reference a best practice

Election Law Amendment Act No. 16 of 2005

Election Law Amendment Act No. 16 of 2005 2009 Sunday 08 Behalf of the people Presidential Council Based on the approved by the Council of Representatives and endorsed by the Presidency Council and the provisions of item (I) of Article 61,

Sandy Bridge Rig

Just built a Sandy Bridge rig with a Core i7-2600K, Asus P8P67 EVO, 8 GB G.SKILL RIPJAWS X series RAM (4GB x2), and an Asus nVidia based GTX460 graphics card. Slapped it in a Lian-Li PC-8NWX case mid-tower... and so far so good. Running only Ubuntu 10.1

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

Regarding Factless Fact Tables

Some time ago I was asked to build the BI platform for a road safety organization. The warehouse was built of three primary fact tables, each with a collection of associated dimensions. I am now trying to branch out into ETL and Warehouse design, and from

Multivalued Dimension, bridge table, and constraints using SQL Server 2005