{"id":31,"date":"2007-02-06T17:59:28","date_gmt":"2007-02-06T17:59:28","guid":{"rendered":"http:\/\/etlguru.com\/blog\/2007\/02\/06\/type-ii-dimension-what-is-expiry-date-does-it-come-from-source-or-is-it-etl-date\/"},"modified":"2007-02-06T17:59:28","modified_gmt":"2007-02-06T17:59:28","slug":"type-ii-dimension-what-is-expiry-date-does-it-come-from-source-or-is-it-etl-date","status":"publish","type":"post","link":"https:\/\/etlguru.com\/?p=31","title":{"rendered":"Type II dimension: What is expiry date? Does it come from Source or is it ETL date?"},"content":{"rendered":"<p>I assume everyone is aware of type II dimension concept.\u00c2\u00a0 In type II dimension when we get an updated row we retire old row and insert new one. But what do you populate\u00c2\u00a0 in the from_date \u00e2\u20ac\u201dto_date attributes. ETL create\/update datetime or when that particular row was retired in the source system?<\/p>\n<p>The\u00c2\u00a0question can be asked in a different way\u00e2\u20ac\u00a6 When a employee changes from one department\u00c2\u00a0 to another department; While populating in the data warehouse type II dimension EMPLOYEE table\u00e2\u20ac\u00a6 Do you use the actual date of his transfer or the ETL date when you are populating the table?<\/p>\n<p>What are you doing in your ETL code?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I assume everyone is aware of type II dimension concept.\u00c2\u00a0 In type II dimension when we get an updated row we retire old row and insert new one. But what do you populate\u00c2\u00a0 in the from_date \u00e2\u20ac\u201dto_date attributes. ETL create\/update datetime or when that particular row was retired in the source system? The\u00c2\u00a0question can be [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28,13,1],"tags":[],"class_list":["post-31","post","type-post","status-publish","format-standard","hentry","category-data-architecture","category-etl-strategy","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/posts\/31","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/etlguru.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=31"}],"version-history":[{"count":0,"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/posts\/31\/revisions"}],"wp:attachment":[{"href":"https:\/\/etlguru.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=31"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/etlguru.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=31"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/etlguru.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=31"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}