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

Bridge table for INSURANCE
HI, I am creating the Property & casualty Insurance DW for Autopolicy I have PolicyTransactionFact, DIM_covered_item_vehicle, Policyholder_dim these are FK's in the fact table. and I created driver dimension table which has driver

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

BRIDGE TABLES
Hi In my data warehouse I have the following two dimensions Customers and Accounts, a customer can have 1 or more accounts, both are SCD Type 2 dimensions. To show the relationship between the dimensions I am considering creating a bridge

Bridge table for patient diagnosis
Hi ngalemmo or fourm members, Can I get advice on how to create a bridge table for patient diagnosis? To keep it simple, I have a patient, facilities, and doctor dimensions and one fact table. For a specific patient, I need to show all diagnosis in a

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

Get Subdimension (outrigger) count (built using Bridge Table)
Hello, How do I get the subdimension count? I have a table FactPolicyAggregate DimAutoVehicles DimAutoDrivers AutoVehicles and AutoDrivers have effective and expiration dates. How do I get the number of AutoVehicles and AutoDrivers, who

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 Problem in T-SQL
I have a T-SQL statement that is giving me problems. If the last part of the where clause is not included, runs in about 17 seconds against a 120GB DW/Star Schema SQL 2005 Enterprise Returns about 255000 rows out of about 25-30 million rows. If I

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

Multivalued Dimension, bridge table, and constraints using SQL Server 2005
I'm developing a healthcare claims data mart. The diagnoses fields in the claims data are being implemented as a multivalued dimension, which consequently requires a bridge table between FactClaims and DimDiagnosis. The bridge table contains two

Elbow's current touring strings...
Guys, anyone have any idea who the string quartet are? Do they play alone/are they for hire? LOVED their arrangements in Nottingham last night <3 google is not helping, anyone have any clues/contacts/tips to find out? tyvm

Many to Many Confusion
Hi, Just wanted to know how we can overcome or resolve Many to Many Relationship in DWH. Vishal

Drill down design
Hello, I am modeling traffic safety. For an accident, we can several vehicles and occupants. A vehicle can have several safety features. A person can have several injuries, toxicology results, safety equipment used, etc. I need to answer