All of the following are ways to handle changing dimensions EXCEPT:
A) overwrite the current value with the new value.
B) for each dimension attribute that changes, create a current value field and as many old value fields as we wish.
C) create a new dimension table row each time the dimension object changes.
D) create a snowflake schema.
Correct Answer:
Verified
Q26: A database action that results from a
Q27: All of the following are ways to
Q28: A class of database technology used to
Q29: Grain and duration have a direct impact
Q30: Conformed dimensions allow users to do the
Q32: _ is/are a new technology which trade(s)
Q33: _ is an ill-defined term applied to
Q34: Data that are detailed, current, and intended
Q35: Every key used to join the fact
Q36: Data that are never physically altered once
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents