{"id":8017,"date":"2015-05-25T11:13:11","date_gmt":"2015-05-25T15:13:11","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=8017"},"modified":"2024-05-20T13:12:08","modified_gmt":"2024-05-20T17:12:08","slug":"scd-type-4","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/","title":{"rendered":"SCD Type 4"},"content":{"rendered":"

Dimensional data that change slowly or unpredictably are captured in Slowly Changing Dimensions<\/a> (SCD) analyses. In a data warehouse environment, a dimension table has a primary key that uniquely identifies each record and other pieces of information that are known as the dimensional data.<\/p>\n

All the update methods for the different SCD types are accomplished using the SortCL<\/a> program in IRI CoSort<\/a>. In the full IRI Voracity<\/a> ETL and data management platform, there is a graphical wizard in its IRI Workbench<\/a> front-end to create the SCD job scripts for SortCL to run.<\/p>\n

Most SCD types use a full outer join to match records from the original data source with records in the updated source based on equating a key from each. Type 4, however, accomplishes the update using a sort.<\/p>\n

Type 4 SCD<\/strong><\/p>\n

The Type 4 model is similar to that for Type 2<\/a>. The difference is that there are 2 tables or files that are maintained: one for the current costs and one to hold the history records for the costs. When new current records are added to the master, these new records are usually added to the history at the same time.<\/p>\n

The field definitions are the same in the update, the history and the master files or tables. We will sort the records for the update and history together. A new master will be created that only has one record for each ProductCode<\/em> and that record will be the most current. The history will have all the records for each ProductCode<\/em> including the ones from the update source.<\/p>\n

The starting master table will be the same as the starting master from our example of Type 1<\/a> with values as shown below.<\/p>\n\n\n\n\n\t\n\n\t\n\t\n\t\n\t\n\t
ProductCode<\/th>Cost<\/th>StartDate<\/th>\n<\/tr>\n<\/thead>\n
C123<\/td>125.50<\/td>20110228<\/td>\n<\/tr>\n
F112<\/td>2365.00<\/td>20120101<\/td>\n<\/tr>\n
G101<\/td>19.25<\/td>20110930<\/td>\n<\/tr>\n
J245<\/td>450.50<\/td>20110430<\/td>\n<\/tr>\n
S022<\/td>98.75<\/td>20110515<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n

All the update data will all have the same StartDate. The update.dat source contains records with the following values:<\/p>\n\n\n\n\n\t\n\n\t\n\t\n\t\n\t
ProductCode<\/th>Cost<\/th>StartDate<\/th>\n<\/tr>\n<\/thead>\n
F112<\/td>2425.00<\/td>20120701<\/td>\n<\/tr>\n
J245<\/td>550.50<\/td>20120701<\/td>\n<\/tr>\n
M447<\/td>101.75<\/td>20120701<\/td>\n<\/tr>\n
S022<\/td>101.75<\/td>20120701<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n

The starting history source below is like the starting master in the Type 2. So Type 4 is a combination of Type 1 and Type 2 where the master is the same as a Type 1 master and the history is the same as a Type 2 master.<\/p>\n\n\n\n\n\t\n\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t
ProductCode<\/th>Cost<\/th>StartDate<\/th>\n<\/tr>\n<\/thead>\n
C123<\/td>125.50<\/td>20110228<\/td>\n<\/tr>\n
F112<\/td>2365.00<\/td>20120101<\/td>\n<\/tr>\n
G101<\/td>19.25<\/td>20110930<\/td>\n<\/tr>\n
G101<\/td>21.25<\/td>20110501<\/td>\n<\/tr>\n
J245<\/td>450.50<\/td>20110430<\/td>\n<\/tr>\n
J245<\/td>425.25<\/td>20101001<\/td>\n<\/tr>\n
J245<\/td>385.25<\/td>20100215<\/td>\n<\/tr>\n
S022<\/td>98.75<\/td>20110515<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n

In IRI Workbench, there is a Voracity wizard to assist in the creation of scripts for updating Dimensional files and tables. This wizard is located in the Voracity dropdown on the navigation bar. First you pick the SCD type. Then the window where you select the sources that are used for processing the update is displayed.<\/p>\n

\"image001\"<\/a>
\nThe next screen is where you set up the sort by selecting the keys. There are 2 keys: ProductCode<\/em> then StartDate<\/em>. We are grouping by ProductCode<\/em>, but we also need to sort in descending order by StartDate<\/em> within each ProductCode<\/em> grouping. This is so that we can filter the most recent record for each ProductCode<\/em> group to the new master.<\/p>\n

\"image003\"<\/a><\/p>\n

To make the StartDate<\/em> a key that sorts in descending order, select that key and then select Edit Key<\/strong>. This will bring up the following screen:<\/p>\n

\"image005\"<\/a><\/p>\n

In the dropdown for Direction<\/strong> select Descending<\/strong>.<\/p>\n

Here is the job script for the sort:<\/p>\n

\/INFILE=C:\/IRI\/CoSort95\/workbench.orig\/workspace\/SCD\/SCD4\/history4.dat\r\n    \/PROCESS=DELIMITED\r\n    \/ALIAS=history4\r\n    \/FIELD=(PRODUCTCODE, TYPE=ASCII, POSITION=1, SEPARATOR=\",\", FRAME='\\\"')\r\n    \/FIELD=(COST, TYPE=NUMERIC, POSITION=2, SEPARATOR=\",\", FRAME='\\\"')\r\n    \/FIELD=(STARTDATE, TYPE=ASCII, POSITION=3, SEPARATOR=\",\", FRAME='\\\"')\r\n\/INFILE=C:\/IRI\/CoSort95\/workbench.orig\/workspace\/SCD\/update.dat\r\n    \/PROCESS=DELIMITED\r\n    \/ALIAS=update\r\n    \/FIELD=(PRODUCTCODE, TYPE=ASCII, POSITION=1, SEPARATOR=\",\", FRAME='\\\"')\r\n    \/FIELD=(COST, TYPE=NUMERIC, POSITION=2, SEPARATOR=\",\", FRAME='\\\"')\r\n    \/FIELD=(STARTDATE, TYPE=ASCII, POSITION=3, SEPARATOR=\",\", FRAME='\\\"')\r\n\r\n\/SORT\r\n    \/KEY=(PRODUCTCODE, TYPE=ASCII)\r\n    \/KEY=(STARTDATE, DESCENDING, TYPE=ASCII)\r\n\r\n\/OUTFILE=history4.dat\r\n # This file will contain all the records from both inputs\r\n    \/PROCESS=DELIMITED\r\n    \/FIELD=(PRODUCTCODE, TYPE=ASCII, POSITION=1, SEPARATOR=\",\", FRAME='\\\"')\r\n    \/FIELD=(COST, TYPE=NUMERIC, POSITION=2, SEPARATOR=\",\", FRAME='\\\"')\r\n    \/FIELD=(STARTDATE, TYPE=ASCII, POSITION=3, SEPARATOR=\",\", FRAME='\\\"')\r\n\r\n\/OUTFILE=master4.dat\r\n# Include only one record for each ProductCode\r\n    \/PROCESS=DELIMITED\r\n    \/FIELD=(PRODUCTCODE, TYPE=ASCII, POSITION=1, SEPARATOR=\",\", FRAME='\\\"')\r\n    \/FIELD=(COST, TYPE=NUMERIC, POSITION=2, SEPARATOR=\",\", FRAME='\\\"')\r\n    \/FIELD=(STARTDATE, TYPE=ASCII, POSITION=3, SEPARATOR=\",\", FRAME='\\\"')\r\n    \/INCLUDE WHERE PRODUCTCODE<\/pre>\n
Below is the updated master produced by running the above job script using SortCL. The values are the same that are produced in a Type 1 update.<\/p>\n\n\n\n\n\t\n\n\t\n\t\n\t\n\t\n\t\n\t
ProductCode<\/th>Cost<\/th>StartDate<\/th>\n<\/tr>\n<\/thead>\n
C123<\/td>125.50<\/td>20110228<\/td>\n<\/tr>\n
F112<\/td>2425.00<\/td>20120701<\/td>\n<\/tr>\n
G101<\/td>19.25<\/td>20110930<\/td>\n<\/tr>\n
J245<\/td>550.50<\/td>20120701<\/td>\n<\/tr>\n
M447<\/td>139.25<\/td>20120701<\/td>\n<\/tr>\n
S022<\/td>101.75<\/td>20120701<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n
The history file contains all previous records plus the new records from the update file.<\/p>\n\n\n\n\n\t\n\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t
ProductCode<\/th>Cost<\/th>StartDate<\/th>\n<\/tr>\n<\/thead>\n
C123<\/td>125.50<\/td>20110228<\/td>\n<\/tr>\n
F112<\/td>2425.00<\/td>20120701<\/td>\n<\/tr>\n
F112<\/td>2365.00<\/td>20120101<\/td>\n<\/tr>\n
G101<\/td>19.25<\/td>20110930<\/td>\n<\/tr>\n
G101<\/td>21.25<\/td>20110501<\/td>\n<\/tr>\n
J245<\/td>550.50<\/td>20120701<\/td>\n<\/tr>\n
J245<\/td>450.50<\/td>20110430<\/td>\n<\/tr>\n
J245<\/td>425.25<\/td>20101001<\/td>\n<\/tr>\n
J245<\/td>385.25<\/td>20100215<\/td>\n<\/tr>\n
M447<\/td>101.75<\/td>220120701<\/td>\n<\/tr>\n
S022<\/td>101.75<\/td>20120701<\/td>\n<\/tr>\n
S022<\/td>98.75<\/td>20110515<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n","protected":false},"excerpt":{"rendered":"
Dimensional data that change slowly or unpredictably are captured in Slowly Changing Dimensions (SCD) analyses. In a data warehouse environment, a dimension table has a primary key that uniquely identifies each record and other pieces of information that are known as the dimensional data. All the update methods for the different SCD types are accomplished<\/p>\n
Read More<\/a><\/div>\n","protected":false},"author":10,"featured_media":8701,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[32,776,3],"tags":[922,328,101,927,924,925,546,789,926,921,928,87,68,923],"class_list":["post-8017","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-intelligence","category-etl","category-vldb-operations","tag-categorical-variable","tag-data-management","tag-data-warehouse","tag-dimensional-data","tag-filtering","tag-grouping","tag-iri-cosort","tag-iri-voracity","tag-labeling","tag-scd","tag-scripts","tag-slowly-changing-dimensions","tag-sortcl","tag-statistics"],"acf":[],"yoast_head":"\nSCD Type 4 - IRI<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SCD Type 4\" \/>\n<meta property=\"og:description\" content=\"Dimensional data that change slowly or unpredictably are captured in Slowly Changing Dimensions (SCD) analyses. In a data warehouse environment, a dimension table has a primary key that uniquely identifies each record and other pieces of information that are known as the dimensional data. All the update methods for the different SCD types are accomplishedRead More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2015-05-25T15:13:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-20T17:12:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/05\/image005-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"525\" \/>\n\t<meta property=\"og:image:height\" content=\"450\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Susan Gegner\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Susan Gegner\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/\"},\"author\":{\"name\":\"Susan Gegner\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/87be5da567628ab9396ca81170f36d63\"},\"headline\":\"SCD Type 4\",\"datePublished\":\"2015-05-25T15:13:11+00:00\",\"dateModified\":\"2024-05-20T17:12:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/\"},\"wordCount\":549,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/05\/image005-1.png\",\"keywords\":[\"categorical variable\",\"data management\",\"data warehouse\",\"dimensional data\",\"filtering\",\"grouping\",\"IRI CoSort\",\"IRI Voracity\",\"labeling\",\"SCD\",\"scripts\",\"slowly changing dimensions\",\"SortCL\",\"statistics\"],\"articleSection\":[\"Business Intelligence (BI)\",\"ETL\",\"VLDB\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/\",\"url\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/\",\"name\":\"SCD Type 4 - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/05\/image005-1.png\",\"datePublished\":\"2015-05-25T15:13:11+00:00\",\"dateModified\":\"2024-05-20T17:12:08+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/05\/image005-1.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/05\/image005-1.png\",\"width\":525,\"height\":450},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SCD Type 4\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.iri.com\/blog\/#website\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"width\":750,\"height\":206,\"caption\":\"IRI\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/87be5da567628ab9396ca81170f36d63\",\"name\":\"Susan Gegner\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2b1ca5592a65d44483351292cf1ae00a?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2b1ca5592a65d44483351292cf1ae00a?s=96&d=blank&r=g\",\"caption\":\"Susan Gegner\"},\"url\":\"https:\/\/www.iri.com\/blog\/author\/susang\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SCD Type 4 - IRI","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/","og_locale":"en_US","og_type":"article","og_title":"SCD Type 4","og_description":"Dimensional data that change slowly or unpredictably are captured in Slowly Changing Dimensions (SCD) analyses. In a data warehouse environment, a dimension table has a primary key that uniquely identifies each record and other pieces of information that are known as the dimensional data. All the update methods for the different SCD types are accomplishedRead More","og_url":"https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/","og_site_name":"IRI","article_published_time":"2015-05-25T15:13:11+00:00","article_modified_time":"2024-05-20T17:12:08+00:00","og_image":[{"width":525,"height":450,"url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/05\/image005-1.png","type":"image\/png"}],"author":"Susan Gegner","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Susan Gegner","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/"},"author":{"name":"Susan Gegner","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/87be5da567628ab9396ca81170f36d63"},"headline":"SCD Type 4","datePublished":"2015-05-25T15:13:11+00:00","dateModified":"2024-05-20T17:12:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/"},"wordCount":549,"commentCount":0,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/05\/image005-1.png","keywords":["categorical variable","data management","data warehouse","dimensional data","filtering","grouping","IRI CoSort","IRI Voracity","labeling","SCD","scripts","slowly changing dimensions","SortCL","statistics"],"articleSection":["Business Intelligence (BI)","ETL","VLDB"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/","url":"https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/","name":"SCD Type 4 - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/05\/image005-1.png","datePublished":"2015-05-25T15:13:11+00:00","dateModified":"2024-05-20T17:12:08+00:00","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/05\/image005-1.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/05\/image005-1.png","width":525,"height":450},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/scd-type-4\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SCD Type 4"}]},{"@type":"WebSite","@id":"https:\/\/www.iri.com\/blog\/#website","url":"https:\/\/www.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.iri.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/www.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","width":750,"height":206,"caption":"IRI"},"image":{"@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/87be5da567628ab9396ca81170f36d63","name":"Susan Gegner","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2b1ca5592a65d44483351292cf1ae00a?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2b1ca5592a65d44483351292cf1ae00a?s=96&d=blank&r=g","caption":"Susan Gegner"},"url":"https:\/\/www.iri.com\/blog\/author\/susang\/"}]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/05\/image005-1.png","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/8017"}],"collection":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=8017"}],"version-history":[{"count":19,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/8017\/revisions"}],"predecessor-version":[{"id":17448,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/8017\/revisions\/17448"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/8701"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=8017"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=8017"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=8017"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}