Automate Type 2 Slowly Changing Dimension in Snowflake - Part 1 | Rajiv Gupta Learn Everyday

A slowly changing dimension (SCD) in data management and data warehousing is a dimension which contains relatively static data which can change slowly but unpredictably, rather than according to a regular schedule. Some examples of typical slowly changing dimensions are entities as names of geographical locations, customers, or products.
For example, a database may contain a fact table that stores sales records. This fact table would be linked to dimensions by means of foreign keys. One of these dimensions may contain data about the company's salespeople: e.g., the regional offices in which they work. However, the salespeople are sometimes transferred from one regional office to another. For historical sales reporting purposes, it may be necessary to keep a record of the fact that a particular sales person had been assigned to a particular regional office at an earlier date, whereas that sales person is now assigned to a different regional office.[clarification needed]
Dealing with these issues involves SCD management methodologies referred to as Type 0 through 6. Type 6 SCD's are also sometimes called Hybrid SCD's.

To get timely notification and to enjoy all cool demo & technical details. Please follow me on →   / rajivgupta780184   & subscribe to my YouTube Channel →    / rajivguptaeverydaylearning  

Blog:   / automate-type-2-slowly-changing-dimension-...