|
When is Facts and Derived Facts Table used?
Please refer to Facts+
Derived Facts matrix in Data Warehouse
Dimensional Modeling Process for the context of this
template.
This template is used during dimensional
model phase. After a provisional list of data marts have been lined
out and we know the fact table grains, its time to now set-up Foundation
facts and any derived facts. This one exercise has to be done keeping
in mind at least the medium term application of the fact.
Why is it used?
This is a single point capture of
all the facts- base as well as derived. The language and other aspects
of these category of templates should be business friendly, as they
have to sign-off on the same. |
