What do slowly changing dimensions (SCDs) represent to a database designed for decision-support?
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...
The status bar displays the ribbon as well as the Quick Access Toolbar directly above it
Indicate whether the statement is true or false
A chart template formats the chart based on the colors, fonts, and effects associated with the workbook's theme.
Answer the following statement true (T) or false (F)