Fact table design

Fact table design - Showing something that did not occur

Hi everyone, I got a question about how to handle a situation with a user need. I have created a fact table factClassesStudentAttended. Those classes are for paramedic. The user wanted to know wich student took what classes and what was the

Fact Table Design

Hello everyone....first post so please ignore my naivety..... The Fact tables that I have seen created have all been very 'standard' i.e. typically one line per order (as an example) and the resultant cube aggregations generally have been simple to

Fact table design: Sales Transaction with multiple Discount rows

Hi, I am designing a Sales DW where we can have multiple discounts on a given transaction line. I created a SalesTransaction (ST) fact table and a SalesDiscount (SD) fact table. In the current design the ST table has its own key that is a bigint

Transaction Fact design

hi I am faced with a problem designing a transaction fact in an investment firm. each transaction represents a trade the traders put in (buy,sale etc). The problem I am facing is: the metrics of a transaction change from one day to another day so a

Question on Multiple fact table design

I have the following relationships in the First Pass at a design for our datamart. DimClaim ClaimKey ,,,other

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.

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

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

2 fact at different granuality demanding different level of a dimension hierarchy.

Hi, Here is what i am trying to design. There is a transaction level fact table say Fact1.. One of the dimensions for this fact table is Dim1, which has hierarchy as L1>L1>R1.. leaf to root. The Leaf node (L1) of the dimension is Foreign key in the

The bumping thread

The game is just simple You can always bump this thread up whenever it is going down or sinking

Review buat posting Logo TKJ

download link http://img25.imageshack.us/img25/7837/logotkj.jpg hhmmmm....

Attendance Thread

Post here for the attendance thread. XD