Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Taurkon
Starting Member
26 Posts |
 Posted - 2007-05-02 : 17:16:16
|
| In our staging area before we move data to a warehouse, we have a COSTS table that contains an additive amount value, and a related table BUCKET_TYPE that relates each row in COSTS to a bucket it belongs to.When our warehouse was initially designed, a the data for the fact table was collected and dropped into the COST fact table using a pivot query. The result of the pivot query was a column for each bucket. So in essence, we ended up with a fact table with 53 measures.FACT TABLE DEFINITION (ID's represent FKs for 11 dimensions)ID1ID..11AMT_BUCKET1AMT_BUCKET2AMT_BUCKET3AMT_BUCKET...53My question is, does it not make more sense to create a BUCKET dimension and have a single AMOUNT measure in the dimension table? Each month, there will be approx 20 million rows added to the FACT table.Thanks for your opinions. |
|
|
|
|
|
Dimensional Modeling design question