{"id":4790,"date":"2021-10-08T06:00:41","date_gmt":"2021-10-08T05:00:41","guid":{"rendered":"https:\/\/bestdatasolutions.es\/?p=4790"},"modified":"2021-10-14T09:15:44","modified_gmt":"2021-10-14T08:15:44","slug":"slowly-changing-dimensions","status":"publish","type":"post","link":"https:\/\/bestdatasolutions.es\/en\/blog\/slowly-changing-dimensions\/","title":{"rendered":"Slowly Changing Dimensions"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"4790\" class=\"elementor elementor-4790 elementor-4789\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-187471cb elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"187471cb\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-no\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8a0c01d\" data-id=\"8a0c01d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1fbff00b elementor-widget elementor-widget-theme-post-featured-image elementor-widget-image\" data-id=\"1fbff00b\" data-element_type=\"widget\" data-widget_type=\"theme-post-featured-image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"1920\" height=\"500\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/slowly-changing-dimensions.jpg\" class=\"attachment-full size-full wp-image-4869\" alt=\"Slowly Changing Dimensions\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/slowly-changing-dimensions.jpg 1920w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/slowly-changing-dimensions-300x78.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/slowly-changing-dimensions-1024x267.jpg 1024w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/slowly-changing-dimensions-768x200.jpg 768w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/slowly-changing-dimensions-1536x400.jpg 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5d1c2c13 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5d1c2c13\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-5aae2e0d\" data-id=\"5aae2e0d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1a3ffa42 elementor-author-box--layout-image-left elementor-author-box--align-left elementor-author-box--image-valign-middle elementor-author-box--avatar-yes elementor-author-box--name-yes elementor-author-box--biography-yes elementor-widget elementor-widget-author-box\" data-id=\"1a3ffa42\" data-element_type=\"widget\" data-widget_type=\"author-box.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-author-box\">\n\t\t\t\t\t\t\t<a href=\"https:\/\/www.linkedin.com\/in\/javierriosponce\/\" target=\"_blank\" class=\"elementor-author-box__avatar\" rel=\"noopener\">\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/avatar_user_4_1633610531.jpg\" alt=\"Picture of Javier R\u00edos\" loading=\"lazy\" title=\"\">\n\t\t\t\t<\/a>\n\t\t\t\n\t\t\t<div class=\"elementor-author-box__text\">\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.linkedin.com\/in\/javierriosponce\/\" target=\"_blank\" rel=\"noopener\">\n\t\t\t\t\t\t<h4 class=\"elementor-author-box__name\">\n\t\t\t\t\t\t\tJavier R\u00edos\t\t\t\t\t\t<\/h4>\n\t\t\t\t\t<\/a>\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-author-box__bio\">\n\t\t\t\t\t\tBusiness Intelligence Consultant | Marketing Expert | Data Specialist\t\t\t\t\t<\/div>\n\t\t\t\t\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-41a959e0 elementor-widget elementor-widget-heading\" data-id=\"41a959e0\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-large\">Other Articles:<\/h3>\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-6c75b22c\" data-id=\"6c75b22c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5795bde9 elementor-widget elementor-widget-theme-post-title elementor-page-title elementor-widget-heading\" data-id=\"5795bde9\" data-element_type=\"widget\" data-widget_type=\"theme-post-title.default\">\n\t\t\t\t\t<h1 class=\"elementor-heading-title elementor-size-xl\">Slowly Changing Dimensions<\/h1>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-561b31d1 elementor-widget elementor-widget-post-info\" data-id=\"561b31d1\" data-element_type=\"widget\" data-widget_type=\"post-info.default\">\n\t\t\t\t\t\t\t<ul class=\"elementor-inline-items elementor-icon-list-items elementor-post-info\">\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-repeater-item-869d2fb elementor-inline-item\" itemprop=\"datePublished\">\n\t\t\t\t\t\t<a href=\"https:\/\/bestdatasolutions.es\/en\/2021\/10\/08\/\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-calendar\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M12 192h424c6.6 0 12 5.4 12 12v260c0 26.5-21.5 48-48 48H48c-26.5 0-48-21.5-48-48V204c0-6.6 5.4-12 12-12zm436-44v-36c0-26.5-21.5-48-48-48h-48V12c0-6.6-5.4-12-12-12h-40c-6.6 0-12 5.4-12 12v52H160V12c0-6.6-5.4-12-12-12h-40c-6.6 0-12 5.4-12 12v52H48C21.5 64 0 85.5 0 112v36c0 6.6 5.4 12 12 12h424c6.6 0 12-5.4 12-12z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text elementor-post-info__item elementor-post-info__item--type-date\">\n\t\t\t\t\t\t\t\t\t\t<time>08\/10\/2021<\/time>\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/li>\n\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7476169 elementor-share-buttons--view-icon-text elementor-share-buttons--skin-gradient elementor-share-buttons--shape-square elementor-grid-0 elementor-share-buttons--color-official elementor-widget elementor-widget-share-buttons\" data-id=\"7476169\" data-element_type=\"widget\" data-widget_type=\"share-buttons.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-grid\" role=\"list\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_linkedin\" role=\"button\" tabindex=\"0\" aria-label=\"Share on linkedin\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-linkedin\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 32H31.9C14.3 32 0 46.5 0 64.3v383.4C0 465.5 14.3 480 31.9 480H416c17.6 0 32-14.5 32-32.3V64.3c0-17.8-14.4-32.3-32-32.3zM135.4 416H69V202.2h66.5V416zm-33.2-243c-21.3 0-38.5-17.3-38.5-38.5S80.9 96 102.2 96c21.2 0 38.5 17.3 38.5 38.5 0 21.3-17.2 38.5-38.5 38.5zm282.1 243h-66.4V312c0-24.8-.5-56.7-34.5-56.7-34.6 0-39.9 27-39.9 54.9V416h-66.4V202.2h63.7v29.2h.9c8.9-16.8 30.6-34.5 62.9-34.5 67.2 0 79.7 44.3 79.7 101.9V416z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tLinkedIn\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_facebook\" role=\"button\" tabindex=\"0\" aria-label=\"Share on facebook\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-facebook\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M504 256C504 119 393 8 256 8S8 119 8 256c0 123.78 90.69 226.38 209.25 245V327.69h-63V256h63v-54.64c0-62.15 37-96.48 93.67-96.48 27.14 0 55.52 4.84 55.52 4.84v61h-31.28c-30.8 0-40.41 19.12-40.41 38.73V256h68.78l-11 71.69h-57.78V501C413.31 482.38 504 379.78 504 256z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tFacebook\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_twitter\" role=\"button\" tabindex=\"0\" aria-label=\"Share on twitter\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-twitter\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M459.37 151.716c.325 4.548.325 9.097.325 13.645 0 138.72-105.583 298.558-298.558 298.558-59.452 0-114.68-17.219-161.137-47.106 8.447.974 16.568 1.299 25.34 1.299 49.055 0 94.213-16.568 130.274-44.832-46.132-.975-84.792-31.188-98.112-72.772 6.498.974 12.995 1.624 19.818 1.624 9.421 0 18.843-1.3 27.614-3.573-48.081-9.747-84.143-51.98-84.143-102.985v-1.299c13.969 7.797 30.214 12.67 47.431 13.319-28.264-18.843-46.781-51.005-46.781-87.391 0-19.492 5.197-37.36 14.294-52.954 51.655 63.675 129.3 105.258 216.365 109.807-1.624-7.797-2.599-15.918-2.599-24.04 0-57.828 46.782-104.934 104.934-104.934 30.213 0 57.502 12.67 76.67 33.137 23.715-4.548 46.456-13.32 66.599-25.34-7.798 24.366-24.366 44.833-46.132 57.827 21.117-2.273 41.584-8.122 60.426-16.243-14.292 20.791-32.161 39.308-52.628 54.253z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tTwitter\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_whatsapp\" role=\"button\" tabindex=\"0\" aria-label=\"Share on whatsapp\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-whatsapp\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M380.9 97.1C339 55.1 283.2 32 223.9 32c-122.4 0-222 99.6-222 222 0 39.1 10.2 77.3 29.6 111L0 480l117.7-30.9c32.4 17.7 68.9 27 106.1 27h.1c122.3 0 224.1-99.6 224.1-222 0-59.3-25.2-115-67.1-157zm-157 341.6c-33.2 0-65.7-8.9-94-25.7l-6.7-4-69.8 18.3L72 359.2l-4.4-7c-18.5-29.4-28.2-63.3-28.2-98.2 0-101.7 82.8-184.5 184.6-184.5 49.3 0 95.6 19.2 130.4 54.1 34.8 34.9 56.2 81.2 56.1 130.5 0 101.8-84.9 184.6-186.6 184.6zm101.2-138.2c-5.5-2.8-32.8-16.2-37.9-18-5.1-1.9-8.8-2.8-12.5 2.8-3.7 5.6-14.3 18-17.6 21.8-3.2 3.7-6.5 4.2-12 1.4-32.6-16.3-54-29.1-75.5-66-5.7-9.8 5.7-9.1 16.3-30.3 1.8-3.7.9-6.9-.5-9.7-1.4-2.8-12.5-30.1-17.1-41.2-4.5-10.8-9.1-9.3-12.5-9.5-3.2-.2-6.9-.2-10.6-.2-3.7 0-9.7 1.4-14.8 6.9-5.1 5.6-19.4 19-19.4 46.3 0 27.3 19.9 53.7 22.6 57.4 2.8 3.7 39.1 59.7 94.8 83.8 35.2 15.2 49 16.5 66.6 13.9 10.7-1.6 32.8-13.4 37.4-26.4 4.6-13 4.6-24.1 3.2-26.4-1.3-2.5-5-3.9-10.5-6.6z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tWhatsApp\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-56263e9 elementor-widget elementor-widget-text-editor\" data-id=\"56263e9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>When working on the dimensional modeling of a Data Warehouse, we must know and understand the nature of the information within the context of the project and the needs of the business to define if it can be overwritten or if it must keep a historical record of all its changes.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-521eba8 elementor-widget elementor-widget-text-editor\" data-id=\"521eba8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>By default, a transactional system can modify the information. However, it retains only the latest version of the data affected by the change. The way to keep in our Data Warehouse a history of all the changes that allow us to explore the specific value of data at a given time is by applying the Slowly Changing Dimensions (SCD) methodologies.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c8eafb8 elementor-widget elementor-widget-text-editor\" data-id=\"c8eafb8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>A Slowly Changing Dimension will change slowly over time without a defined pattern rather than at predetermined intervals.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e386f9f elementor-widget elementor-widget-heading\" data-id=\"e386f9f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Conclusions<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ded9141 elementor-widget elementor-widget-text-editor\" data-id=\"ded9141\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>To understand the importance of SCDs, it is best to look at an example. A company that sells cell phones divides the devices into 3 ranges: high, medium, and basic. In this sector, technology evolves quickly, so that a terminal that is high-end (for example), a few months later may be considered mid-range with the arrival of new devices.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-131ae13 elementor-widget elementor-widget-text-editor\" data-id=\"131ae13\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>The company&#8217;s ERP transactional system stores the information in a standardized database. On the one hand, we have the &#8220;sales&#8221; table, where each transaction is recorded. Another &#8220;product&#8221; table contains the technical information of the mobiles, including a field indicating the range.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-516f685 elementor-widget elementor-widget-image\" data-id=\"516f685\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"287\" height=\"96\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-Intro2.png\" class=\"attachment-large size-large wp-image-4832\" alt=\"SCD Intro 2\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3fadffa elementor-widget elementor-widget-text-editor\" data-id=\"3fadffa\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>The marketing department, when loading the data into the Data Warehouse, needs to know how many cell phones are sold each year in each of the ranges. What happens when a cell phone changes range? By modifying this data in the product table, all your past sales also change to the new range, falsifying the information and making it impossible to know this data with certainty.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5ecf413 elementor-widget elementor-widget-heading\" data-id=\"5ecf413\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Solution with Slowly Changing Dimensions<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-46389b6 elementor-widget elementor-widget-text-editor\" data-id=\"46389b6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>A possible solution to the previous problem would be to use the methodology, adding to the product table two date fields that indicate respectively the start and end date of validity of a record and adding a new row\/version of the record each time a change is applied to the range.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e90b1eb elementor-widget elementor-widget-text-editor\" data-id=\"e90b1eb\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Continuing with the example, the product table would initially have a structure like this:<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-605af1d elementor-widget elementor-widget-image\" data-id=\"605af1d\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"277\" height=\"143\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-Intro1.png\" class=\"attachment-large size-large wp-image-4830\" alt=\"Slowly Changing Dimensions Intro1\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0de88e0 elementor-widget elementor-widget-text-editor\" data-id=\"0de88e0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Applying the above solution, the new data structure of the product table would be as follows for the same cell phone (SA-23) once it is decided to change its range:<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ce509ef elementor-widget elementor-widget-image\" data-id=\"ce509ef\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"480\" height=\"171\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-Intro3.png\" class=\"attachment-large size-large wp-image-4824\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-Intro3.png 480w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-Intro3-300x107.png 300w\" sizes=\"(max-width: 480px) 100vw, 480px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7b4851b elementor-widget elementor-widget-text-editor\" data-id=\"7b4851b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>It is important to note that a new SK (surrogate key) column has also been added, as the previously used natural product ID key will no longer be unique.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e6af8c8 elementor-widget elementor-widget-text-editor\" data-id=\"e6af8c8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Thanks to this solution, it will be possible to know the range of each product at the exact moment of sale.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a0b994f elementor-widget elementor-widget-text-editor\" data-id=\"a0b994f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<h2 style=\"font-family: var( --e-global-typography-primary-font-family ), Sans-serif; font-weight: var( --e-global-typography-primary-font-weight ); color: #333333; font-size: 29px; text-align: start;\" data-elementor-setting-key=\"title\" data-pen-placeholder=\"Teclea aqu\u00ed...\">Is it necessary to always reflect the different versions?<\/h2>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-065db5b elementor-widget elementor-widget-text-editor\" data-id=\"065db5b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>It will always depend on the nature of the data. If for example, the data that we change is the attribute &#8220;Name&#8221; of the cell phone because we had written it incorrectly, it will not be necessary to have another row\/version with the corrected name since what we want is that it always appears correctly, even in the sales that were made previously.<\/p>\n<p>This leads us to the existence of different types of SCD.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8127b4c elementor-widget elementor-widget-text-editor\" data-id=\"8127b4c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<h2 style=\"font-family: var( --e-global-typography-primary-font-family ), Sans-serif; font-weight: var( --e-global-typography-primary-font-weight ); color: #333333; font-size: 29px; text-align: start;\" data-elementor-setting-key=\"title\" data-pen-placeholder=\"Teclea aqu\u00ed...\">Types of Slowly Changing Dimensions<\/h2>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1e5ac80 elementor-widget elementor-widget-text-editor\" data-id=\"1e5ac80\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>There are different types of SCD depending on the methodology used in each case. <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1455f81 elementor-widget elementor-widget-text-editor\" data-id=\"1455f81\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><b>&#8211; Type 0.<\/b> The data never changes. The facts are associated with the original value of the attribute.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-03a15ae elementor-widget elementor-widget-text-editor\" data-id=\"03a15ae\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><b>&#8211; Type 1. <\/b>Overwriting. A new attribute value overwrites a previous value&#8230; The facts are associated with the current value of the attribute. There is no history of changes in the data.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-39f6729 elementor-widget elementor-widget-image\" data-id=\"39f6729\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"247\" height=\"310\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-type-1.png\" class=\"attachment-large size-large wp-image-4808\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-type-1.png 247w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-type-1-239x300.png 239w\" sizes=\"(max-width: 247px) 100vw, 247px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c4dfa73 elementor-widget elementor-widget-text-editor\" data-id=\"c4dfa73\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><b>&#8211; Type 2. <\/b>Add a new dimension row with the new attribute value. The method saves a history of each change, overwriting the &#8220;end date&#8221; and &#8220;current version&#8221; attributes of the previous version. It is also necessary to add a surrogate key. Events are associated with the active value of the attribute at the time the event occurs. There are several ways to implement this type of SCD, the most common and complete being the following:<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bcd21de elementor-widget elementor-widget-image\" data-id=\"bcd21de\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"467\" height=\"590\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-type-2.png\" class=\"attachment-large size-large wp-image-4810\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-type-2.png 467w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-type-2-237x300.png 237w\" sizes=\"(max-width: 467px) 100vw, 467px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9974be0 elementor-widget elementor-widget-text-editor\" data-id=\"9974be0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>The main disadvantage is that<b> <\/b>the natural key is repeated so it is necessary to remove the restriction of using a unique value. This implies that it is necessary to add a surrogate key.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9fe9666 elementor-widget elementor-widget-text-editor\" data-id=\"9fe9666\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><b>&#8211; Type 3. <\/b>Add a new column to keep only the current value and the previous value of the attribute. When a change is detected, the current value is moved to the previous value column and the new value overwrites the current value column. The facts are associated with the current and previous attribute values.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-95e4e2b elementor-widget elementor-widget-image\" data-id=\"95e4e2b\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"371\" height=\"310\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-type-3.png\" class=\"attachment-large size-large wp-image-4812\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-type-3.png 371w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-type-3-300x251.png 300w\" sizes=\"(max-width: 371px) 100vw, 371px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7118762 elementor-widget elementor-widget-text-editor\" data-id=\"7118762\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Its main disadvantage is that the number of states is limited to the current and previous state.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1f05a42 elementor-widget elementor-widget-text-editor\" data-id=\"1f05a42\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><b>&#8211; Type 4. <\/b>Use a mini-dimensional table derived from a main historical table. The history table contains all attributes, including a &#8220;start date&#8221; and a subrogated key. A new row is created for each version. The mini-dimensional table contains only the most recent version of each attribute with all its columns, only some columns or columns derived from these. The fact table will be associated with both the mini-dimensional table and the history table.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-52c5c93 elementor-widget elementor-widget-image\" data-id=\"52c5c93\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"380\" height=\"367\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-type-4.png\" class=\"attachment-large size-large wp-image-4814\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-type-4.png 380w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-type-4-300x290.png 300w\" sizes=\"(max-width: 380px) 100vw, 380px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-49e0a11 elementor-widget elementor-widget-image\" data-id=\"49e0a11\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"534\" height=\"135\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-type-4-tables.png\" class=\"attachment-large size-large wp-image-4816\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-type-4-tables.png 534w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-type-4-tables-300x76.png 300w\" sizes=\"(max-width: 534px) 100vw, 534px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a93d9dd elementor-widget elementor-widget-text-editor\" data-id=\"a93d9dd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><b>&#8211; Type 5. <\/b>It is a combination of type 1 and type 4. In practice, it would consist of adding a copy of the mini-dimensional table related in this case directly to the historical table so as not to have to necessarily go through the fact table to perform a query on it.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c89f6fe elementor-widget elementor-widget-image\" data-id=\"c89f6fe\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"192\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-type-5-tables.png\" class=\"attachment-large size-large wp-image-4818\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-type-5-tables.png 891w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-type-5-tables-300x72.png 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-type-5-tables-768x184.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-67b2529 elementor-widget elementor-widget-text-editor\" data-id=\"67b2529\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><b>&#8211; Tipo 6.<\/b> It is a combination of types 1, 2, and 3. Type 1 attribute overwrite, type 2 additional dimensional rows and type 3 &#8220;historical value&#8221; (or previous value) overwrite are used. The &#8220;historical value&#8221; will coincide with the &#8220;current value&#8221;, so all previous statements are overwritten. The events are associated with the active value of the attribute at the time the event occurs and with the current values. <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a8d05b3 elementor-widget elementor-widget-image\" data-id=\"a8d05b3\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"618\" height=\"590\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-type-6.png\" class=\"attachment-large size-large wp-image-4806\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-type-6.png 618w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-type-6-300x286.png 300w\" sizes=\"(max-width: 618px) 100vw, 618px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c837699 elementor-widget elementor-widget-text-editor\" data-id=\"c837699\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><b>&#8211; Type 7.<\/b> Following the functionality of type 6, an additional table containing only the current version is used to improve reporting performance. The events are associated with both the active value of the attribute at the time the event occurs and the current values.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fcc9565 elementor-widget elementor-widget-image\" data-id=\"fcc9565\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"615\" height=\"338\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-type-7.png\" class=\"attachment-large size-large wp-image-4820\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-type-7.png 615w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-type-7-300x165.png 300w\" sizes=\"(max-width: 615px) 100vw, 615px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c4a7520 elementor-widget elementor-widget-image\" data-id=\"c4a7520\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"547\" height=\"192\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-Type-7-tables.png\" class=\"attachment-large size-large wp-image-4822\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-Type-7-tables.png 547w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/SCD-Type-7-tables-300x105.png 300w\" sizes=\"(max-width: 547px) 100vw, 547px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f7305fc elementor-widget elementor-widget-text-editor\" data-id=\"f7305fc\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<h2 style=\"font-family: var( --e-global-typography-primary-font-family ), Sans-serif; font-weight: var( --e-global-typography-primary-font-weight ); color: #333333; font-size: 29px; text-align: start;\" data-elementor-setting-key=\"title\" data-pen-placeholder=\"Teclea aqu\u00ed...\">What type to choose?<\/h2>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4419134 elementor-widget elementor-widget-text-editor\" data-id=\"4419134\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>It will depend entirely on the needs of the project. Moreover, in the same table, different SCD types can be applied for each column.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fcb8d78 elementor-widget elementor-widget-text-editor\" data-id=\"fcb8d78\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>For example, in a table where we have among other data the city of an employee and his date of birth, we could apply a type 2 for the city and a type 1 for the date of birth.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ee71662 elementor-widget elementor-widget-text-editor\" data-id=\"ee71662\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Therefore, we need to analyze and understand for each dimension:<\/p>\n<p>&#8211; Which attributes are constant<\/p>\n<p>&#8211; Which attributes are variables<\/p>\n<p>&#8211; In which attributes should we save a complete version history or save only the current and previous version.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f64f33f elementor-widget elementor-widget-text-editor\" data-id=\"f64f33f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>It is also interesting to know the current and expected future data volume as it may help in the choice of the type of SCD. <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4da3fc6 elementor-widget elementor-widget-text-editor\" data-id=\"4da3fc6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>However, when in doubt and the absence of other constraints, maintaining a version history will always be a more flexible and reversible solution.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0d43b9c elementor-widget elementor-widget-text-editor\" data-id=\"0d43b9c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<h2 style=\"font-family: var( --e-global-typography-primary-font-family ), Sans-serif; font-weight: var( --e-global-typography-primary-font-weight ); color: #333333; font-size: 29px; text-align: start;\" data-elementor-setting-key=\"title\" data-pen-placeholder=\"Teclea aqu\u00ed...\">Conclusion<\/h2>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c126b47 elementor-widget elementor-widget-text-editor\" data-id=\"c126b47\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Slowly Changing Dimensions methodologies are a must when planning data loading in the Data Warehouse. But it is also essential to know the specific needs of the project and of each of the attributes to decide when their application is required and the appropriate type of SCD. <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cab8f75 elementor-widget elementor-widget-text-editor\" data-id=\"cab8f75\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Now you know the raison d&#8217;\u00eatre of the SCD and its implications. In the next article, we will discuss how to implement it at a practical level. <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d5a5a1f elementor-widget elementor-widget-text-editor\" data-id=\"d5a5a1f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<h2 style=\"font-family: var( --e-global-typography-primary-font-family ), Sans-serif; font-weight: var( --e-global-typography-primary-font-weight ); color: #333333; font-size: 29px; text-align: start;\" data-elementor-setting-key=\"title\" data-pen-placeholder=\"Teclea aqu\u00ed...\">References<\/h2>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1281b66 elementor-widget elementor-widget-text-editor\" data-id=\"1281b66\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><a href=\"https:\/\/www.kimballgroup.com\/2013\/02\/design-tip-152-slowly-changing-dimension-types-0-4-5-6-7\/\" target=\"_blank\" rel=\"noopener\">Design Tip #152 Slowly Changing Dimension Types <\/a><a style=\"background-color: #ffffff; font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\" href=\"https:\/\/www.kimballgroup.com\/2013\/02\/design-tip-152-slowly-changing-dimension-types-0-4-5-6-7\/\" target=\"_blank\" rel=\"noopener\">0, 4, 5, 6 and 7 &#8211; Kimball Group<\/a><\/p>\n<p><a href=\"https:\/\/en.wikipedia.org\/wiki\/Slowly_changing_dimension\" target=\"_blank\" rel=\"noopener\">Sl<\/a><a style=\"background-color: #ffffff; font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\" href=\"https:\/\/en.wikipedia.org\/wiki\/Slowly_changing_dimension\" target=\"_blank\" rel=\"noopener\">owly changing dimension &#8211; Wikipedia<\/a><\/p>\n<p><a href=\"https:\/\/docs.oracle.com\/cd\/E41507_01\/epm91pbr3\/eng\/epm\/phcw\/concept_UnderstandingSlowlyChangingDimensions-405719.html\" target=\"_blank\" rel=\"noopener\">Understanding Slowly Changing Dimensions &#8211; Oracle<\/a><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-614b2ec9 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"614b2ec9\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c77df54 elementor-align-center elementor-widget elementor-widget-button\" data-id=\"c77df54\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/bestdatasolutions.es\/en\/blog\/\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">&lt;&lt; BACK TO BLOG<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>The way to keep in our Data Warehouse a history of all the changes that allow us to explore the specific value of data at a given time is by applying the Slowly Changing Dimensions (SCD) methodologies.<\/p>\n","protected":false},"author":4,"featured_media":4869,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49],"tags":[73,74],"class_list":["post-4790","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-articulo","tag-general"],"_links":{"self":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/posts\/4790","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/comments?post=4790"}],"version-history":[{"count":0,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/posts\/4790\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/media\/4869"}],"wp:attachment":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/media?parent=4790"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/categories?post=4790"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/tags?post=4790"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}