{"id":33,"date":"2007-07-22T18:04:54","date_gmt":"2007-07-22T18:04:54","guid":{"rendered":"http:\/\/etlguru.com\/blog\/etl-book\/"},"modified":"2012-01-10T01:32:26","modified_gmt":"2012-01-10T01:32:26","slug":"etl-book","status":"publish","type":"page","link":"https:\/\/etlguru.com\/?page_id=33","title":{"rendered":"ETL Book"},"content":{"rendered":"

This book is an old idea of mine started some where in 1999-00. I am finally\u00c2\u00a0planning to complete it. I will keep you all posted about the status on this page. If any one is interested in the book can comment directly to me.<\/p>\n

The Promise:- Anyone managing or\u00c2\u00a0working\u00c2\u00a0with ETL or\u00c2\u00a0Data Integration\u00c2\u00a0project will find it close to ETL Bible.<\/p>\n

Here are the updated contents<\/p>\n

Section A\u00c2\u00a0,The Beginning<\/strong>
\n01\u00c2\u00a0ETL The Basics
\n02\u00c2\u00a0ETL Strategy<\/p>\n

Section B,\u00c2\u00a0Analysis<\/strong>
\n03\u00c2\u00a0Target Systems Analysis
\n04\u00c2\u00a0Source Systems Analysis
\n05\u00c2\u00a0Source Target Mapping- Part I
\n06\u00c2\u00a0Understanding Data Quality
\n07\u00c2\u00a0Data Profiling<\/p>\n

Section C,\u00c2\u00a0Develop Part I<\/strong>
\n08\u00c2\u00a0Simple ETL Development<\/p>\n

Section D,\u00c2\u00a0 ETL Architecture & Design
\n<\/strong>09\u00c2\u00a0ETL-IA Part I
\n10\u00c2\u00a0ETL-IA Implementation -Part II
\n11\u00c2\u00a0Revisiting -Source Target Mapping -Part II
\n12\u00c2\u00a0Design Standard ETL Templates<\/p>\n

Section E,\u00c2\u00a0Develop Part II<\/strong>
\n13\u00c2\u00a0File Management
\n14\u00c2\u00a0Extraction
\n15\u00c2\u00a0Staging Data
\n16\u00c2\u00a0ETL Transformation Development
\n17\u00c2\u00a0Unit Testing ETL Processes
\n18\u00c2\u00a0Understnding & Coding Wrappers
\n19\u00c2\u00a0Automate of ETL Processes<\/p>\n

Section F,\u00c2\u00a0Migration
\n<\/strong>20\u00c2\u00a0Migration ETL Processes<\/p>\n

Section G,\u00c2\u00a0Post Production
\n<\/strong>21\u00c2\u00a0Reference Data Management
\n22\u00c2\u00a0Exception & Error Management
\n23\u00c2\u00a0Production Support & Change Management For ETL Processes
\n24\u00c2\u00a0ETL & Performance Tuning<\/p>\n

Section H,\u00c2\u00a0Other<\/strong>
\n25\u00c2\u00a0ETL Tools
\n26\u00c2\u00a0ETL & Metadata Management<\/p>\n

Below are old\u00c2\u00a0contents kept here for reference only please ignore…\u00c2\u00a0<\/strong><\/p>\n

Contents<\/strike><\/strong><\/p>\n

    \n
  1. Getting started <\/strike>\n
      \n
    1. ETL Basics<\/strike><\/li>\n
    2. ETL Strategy\u00c2\u00a0& setting the goals<\/strike><\/li>\n
    3. ETL Interface Architecture<\/strike><\/li>\n<\/ol>\n<\/li>\n
    4. Getting down to business <\/strike>\n
        \n
      1. Data Warehouse Analysis for ETL\u00c2\u00a0<\/strike><\/li>\n
      2. Source\u00c2\u00a0System Analysis<\/strike><\/li>\n
      3. Source Data Profiling<\/strike><\/li>\n
      4. Source &\u00c2\u00a0Target\u00c2\u00a0Mapping<\/strike><\/li>\n<\/ol>\n<\/li>\n
      5. Reference Data & Management<\/strike><\/li>\n
      6. Data Extraction<\/strike><\/li>\n
      7. Data Transportation<\/strike><\/li>\n
      8. Data Transformation<\/strike><\/li>\n
      9. Data Loading<\/strike><\/li>\n
      10. Exception & Error Handling<\/strike><\/li>\n
      11. Data Auditing<\/strike><\/li>\n
      12. ETL & Meta Data<\/strike><\/li>\n
      13. ETL Interface Architecture<\/strike><\/li>\n
      14. File Processing & Management for ETL<\/strike><\/li>\n
      15. Many more\u00e2\u20ac\u00a6\u00e2\u20ac\u00a6\u00e2\u20ac\u00a6\u00e2\u20ac\u00a6\u00e2\u20ac\u00a6\u00e2\u20ac\u00a6\u00e2\u20ac\u00a6.<\/strike><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

        This book is an old idea of mine started some where in 1999-00. I am finally\u00c2\u00a0planning to complete it. I will keep you all posted about the status on this page. If any one is interested in the book can comment directly to me. The Promise:- Anyone managing or\u00c2\u00a0working\u00c2\u00a0with ETL or\u00c2\u00a0Data Integration\u00c2\u00a0project will find it […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-33","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/pages\/33","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"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=33"}],"version-history":[{"count":2,"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/pages\/33\/revisions"}],"predecessor-version":[{"id":324,"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/pages\/33\/revisions\/324"}],"wp:attachment":[{"href":"https:\/\/etlguru.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=33"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}