Multiple Choice
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
Correct Answer:
Verified
Q63: What are the record-level data transformation functions?
Q64: Transient data are never changed.
Q65: What is OLAP and what types of
Q66: Static extract is a method of capturing
Q67: A corporate information factory (CIF) is a
Q69: Explain the dependent data mart and operational
Q70: An operational data store (ODS) is a(n):<br>A)
Q71: User interaction integration is achieved by creating
Q72: A dependent data mart is filled from
Q73: Which type of index is commonly used