Incorrect. This statement is false. The proper methods for managing
historical changes to a dimension table are:
- Overwriting the individual records with the new data
- Preserving the history by adding a version record
- Creating new tables to contain dimension history
- Maintaining partial history
Correct! The proper methods for managing historical changes to a dimension
table are:
- Overwriting the individual records with the new data
- Preserving the history by adding a version record
- Creating new tables to contain dimension history
- Maintaining partial history
Correct! Creating groups of values for attributes with many unique values,
such as income, reduces the cardinality and creates ranges that may be more
meaningful to the end-user.
Incorrect. This statement is true. Creating groups of values for
attributes with many unique values, such as income, reduces the cardinality
and creates ranges that may be more meaningful to the end-user.
Incorrect. This statement is false. The loading and refreshing
processes of the data warehouse must include housekeeping routines to manage
changes to already stored dimension attributes.
Correct! The loading and refreshing processes of the data warehouse must
include housekeeping routines to manage changes to already stored dimension
attributes