{"id":5256,"date":"2026-02-25T08:43:39","date_gmt":"2026-02-25T07:43:39","guid":{"rendered":"https:\/\/www.beeminds.nl\/insights\/what-is-scd2"},"modified":"2026-02-25T08:43:39","modified_gmt":"2026-02-25T07:43:39","slug":"what-is-scd2","status":"publish","type":"knowledge_pt","link":"https:\/\/www.beeminds.nl\/en\/insights\/what-is-scd2","title":{"rendered":"What is SCD2?"},"content":{"rendered":"<p>SCD2 stands for &#8220;Slowly Changing Dimension Type 2.&#8221; It is a widely used technique in data warehousing and data modeling to track and manage changes in dimensional data. &#8220;Dimensions&#8221; are attributes used to organize data, such as customers, products or locations.  <\/p>\n<p>SCD2 handles situations where dimension data changes over time, and it is especially useful for historical analysis and reporting. Here are the main features of SCD2: <\/p>\n<ul>\n<li>\n<p><strong>Historical tracking:<\/strong><br \/>\n SCD2 tracks how dimension data changes over time by adding new records for each change, rather than overwriting existing records.<\/p>\n<\/li>\n<li>\n<p><strong>Effective date ranges:<\/strong><br \/>\n Effective date ranges are recorded for each version of a dimension record, allowing you to see when a specific version of the record was valid.<\/p>\n<\/li>\n<li>\n<p><strong>Historical Reporting:<\/strong><br \/>\n SCD2 allows users to create historical reports based on the historical versions of dimension data.<\/p>\n<\/li>\n<\/ul>\n<p>A common SCD2 example is a customer dimension. If a customer&#8217;s name changes, for example, with a company name change, SCD2 would create a new line with the updated name and an end date for the old record. This allows users to continue to view customer identity in the past and present.  <\/p>\n","protected":false},"excerpt":{"rendered":"<p>SCD2 stands for &#8220;Slowly Changing Dimension Type 2.&#8221; It is a widely used technique in data warehousing and data modeling to track and manage changes in dimensional data. <\/p>\n","protected":false},"featured_media":0,"template":"","knowledge_type":[58],"knowledge_category":[],"class_list":["post-5256","knowledge_pt","type-knowledge_pt","status-publish","hentry","knowledge_type-simplified"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.beeminds.nl\/en\/wp-json\/wp\/v2\/knowledge_pt\/5256","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.beeminds.nl\/en\/wp-json\/wp\/v2\/knowledge_pt"}],"about":[{"href":"https:\/\/www.beeminds.nl\/en\/wp-json\/wp\/v2\/types\/knowledge_pt"}],"wp:attachment":[{"href":"https:\/\/www.beeminds.nl\/en\/wp-json\/wp\/v2\/media?parent=5256"}],"wp:term":[{"taxonomy":"knowledge_type","embeddable":true,"href":"https:\/\/www.beeminds.nl\/en\/wp-json\/wp\/v2\/knowledge_type?post=5256"},{"taxonomy":"knowledge_category","embeddable":true,"href":"https:\/\/www.beeminds.nl\/en\/wp-json\/wp\/v2\/knowledge_category?post=5256"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}