Bridge table for patient diagnosis

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

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

Bridge Table - Linking Facts ?

We are recording 2 sets of facts - Financial Trades and Trade Warnings. Trades Warnings occur when a certain set of related Financial Trades hit some programmed criteria. We need to to link the Trade Warning with the Financial Trades that caused the

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

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

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

Montly Snapshot views with transactional Fact table w/SCD2

I am a new at working with Dimensional Database design. I am struggling with something that probley is real easy to do, but just can't find documentation that will explain it. I want to create a monthly snapshot view of my transactional Fact table with

How do i connect 2 pcs using wireless with ESR-9850 and Dlink DIR-655 ?

As the title says, i have 2 routers (the ESR-9850 is on it's way still) and need to setup wifi for my home network. Floor 1 ------- My desktop pc. My internet connection is connected to my Innacomm W3100 Adsl modem (bridged mode) which is then

100 reasons why Madeleine was not abducted

http://blogs.news.sky.com/discussions/show.html?plckForumPage=ForumDiscussion&plckDiscussionId=Cat:746f9309-1bb1-4b07-ad11-647f5ba16800Forum:4237bf3e-0948-444d-a452-46289a2fd1f7Discussion:53085ce6-d0e9-4517-9607-a2eb2b4b9b84 class=Discussion_PostTi

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