BRIDGE TABLES | tim

Populating Bridge Tables Technics

Hi, I'm trying to figure out which are the best practises concerning the populating and maintaining bridge tables using ETL tools. I have a transaction fact tables, and each row of it involves 1 or more rows of Departement dimension table. I gues

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

Multivalue attributes

I am working on a model for use by the fund raising unit of our university. They want to be able to do some CRM type reporting on our alumni / donor data. In creating a constituent dimension I have found that there are a large number of attributes tha

What to do when the weighting factor of a bridge table no longer seems relevant?

I have a fact table that has healthcare claims data. Since a given claim can have multiple diagnoses, I'll use a bridge table that links a bridgekey from the fact table to the bridge table. The bridge table will also have a diagnosiskey that ultimately

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

Some Practical Challenges

Hi All I am facing some challenges in my dimensional modeling and most of these are covered in many books too.But i have practical limitation for that 1st Challenge :Unbalanced Hierarchy In one of the dimension we are tracking employees and their

Dimensional modeling on HospitalStay

a different question on The Data Warehouse Toolkit, 2nd Ed. The complete guide to Dimensional Modeling. In Chapter 13 page 265 "In a hospital stay situation, however, the diagnosis group probably should be unique to the patient because it is

Intel 6 Series Chipsets - Naming Unveiled

Intel 6 Series Chipsets - Naming Unveiled Slated for release in Q1 2011, Intel's Cougar point and Sandy Bridge products are set to replace the existing Lynnfield/Clarkdale-Ibex Peak combination. The "Premium and Mainstream" desktop

Staging Activities

What are the common staging activities that the Kimball method recognizes? Traditionally I have used staging databases to 1) Decouple from the source-to-Data Mart for restartability 2) Consolidate multiple sources and source formats into a single

how to model an event log

I am trying to model the following event data: Field1 = event date, field2 = event code, field3 = location code, field4 = customer_id, fields5 to 8 are event code specific, ie.

fact table as a dimension

Hi I'm presently modeling a data mart and I would like to use a fact table as a dimension for another fact table. Is it something doable and efficient or is there a better way to do that? if yes should i just create a surrogate key and link both

Dwarf Fortress

Alright guys. Dwarf fortress is one of the best games ever, and if you haven't played it yet, you're seriously missing out. You can download the game for Windows, Linux, or Mac completely for free. Captnduck's youtube tutorials are an excellent way to

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