{"id":13,"date":"2006-06-03T16:13:45","date_gmt":"2006-06-03T16:13:45","guid":{"rendered":"http:\/\/etlguru.com\/blog\/2006\/06\/03\/types-data-elements-and-entities-tables-for-etl\/"},"modified":"2011-05-26T23:42:09","modified_gmt":"2011-05-26T23:42:09","slug":"types-data-elements-and-entities-tables-for-etl","status":"publish","type":"post","link":"https:\/\/etlguru.com\/?p=13","title":{"rendered":"Types data elements and entities (Tables) for ETL."},"content":{"rendered":"<div class=\"entry\">\n<p>It is important for an ETL developer to understand the types of tables and data, to intelligently design ETL processes. Once the common types objects are understood, reusable templates for ETL can be developed, regardless of business logic. This will greatly improve the efficiency of an ETL developer.    <\/p>\n<p>1. Reference data<br \/>\n    <br \/>\n    2. Dimensional data (master data)<br \/>\n    <br \/>\n    3. Transactional data<br \/>\n    <br \/>\n    4. Transactions<br \/>\n    <br \/>\n    5. Balances<br \/>\n    <br \/>\n    6. Summary\/Aggregations<br \/>\n    <br \/>\n    7. Snapshots<br \/>\n    <br \/>\n    8. Staging<br \/>\n    <br \/>\n    9. Out triggers\/mini dimensions<br \/>\n    <br \/>\n    10. Log tables<br \/>\n    <br \/>\n    11. Meta data tables<br \/>\n    <br \/>\n    12. Security tables<br \/>\n    <br \/>\n    13. Configuration tables<\/p>\n<p>&nbsp; <\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>It is important for an ETL developer to understand the types of tables and data, to intelligently design ETL processes. Once the common types objects are understood, reusable templates for ETL can be developed, regardless of business logic. This will greatly improve the efficiency of an ETL developer. 1. Reference data 2. Dimensional data (master [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,17,1],"tags":[],"class_list":["post-13","post","type-post","status-publish","format-standard","hentry","category-data-loading","category-data-modeling","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/posts\/13","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=13"}],"version-history":[{"count":2,"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/posts\/13\/revisions"}],"predecessor-version":[{"id":190,"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/posts\/13\/revisions\/190"}],"wp:attachment":[{"href":"https:\/\/etlguru.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/etlguru.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=13"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/etlguru.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=13"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}