Student should answer as follows: The age in years of those streaming - requires that an age attribute is added to the fact table. The member’s age at the time of the streaming could be calculate and stored in the fact table using the dob and startDate attributes to calculate the member’s age in years.
What will be an ideal response?
A database designed for decision-support will normally store data that can be several years old. During
that time the business is likely to change and this may impact on the corporate data. The star schema
has to continually evolve to support the business and this means that it is important to identify and
accommodate these changes where necessary.
Many dimension attribute values are not fixed but change over time e.g. an employee may change
department. Dimensions that have changeable attribute values are called slowly changing dimensions
(SCDs).
This requires the identification of dimensions and attributes to be tracked and decisions made on how
they are to be tracked as not all changes are significant.
You might also like to view...
A Calc spreadsheet contains a minimum of three sheets
Indicate whether the statement is true or false
Converting a smooth point to a corner point is referred to as "____."
A. locking the handles B. smoothing the handles C. breaking the handles D. blocking the handles
Alt, Shift and Control are _____ keys.
a) modifier b) ASCII c) function d) special
Use exponent rule 5 to give an expression with a single exponent:
