Group & Bridge tables ... and a Surrogate Key on the Fact table...

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

Bridge Table - To simply group a dimension in more than one way?

Hi, I am struggling with a simple dimensional model. In most examples that I could find the Bridge table is references directly in the fact table (via surrogate key of course). However when I try and model my scenario - the Bridge table is one level

separate fact table/different grain - do I need a bridge table

Dealing with Healthcare here. I have a fact tbl with the grain on the admission. With this admission_f, I have bridge tables for ICD9Diagnosis, another for ICD9Procedures - all works fine. I want to add labs, so I am building a separate fact table and

difference between factless fact and bridge table

Hi, In design tip 136, kimball's example on bridge table, the bridge table looks like a factless fact table. I got used to have fact less tables for linking dimensions. My understanding is to have bridge table to handle many to many relationships and

Accumulating Snapshot Fact table

I have some questions about modeling an accumulating snapshot fact table. I will take as an example a loan application analysis process. 1- I will have a 1-1 relationship between dim_application and fact_application_process (accumulating snapshot). So i

Can a fact table be used as a source for populating another fact table

Scenario: There are two source tables : 1. SRC_INV_HDR (1 million rows in a year) 2. SRC_INV_DISCREPANCIES (1lac rows in a year) Landing tables in ODS : DWI_INV_HDR DWI_DISCREPANCIES Two fact tables : 1. DWB_Invoice_hdr 2.

Conformed bridge table or factless Fact

We have a scenario. There are multiple conformed dimension tables across the business process. The dimensions are joined with factless fact tables for each business process. Can we have the same factless fact across the business process to join

Transactional detail fact table w/complimentary snapshot table. How do the two play together?

Take a detail daily banking transaction table with standard credit and debit level transactions. I want to build the accompanying snapshot that would present the higher level rollups of these lower transactions: There are about 250 daily transaction

Fact table with multiple date ?

Hi, I am modling a fact table for prisoners inscription in order to track historical changes. An admission is the hole stay comprise of one or many inscriptions usually separated by transferts between institutions. In the transactionnal system, it

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

**GROUP RULES** read and sign before you post please

Updated April 11th 2012 1.....Copyright Corner is an M-rated group.You may post "Sexy"..Boobies can show...butts can show...but genitalia must be covered...no sex acts or porn images. 2.....We will try to answer your questions to the best of our

[Wedding] Bean and Baggs :: Friday 3PM-6PM CentralTime ::

Wedding and Reception. Welcome, all, to the "legal" (at least to these forums!) joining of two lives. Baggs and I welcome you to join us in our wedding and reception, to celebrate our love and witness us coming together (not like that, you

What ethnical group do you belong to?

I am sure that this survey has been made in the past on this board, but since there are many new friends who recently joined, I find it interesting to ask the question again. My curiousity is purely scientific as I have the feeling that migraine is mainly

Group & Bridge tables ... and a Surrogate Key on the Fact table?