Fact table design: Sales Transaction with multiple Discount rows

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

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

Orders Fact Table

I've been reading more and more Kimball literature and I'd like clarification on something. Transaction Fact Tables are rarely revisited because they do not need to be updated, deleted, etc but typically only appended to. He goes on to describe

1 Dimension used multiple times in 1 fact table?

Hello, I have a dimension used to store several types of 'bands' like monthly income bands, available income bands, risk bands, settlement bands etc. If I leave out all the lineage columns this is what the dimension looks like: DimBandID BandType

Factless Sales table

Hi, I was wondering if there is anything wrong with having a factless sales table? Basically all I am required to do is to count up the total number of sales that occurred each month grouped by product type. So basically all I have in my fact table

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

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

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

PerfectDisk 11 30% discount.....

Buy now! Code: CNETFIVESTARS

Converting Columns into Rows.

I have a requirement where I need to convert rows in columns. The data is quite huge there would be around 200 million records. The sample table contains only data for five months but in actual 12 months of data come in a single row and number of columns

Green CoW's Gallery

Hi there...Here's some stuff I've done. Most of them are fulfilled requests. (just showing off the stuff I already had uploaded) Hopefully you'll find something nice! GC's Resource Packs Shooter ImageSet (.CFG file not included) A free imagese

BB12 Matt Hoffman

Big Brother Cast - Matt Biography Matt Name: Matt Hoffman Age: 32 Current Residence: Elgin, Ill. Occupation: Web designer Three adjectives that describe you: Intelligent, creative and sweet-talker Favorite activities: Playing

Reasons to use a 3NF design over a Dimensional Model design for an EDW - Discussion

I've been dimensional modelling for well over 10 years, and strongly held the opinon that only a dimensional model would work for an EDW, however i'm now begining to think that there are certain requirements that lead to a 3NF design for an 'Enterprise