Your browser does not support JavaScript. This help page requires JavaScript to render correctly. Slowly Changing Dimensions (SCDs)
Skip Headers
Previous
Previous 		 Next
Next

Slowly Changing Dimensions (SCDs)

A Slowly Changing Dimension (SCD) is a dimension that stores and manages both current and historical data over time in a data warehouse. In data warehousing, there are three commonly recognized types of SCDs: Type 1, Type 2, and Type 3.

With the appropriate licensing, you can use OWB to define, deploy, and load all three types of SCDs. You can create slowly changing dimensions only for dimensions that use a relational implementation.


Note:

Type 1 does not require additional licensing; however, Type 2 and Type 3 SCDs require the Warehouse Builder Enterprise ETL Option. Refer to Oracle Database Licensing Information.


See Also:

Overview of Dimensions in Oracle Warehouse Builder Data Modeling, ETL, and Data Quality Guide for complete information about the types of SCDs and how to use them