budget line item in an organizational cost
Each row in the Budget Fact table is a
snapshot of the current status of each
line item in each budget each month.
In the order transaction fact table, each line item row
includes the order number as a degenerate
dimension. Why do we want to include this order
number in the fact table?
The order number enables us to
group the separate line items on
the order and answer questions
such as “What is the average
number of line items on an order?”
The order number is occasionally
used to link the data warehouse
back to the operational database.
The order number may play a role
in the fact table’s primary key.
All of the above
On an order, there may be a shipping charge that
applies to the entire order. The dimensional modeler's
first response should be to try to force all the facts
down to the lowest level. This procedure is broadly
referred to as _________.