Tag Info

New answers tagged

0

These are general recommendations, as you do not show the full extent of your queries to be performed (which kind of analytics you plan to do). Assuming you do not need real time results, you should just denormalize your data at the end of the period, precalculate once your aggregated results on all necessary timeframes -by day, by week, by month-, and work ...


0

These are the hints: The dimension consists only of natural key (e.g. invoive's or order's number) and contains no other attributes (because they've been placed in dimensions of their own). The dimension table grows proportionately with the fact table, e.g. every time you insert new order lines into the fact table, you have to insert new OrderNumber ...


0

My understanding is you use a Degenerate Dimension when it has an outside reference to something that people may want to search on, which could be an operational system or outside the organisation reference. It is useful for the business people to see, usually because it links to something they know (another system or outside reference), so it is included. ...


0

Not really. Fact tables has rows which are a intersection of all the joined dimensions. Joining a fact table to another fact table doesn't really make sense - two facts should be joined through a conformed dimension. I don't consider it acceptable. No. Measures quantify the intersection of all the dimensions, they enable you to measure that item not change ...



Top 50 recent answers are included