{"id":8,"date":"2006-05-10T15:55:16","date_gmt":"2006-05-10T15:55:16","guid":{"rendered":"http:\/\/etlguru.com\/blog\/2006\/05\/10\/what-etl-is-not\/"},"modified":"2006-05-10T15:55:16","modified_gmt":"2006-05-10T15:55:16","slug":"what-etl-is-not","status":"publish","type":"post","link":"https:\/\/etlguru.com\/?p=8","title":{"rendered":"What ETL is not?"},"content":{"rendered":"<p>ETL should not be confused with a data creation process. <strong>It never creates new data<\/strong>. If a list of hundred employees is being loaded, one more employee cannot be added to the list and make it hundred and one. Or if last name of customer is absent an arbitrary last name cannot be substituted.<\/p>\n<p>Data warehouses are <strong>not OLTP<\/strong> systems. Duplication of calculations in Source system &#038; the data warehouse should not be attempted, as the numbers will be very difficult to match during QA. Also in future the process in the source system can change that will result in asynchronous data.<\/p>\n<p>ETL <strong>cannot change the meaning of data<\/strong>. For example for sex\u00c2\u00a0 \u00e2\u20ac\u02dcM\u00e2\u20ac\u2122 and \u00e2\u20ac\u02dcF\u00e2\u20ac\u2122 in source system sex flag to \u00e2\u20ac\u02dc1\u00e2\u20ac\u2122 and \u00e2\u20ac\u02dc2\u00e2\u20ac\u2122 is used in the Data Warehouse respectively. This is OK because this does not change the business meaning of the data. It only has changed the representation of the data.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>ETL should not be confused with a data creation process. It never creates new data. If a list of hundred employees is being loaded, one more employee cannot be added to the list and make it hundred and one. Or if last name of customer is absent an arbitrary last name cannot be substituted. Data [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,1],"tags":[],"class_list":["post-8","post","type-post","status-publish","format-standard","hentry","category-etl-basics","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/posts\/8","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=8"}],"version-history":[{"count":0,"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/posts\/8\/revisions"}],"wp:attachment":[{"href":"https:\/\/etlguru.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/etlguru.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/etlguru.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}