Slowly Changing Fact (SCF)

Star Schema

About

Slowly Changing Fact is a table that contains the data history in a fact table structure.

A slowing changing dimension contains also data history but preserve the while row

Example

A typical example of SCF data is to follow the state attribute of an order.

Scf





Discover More
Data System Architecture
Data - History (Versioning) - Historical Data

Data history (or versioning) is just the derivation of data state. It can be found in the following data structure: where a new version of data is created by committing changes. a serie of...
Data System Architecture
Data Warehouse

A data warehouse is a large central data repository of current, history and summarised data coming from operational and external sources used primarily for analysis. s is large historical databases for...



Share this page:
Follow us:
Task Runner