SCD2: used for

Options
- maintaining current and historical information using Effective Date
- maintaining current and historical information using Versions
- maintaining current and historical information using Flags
- All of the above

CORRECT ANSWER : All of the above

Discussion Board
SCD

A Slowly Changing Dimension (SCD) is a dimension that stores and manages both current and historical data over time in a data warehouse. It is considered and implemented as one of the most critical ETL tasks in tracking the history of dimension records. SCD dimensions that change slowly over time, rather than changing on regular schedule, time-base. In Data Warehouse there is a need to track changes in dimension attributes in order to report historical data. In other words, implementing one of the SCD types should enable users assigning proper dimension's attribute value for given date.

Prajakta Pandit 03-16-2017 05:42 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲