Painted into a healthcare DW "digital corner" -- or is it wrong to ...

Modeling Healthcare Measurements

I'm trying to figure out how to best model a DataWarehouse Star Schema structure to capture certain medical information that will answer the questions we ask. First the questions to put in some context: 1) How many distinct patients had a BMI in the

Dimension table with no business key?

We have a CustomerAddress dimension table that will have a surrogate key assigned only. The customer address information will come down on both the CustomerOrder and CustomerShipmentInfo files (Bill To Customer and Ship To Customer). We have never had a

Derived Fact table with additional measures / foreign keys ... ?

Hi, Let's say we have a fact table: FactReceipt which contains all our receipting transactions that occur during the month, we may have 5 receipts of different types during one month for one contract. Now let's say we build another fact table that

Business keys in Fact. Is this accepted?

It is a data warehouse optimization project and a very basic data warehouse is in place. There are a couple of dimensions with only 2, 3 columns only (<30 rows) and where the Business key can be easily interpreted. Ex: Event_Type_DIM: this has 2

Adding new attributes to a dimension

We're an Oracle 10g warehouse site and still get nervous when adding new attributes to our ageing dimensions. The issue stems from not being able to reorder columns in Oracle. So your new attributes either sit at the bottom of the table (not good) or yo

HBGary may have stolen the concept of their flagship product "Digital DNA"

just found this: ------------ The True Origins Of Malware DNA I would like to call the worlds attention to the fact that HBGary, as I thought originally completely RIPPED my concept of Malware DNA as I succinctly described it to them in great detai

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

DF Troubleshooting - Something is wrong with the UB Funkey...

Something is wrong with the UB Funkey... by revvinon If you place a funkey on the UB hub and you get a message saying "Something's wrong with the U.B. Funkey, can you check it for me?" try the following: 1) Unplug the UB hub from USB

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

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

SINGLE PARENT (NASA MALAYO,INIWANAN,LUMISAN ANG PARTNER)

To all single parents out there,this one is for us. My wife is working abroad. Ako nanay/tatay ng 2 kids namin. Mahirap lalo na pag may karamdaman mga bata. Tiis -tiis lang lalo na pag tag-li**g.Avail sa mga contacts sa mtc or od.Hehehehee!

McGregor

Does anyone know where i can get hold of this fab tune in MP3 audio? Or any digital format to be honest? I have the song on the Leaders DVD but really want it on me iPod. Not quite sure how to rip it from my dvd.

Sneak Peek - AOC Breeze

The AOC Breeze is a 8 inch tablet running Google's Android OS. Whilst the price tag might classify the Breeze as a budget segment tablet, its list of features says otherwise. With a USB2.0 port, Micro SDcard reader, 4GB internal memory, and WiFi b/g, this

Painted into a healthcare DW "digital corner" -- or is it wrong to have keys and attributes in a single table