Volume and Weight in Same Fact Table

Fact table for comparing survey responses (with relative weight)

Hi everyone, This is my first post on this forum, I'm glad I've found it and I hope someone could help me. Our problem is that we dont know how to design a fact table to store responses from a survey in order to compare then later. For example, we

Guidelines for FACT Table Design for High-Transaction Volume and High # of Measures ...

Hi All - This inquiry could actually be two questions, but the requirement is really presentation of row-wise high volume transactional data in a column-wise (columnar) FACT table. Here is a sample transactional data set: Interval Date TimeUni

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

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

Fact Table Indexing Strategy

Please explain the indexing strategy which is in use in your organisation for fact tables in your current database(oracle, sybase, db2) Specify volume as the indexing strategy may be based upon the volume of data. Is there a well laid out strategy

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

Combination of SCD2, partial snowflake, Effective and end dates in fact table

We are creating dataware housing for multitanant based systems for HR module. Requirement ?Able to report on historical data for any given data time. Active employees headcount till given date. (as of that day) Onhire and termination based on perticula

Physics James Walker 3rd Edition Volume 1 Paperback

50$ paperback Good condition call or text 8043199418 email huynhtn@vcu.edu

Craig Potter Appreciation Thread

Alrighty then...I know we all love Guy's voice and lyrics, and that he draws many of us into the music of Elbow. But I want to give some love to Craig Potter. I've always thought his keys provided a voice that's every bit as good as Guy's. The way he can

Boombastic Volume 5 & 6 Beatz Again

Tracks! 01 - Boombastic Volume 5 - Beatz Again Interlude 1 02 - Boombastic Volume 5 - Tore Bangle Mein - Stapel Gek Op Jou - Kaise Bani 03 - Boombastic Volume 5 - Row Like A Boat 04 - Boombastic Volume 5 - Jegge Jegge 05 - Boombastic Volume 5 -

Prophylactics: Any Success Stories?

I've been on Amitriptyline 50 mgs one month. I still had 3 to 4 combination tension headaches/migraines a week. I also gained 5 to 6 lbs in that one month. I am giving up. I had tried Inderal (Propanolol). It would only work at doses 80 mgs and