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 |
|
KLang23
Posting Yak Master
115 Posts |
 Posted - 2006-02-08 : 05:14:30
|
| Hello,For a large table of measures (facts) that includes a number of bit indicators (boolean) (ie: IsOrdered_Ind, IsShipped_Ind, IsInvoiced_Ind, etc.), what is the best way to break these indicators out into a dimension(s).For example (and this is just that - a fictictous example), a table of order-related information has Region_Id, Order_Type_Id, Discount_Type_Id, Order_Amt, Order_Date, Ship_Date, Agent_Commission_Pct, IsShipped_Ind, IsInvoiced_Ind, IsWhatEver_Ind...) The Ids are usually related to lookup tables. But the indicators are my problem.My intial thought is to create a view on the fact table that includes the PK and all of these indicators in one row as opposed to creating a seperate table for each bit indicator as you would for normal lookup tables (Order_Type_Id, Revenue_Type_Id, etc..)An alternative would be to create a table with a distinct binary code for each of the possible values, but that makes things a little too complex for my taste.Any suggestions or recommendations?Thanks. |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-02-08 : 14:13:18
|
| You can create those dimensions directly of the fact table.rockmoose |
 |
|
|
|
|
|
|
|
Relational Design to support AS