Slowly Changing Dimension
A Slowly Changing Dimension (SCD) is a data warehousing technique for tracking and managing changes to dimension table attributes over time — such as a customer's address or a product's category — so historical analysis reflects the values that were true at the time of each recorded fact.
4 resources across 1 library
Glossary Terms(4)
Document Store Database
A document store is a NoSQL database that stores data as self-contained documents — typically JSON, BSON, or XML — each holding nested fields and arrays, allow…
OLTP (Online Transaction Processing)
OLTP (Online Transaction Processing) refers to database systems and workloads optimized for fast, high-volume execution of short, discrete transactions — typic…
OLAP (Online Analytical Processing)
OLAP (Online Analytical Processing) refers to database systems and workloads optimized for complex analytical queries — aggregations, multidimensional analysis…
Slowly Changing Dimension
A Slowly Changing Dimension (SCD) is a data warehousing technique for tracking and managing changes to dimension table attributes over time — such as a custome…