What is SCD ?

Options
- Summary and Combining Data
- Slowly Changing Dimensions.
- Schema Dimension
- Steadily Combining Data

CORRECT ANSWER : Slowly Changing Dimensions.

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
 
▲