ETL Book

This book is an old idea of mine started some where in 1999-00. I am finally planning 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 working with ETL or Data Integration project will find it close to ETL Bible.

Here are the updated contents

Section A ,The Beginning
01 ETL The Basics
02 ETL Strategy

Section B, Analysis
03 Target Systems Analysis
04 Source Systems Analysis
05 Source Target Mapping- Part I
06 Understanding Data Quality
07 Data Profiling

Section C, Develop Part I
08 Simple ETL Development

Section D,  ETL Architecture & Design
09 ETL-IA Part I
10 ETL-IA Implementation -Part II
11 Revisiting -Source Target Mapping -Part II
12 Design Standard ETL Templates

Section E, Develop Part II
13 File Management
14 Extraction
15 Staging Data
16 ETL Transformation Development
17 Unit Testing ETL Processes
18 Understnding & Coding Wrappers
19 Automate of ETL Processes

Section F, Migration
20 Migration ETL Processes

Section G, Post Production
21 Reference Data Management
22 Exception & Error Management
23 Production Support & Change Management For ETL Processes
24 ETL & Performance Tuning

Section H, Other
25 ETL Tools
26 ETL & Metadata Management

Below are old contents kept here for reference only please ignore… 

Contents

  1. Getting started
    1. ETL Basics
    2. ETL Strategy & setting the goals
    3. ETL Interface Architecture
  2. Getting down to business
    1. Data Warehouse Analysis for ETL 
    2. Source System Analysis
    3. Source Data Profiling
    4. Source & Target Mapping
  3. Reference Data & Management
  4. Data Extraction
  5. Data Transportation
  6. Data Transformation
  7. Data Loading
  8. Exception & Error Handling
  9. Data Auditing
  10. ETL & Meta Data
  11. ETL Interface Architecture
  12. File Processing & Management for ETL
  13. Many more………………….

181 Responses to “ETL Book”

  1. Ashok says:

    Hi,

    Please send me the Informatica book.
    Thanks,
    Ashok

  2. Dal Atwal says:

    For DB2 exceptions is there way for Abinitio to bypass deadlock of the record that one could encounted on either updating or inserting, or deleting a record. Can one within the UDB component trap the error code, and continue to process to the next record or try after a few seconds to reinstate the record processing for the record that encounted the deadlock?

  3. Vijay says:

    Hi,

    I was going through this site and found the explaination very helpful.
    I have good experience in Teradata, but never got an opportunity to use Informatica as a ETL tool . Would it be possible for me to get a copy of the same.

    Thank you

  4. srinu says:

    hi
    sent this book

  5. Sandesh,

    Please be kind enough to answer these queries…..

  6. Pl send me ETL Book and Abinitio Testing Guidelines.

  7. Sreekanth says:

    Hi Sandesh,

    Do you have any similar stuff in reporting side like Cognos? If you have some thing please let me know.

    Thanks,
    Sreekanth

  8. Amit says:

    Hi,

    Please send me the book.

    Regards,
    Amit Sharma

  9. Ramya says:

    Please send me the book. I need it badly for my project…

  10. Srikar says:

    Hi,

    Please do send me the book.

    Thanks in advance.
    Srikar Chepuri

  11. damodharam says:

    pleace send this ebook

  12. Sushanta says:

    Hi,

    Please send me this ETL book to the below Id :
    sushanta.omm@gmail.com

    Thanks,
    Sushanta.
    Mob : +91 7428486066

  13. Sushanta says:

    Hi,

    I like the content of the ETL book very much.
    Could you please send it to the below Id.

    Sushanta.omm@gmail.com.

    Thanks,
    Sushanta.
    Mob : +91 7428486066

  14. puneet says:

    Hi,
    I am QA analyst. I am working on CRMS project. And my part of work is mostly on ETL Testing. Can you please send this book to me.
    Thanks

  15. Shahul says:

    How do i can the hold of this book ? Is it avilable online ?

  16. velmurugan says:

    Hi,

    Please send the ETL book.

    Thanks,
    Velmurugan

  17. eshwar says:

    Hai,

    Please send me the Informatica book.
    Thanks,
    Eshwar A

  18. SA Reddy says:

    Please send me the ETL BOOK.

    Thanks in advance,
    SA Reddy

  19. Sachin Sarjoshi says:

    Hi,
    I am working on ETL testing. I am beginner and want to learn more.Could you please send me the ETL book?

  20. Amol Jadhav says:

    I need the contact number of yours.

  21. ahmed says:

    Can u pl send me this book and the fee i will pay immediately online ….

  22. kunal says:

    Hi,

    Please share the book being referenced here.

    Thanks,

    kunal

  23. srinivas says:

    please send me the etl book.

    thanks
    srinivas

  24. KARUNAKARAN L G says:

    Hi sandesh,

    Now i am working in DFatawarehouse testing, i am new to ETL testing, please send me the book very useful for me,

    thanks and regards
    Karunakaran
    lgkaruna@gmail.com

  25. Riaz says:

    Can you pls email me the ETL Book.
    thanks

  26. lakshman says:

    Hi Sandesh,
    Can you please share a soft copy of the ETL book if possible

    thanks
    laxman

  27. sai says:

    please send me etl book

  28. chamu says:

    Hi Sandesh,
    I’m unable to resist from reading this book.please send me an e-copy if possible.

    Thanks,
    Chamu

  29. Raghu says:

    Hi,
    I am working on ETL testing. I am beginner and want to learn more.Could you please send me the ETL book?

  30. akshitha says:

    Please send me the ETL book

  31. Vijay Savdharia says:

    Hi,

    Can you please send me a copy of this book.

    Best Regards
    Vijay

  32. Mehrnaz says:

    Hi Sandesh
    Could you please end me the ETL book, I am starting work on ETL testing and would like t know more on this.
    Thanks
    Mehrnaz

  33. Nikita says:

    Hi Sandesh,

    I would be really grateful if you could send me the book, as am just a beginner and this would probably help me.

    Thanks and Regards
    Nikita

  34. Navdeep says:

    Hi Sandesh,

    Can you please send me this book.

    Thanks & Regards,
    Navdeep

  35. Hi Sandesh says:

    i am working on ETL project.i am new to this. plz send me the book it will be very much helpful.

    Regards,

    Richa

  36. sri says:

    Please send me the book. Thanks in advance

  37. Vijay Henry says:

    Hi Santosh

    please send me the book

  38. Sreenivas says:

    I am working on ETL project, please send me book

    Thanks,
    Sreenivas

  39. marco says:

    Please, can you send me the book? Thanks in advance.

  40. Harish says:

    Hi
    Could you please send me the ETL book, I am starting work on ETL testing and would like t know more on this.

  41. Uans says:

    Hi,

    Can you please send me a copy of this book.

    Thanks.

  42. sri says:

    Can you please send me a copy of the book?

    Thanks,
    Sri

  43. nokia0908 says:

    Could you please end me the ETL book, I am starting work on ETL testing.

  44. nokia0908 says:

    Could you please end me the ETL book, I am starting work on ETL testing.Thank you.

  45. Rammy says:

    Can you please me the ETL book?

  46. sanjeev says:

    HI,
    please send me a book on etl.

    Thanks

  47. luk vervenne says:

    please send a copy. Thx!

  48. gopi krishna says:

    HI
    Can you please send me copy of the book .

    Thanks
    gopi

  49. Jayanthi says:

    I’m about to work on a ETL testing project and would like to gain knowledge on the same. Please send me a copy of the book. Thanks

  50. Pawan says:

    Could you please send me this book.
    Thanks

  51. pavan says:

    jayanthi or any1 if u gt any details or projects share please

  52. Ankit says:

    Hello Sandesh,

    I am working on ETL project.I am new to this. plz send me the book it will be very much helpful.

    many Thanks,
    Ankit

  53. rajesh says:

    I’m about to work on a ETL testing project and would like to gain knowledge on the same. Please send me a copy of the book. Thanks

  54. Dimple says:

    Hi

    Could you please send me the ETL book, I am starting work on ETL testing and would like to know more on this.

  55. Tilak Kumar Dhar says:

    Hi Sandesh,

    Could you please send me a copy of your book?

    Thanks in advance for your help,

    Regards
    Tilak

  56. Kirankumar Narayanadas says:

    Hi
    Could send me please ETL book. I am working on ETL testing

    Regards
    Kiran

  57. Ragvan Sinha says:

    Hi Sandesh,

    Can you please send me the book at sinharagvan@gmail.com?

    Thanks in advance!
    RS

  58. kavya says:

    HI i am new to EtL testing … Can you please send me the book .. It will be helpful for me .

  59. Shailesh says:

    Hi Sandesh,

    Can you please send me the book at hai_shailesh@rediffmail.com?

    Thanks in advance!
    Shailesh Kulkarni

  60. harikrishna says:

    pls send me the etl testing material.

  61. suresh says:

    Could you please send me a copy of that book…I desperately need it…
    Please consider my requisition for your kind perusal

    Thanks & Regards,

    Suresh Gurram

  62. Manoj says:

    Could you please send me a copy of this book, I am new to ETL and i am trying to learn Datastage and its related concepts.

  63. Kumar says:

    Can i have a copy of this book plz!!…I recently started working ETL Testing…

  64. Anand says:

    Sandesh,
    Can you please send me the book at anandva@gmail.com?
    Thank you
    Anand

  65. Satish says:

    I have started working on ETL. Please send me a BOOK.

  66. Pradeep Maharana says:

    Can you send me ETL Book

  67. Shailendra says:

    thanks in advance 🙂

  68. yvsubbarao says:

    Hi
    Could send me please ETL book. I am working on ETL testing

  69. sudha says:

    can you please send me the book also?

  70. vinay says:

    am looking for a job on etl….. plz send me the etl book……..
    thanking you…….

  71. Murugan says:

    Please send me the ETL book

  72. Sheetal says:

    Could send me please ETL book. I am working as ETL developer

  73. Neha says:

    Please send me the ETL book

  74. Sushil says:

    A copy of ETL book for me please. Thanks !!

  75. Sushil says:

    Could send me please the ETL book?

  76. Shankar says:

    Hi Sandesh,
    Could you please send me a copy of that book…as im new to ETL testing..This book of yours will be very much helpful to me…

    Thanks in advance,
    Bhavani Shankar

  77. VK says:

    can you please send me the ETL book at p_vnd@yahoo.com
    Thanks in advance

  78. Mukesh Singh says:

    Can you please send me a copy of this book?
    Thanks in advance!!

  79. Shabbir Ahmed says:

    Hi Sandesh!
    could you please send me a copy of the ETL book?
    Thank you!

  80. sarvesh Kumar says:

    Request you to please send me this book.
    Thanks

  81. sarma says:

    can you please send me a copy of the book.

  82. shweta says:

    Please mail me a copy of the book. I am new into ETL develeopment!

  83. Gautam says:

    Hi

    Can u send me the book also. Do let me know if i need to buy how much will it cost and paymnet details

    Thanks

  84. Nageswar says:

    Hi Sandesh,

    Could you pls send me a copy of your book. Thanks in advance.

  85. sivareddy says:

    am working on ETL project.I am new to this. plz send me the book it will be very much helpful.
    many Thanks,

  86. sivareddy says:

    i am searching for job in dwh plz send me the informatica book it will be very much helpful.
    many Thanks,

  87. shubhank shrivastava says:

    please send me at shubh11.11@gmail.com, It will be appreciable.

    Thanks in Advance !!!

  88. raja says:

    please send anyone how to create node in datastage and how to build batchID concept.plz snd details to lucky.raja31@yahoo.com

  89. raja says:

    please send anyone how to create node in datastage and how to build batchID concept.plz snd details to lucky.raja31@gmail.com.com

  90. SANDIP ROY says:

    Dear Sandesh – I am really so happy to see that you have completed the ETL Book , you have worked very hard on this , and we have spoken about the same few years back , CONGRATS to the GAWANDE FAMILY , please convey my regards to all , How are things at Stamford??
    Please email me a copy of the book , I really look forward to reading the same, we have moved back to India , hope to see you all sometime soon. – Sandip Roy (sandyroy29@yahoo.com)

  91. edd says:

    I am new to this.
    can you please send me the ETL book at edg-77@hotmail.com
    many Thanks.

  92. yug says:

    Looks like you have done exhaustive work on ETL.I am new to ETL.Can you please share ETL book and ETL testing material if you have.
    I would appreicate your help on this..
    Please send me these books to byreddy@yahoo.com

  93. Puneet Kumar says:

    I am working as developer in Informatica for 3 yrs. I would really appreciate if I can get the privilege to read your book “ETL BOOK”.
    Eagerly waiting for your email.

  94. Erick says:

    Please send me copy of this book, truly appreciate it!

    Thank you

  95. sidharth says:

    it will be very nice of you if can share your ETL book and material. i will really appreciate it. thx ..my email id sidharth.k.agarwal@gmail.com

  96. sasikanth says:

    Hi Sandesh,

    Can you please forwardme a copy of the ETL book please?

    Regards,
    Sasi

  97. chandrababu says:

    Could you please send me a copy of your book?

    Thanks in advance for your help,

    Regards
    chandu

  98. Norman says:

    Could you please send me a copy of your book, I am currently working on an ETL framework and your books quite handy.

    Regards
    Norman

  99. Bhanu says:

    Request you to send me a copy of your ETL Book

  100. Koti says:

    Can you please share ETL testing book. I am new to ETL testing and wanted get start with your valuable inputs from the book.
    Please send me the book to koti688@gmail.com

  101. Vedu says:

    Please send me your ETL Book. I am new to BI space. Thanks in advance.
    Vedu.

  102. Narmada says:

    Please send me a copy of your book.
    Thanks in Advance

  103. kiran says:

    need a sample………….

  104. ticemba says:

    Hi,
    I am starting work on ETL project and I would like to know more on this.
    Could you please send me a copy of your book?
    Thanks in advance for your help,
    Regards

  105. Hari says:

    Please send me ETL book.

  106. Smitha says:

    Hey Sandesh greetings!!!
    its really grt of u to put in ur exeperience in de form of a book!!! cheers!!!
    im a beginner in de field of ETL, it wud be really helpful if u can share a copy of ur book…brginners like me wud benefit from it
    my email id –>smitha.reddy111@yahoo.co.in
    thanx in advance 🙂

  107. Vidit says:

    Can you please send me the book..i am working on open source ETL that is PDI and Talend..It will be really great if I get this book..Thanks in advance..my id is vidit.desai@tcs.com & viditdesai104@gmail.com

  108. srinivas medisetty says:

    please forward this book it is very useful for me

    Thanks&regards
    srinivas

  109. santosh thorat says:

    hi Sandesh,

    i am new to ETL field & want to work as ETL/DW tester. so please send me copy of your book . i know this will be very much helpful to me.

    thanks in advance,

    santosh thorat
    thoratsantosh12@gmail.com

  110. kala says:

    Please send me the ETL Book bcos i am new to ETL field and i need to learn about ETL Process.

  111. Vaishali says:

    I have recently started working on ETL using open source tools. Kindly share a copy of your book.
    Thanks in advance.

  112. Abid says:

    Hi Sandesh,
    Contents seems to be very interesting… can you please mail me the book. It would be really helpful.
    Mail ID : abid.zaveri@gmail.com

  113. sai says:

    I am working in ETL testing project and I would like to know more on this.
    please send me a copy of your book, so that i can gain more knowledge
    Thanks in advance,
    Regards
    sai

  114. sai says:

    I am working in ETL testing project and I would like to know more on this.
    please send me a copy of your book, so that i can gain more knowledge
    Thanks in advance,
    Regards
    sai
    sai2987@gmail.com

  115. vinothkumar says:

    Hi

    The topics are amazing…can u pls mail me the book

    Thanks

  116. sirisha says:

    Need some books like this to help the beginners in DWH.
    Need the book.

  117. praneetha says:

    Hi

    I got job recently as informatica developer, Am interested in knowing about your book, because the updated contents in it are very interesting and all are related to real time scenarios, which will definitely help me out for my present project. If you get a chance to read at my message, Could you please kindly give me a chance of go throughing your ETL Book

    Thanks & regards
    Praneetha
    prnthdv@gmail.com

  118. Indira says:

    I am working in ETL testing project and I would like to know more on this.
    please send me a copy of your book
    Thanks in advance,

    Regards
    Indira

  119. Pedro Carvalho says:

    Hello! I’m a student on BI, and i’m learning the basics of ETL process.
    You’re book would be a great help on learning about ETL. Can you send a copy to me, please?

    Thank you very much

  120. Prafull says:

    Hi, I am new to ETL.
    Would you please send me a copy of your book.
    Thanks in advance

  121. sunil says:

    Hi,
    I am sunil,presently involved in a project realated to ETL (informatica).
    can u please send me the copy of your book,it will really help me a lot to work on the project .
    Thanking you in advance.

  122. raju says:

    i need etl testing topics and etl test caess

  123. raju says:

    i need etl testing topics and etl test caess

  124. Anitha says:

    Hello Sadesh,
    Can u also send me the copy of your book

  125. chandrababu says:

    Hi, i’m student on DWH ,please send me a book of copy .

  126. satya says:

    Hi,

    I am learning ETL Basics. I am unable to find this ebook in the internet.KIndly send me the soft copy to my mailid (satyainf8@gmail.com).

    Thanks,
    satya

  127. Namrata says:

    Could you please send your e-book through email? Ii not please advise as to how can i place a purchase order.

    Thanks,
    NB

  128. Vijay says:

    Hi Sandesh i like your site and specially index of your ETL BOOK. please let me know the way to get this book.If possible send it on my email id vijay.ce2006@gmail.com

  129. Dima says:

    Hi, I’m new to ETL and seeing vast interest on your ETL BooK, could you send it to me please or show the way i could purchase it.
    froosto@gmail.com.
    Thnaks,
    DS

  130. sree says:

    i need etl & informatica books to prepare interviews

  131. Amol says:

    Please share ETL Book. I am new to the world of DWH & ETL.

  132. ASH says:

    hI – Could you please send your e-book through email?

  133. Shallabh Khera says:

    Please email your ETL book at shallabhkhera@gmail.com

  134. iyappan says:

    i am working with web etl tool kapow robosuite is it possible for to get a job in informatica or in database.. here am not working in any database

  135. Maya says:

    I’m interested in this book. Can you please send a copy to djm18@hotmail.com? Thank you! Maya.

  136. shylender says:

    Hi,

    It’s good to know that we are going to get a good book which is going to cover everthing in ETL.
    could you please tell me when you are going to publish.

    with anticipation

    Thanks and Regards,
    shylender

  137. anwar says:

    pls provide ur book.it will help me lot for my etl project

  138. MG says:

    Please send me a copy of this book as well.

  139. Vish says:

    Working on Informatica project ….Can you email ETL book at narvi78@gmail.com

  140. raghu says:

    hi,

    i am new to etl tetsing.i moved from developmnent.before i work on project,i want complete knowledge of etl testing.can you plz send me the book to my mail id rushtoraghu@gmail.com .it would be great.

  141. raghu says:

    Please let me know if ur book is available in stores in bangalore so that i can buy .

  142. minh pacia says:

    I am starting work on ETL project and I would like to know more on this.
    Could you please send me a copy of your book?
    Thanks in advance for your help,

    mpacia

  143. Ritu says:

    Hi.. I liked the content.
    Could you please send me a copy at mulchandani84@gmail.com

  144. Ali says:

    Hi,

    Could you send me your ETL book to me on alishareef3@gmail.com
    Thanks

  145. Mohan says:

    Hi Sandesh,
    How are you, this is Mohan, do you remember me, I worked with you in NCDI project, can you please send me a copy of your ETL book and can you also please share your contact number, thanks in advance.

  146. Thiru says:

    Please send me your etl book for interview.

    Thanks in advance

  147. Jignesh says:

    Content of the book looks interesting, please send me the book at jignesh.svit@gmail.com

    Thanks

  148. Johan says:

    Hello,
    I’m interrested in reading your book because I need to improve my knowlege in ETL process. My e-mail address is “akirajt@gmail.com”.

  149. varun says:

    Hi sandesh aim working on ETL testing but I’m new to it.
    so could u please send your e-book copy through email.

  150. siva says:

    I am Siva,presently involved in a project realated to ETL (informatica).
    can u please send me the copy of your book,it will really help me a lot to work on the project .
    Thanking you in advance.

  151. bee says:

    Could you please send me the book.
    Thank you.

    Bee

  152. Ron Decosta says:

    I have just started working in the ETL side and wanted to ask if I can have a copy of your ETL Book. I wanted to keep this as a bible. Please send a copy if possible at rondecosta@hotmail.com

    Thanks
    Regards,
    Ron

  153. Harish says:

    Can u pls send me a copy of ETL Testing….
    Thank You

  154. Paul says:

    Hi! Please, send me your book too

  155. sudhi says:

    Could you send me the copy…looking for the book

  156. Frank O'Hara says:

    Hi Sandesh. I’m confused. Is there a book or just a collection of blog entries which = the book?

    Is there a digital version of the book on this site and I just can’t find it? I would love to read a quality book about ETL – I too have yet to find one.

    If there is a “real” book are you charging for it?

    Thanks,
    Frank

    P.S. Your blog posts have been very informative and helpful. Thanks for providing such a great service.

  157. latha vegireddi says:

    Hi siva..I am working as ETL tester.Can you please send me the copy of your book.That would help me a lot in improving my knowledge.Thanks in advance!!

  158. Roy says:

    Hi Sandesh,
    I am new to ETL Informatica and in the learning process. can you please send me a copy of this book i will realy appreciate it.
    Thanks

  159. Satya Prakash Mallubhatla says:

    Could you please share your ETL book, i’m looking for change of a job. From BPM domain to ERP domain(ETL)

  160. srinivas.k says:

    Hi sandesh, i am working on ETL testing but I’m new to it. Can you please send me the copy the book?

  161. Anshika Goyal says:

    Hi, I am wokring on ETL testing and found this book very informative. PLease send me a copy to anshika.goyal@accenture.com

  162. gowri says:

    I am gowri . am beginner in ETL testing . if u share de book . it will helpfull for me

  163. logesh says:

    I am starting work on ETL project and I would like to know more on this.
    Could you please send me a copy of your book?
    Thanks in advance for your help

  164. Akhil Goyal says:

    Hey I like your book. I am working on the ETL project and i need help on this.
    So can you please forward me the book on email akhil.goyal@tarams.com

  165. Awantika Srivastava says:

    It seems dat this book is really helpful For ETL developers. Can u plz share one copy of it with awantika2289srivastava@gmail.com

  166. Bhargavi says:

    I am planning to learn ETL testing and the tool is data management.
    Can you please send me your book to my mail. Mail id is : bhargavikrishna@gmail.com
    Thanks in Advance

  167. Narendra says:

    Please share this ebook with me at krishnarendra@gmail.com.

  168. Pradeep says:

    I am Pradeep,presently involved in a project realated to ETL (SSIS).
    can u please send me the copy of your book,it will really help me a lot to work on the project .
    Thanking you in advance.

  169. Vikram says:

    Sandesh,

    I am architect working on projects involving DW / ETL. Please let me know about this book.

    Thanks and regards.
    – Vikram Gokhale

  170. Yavanika says:

    Hi,
    I am Yavanika interested in learning ETL testing, can you please send me a copy of your book.

    Thank You,
    Regards,
    Yavanika.

  171. chalam says:

    Hello, Could you please send me a copy of the book.
    I am currently looking for new oppurtunities in Informatica. This will be really helpful.

    Really Appreciate your time and help.

    Best Regards,
    Chalam

  172. prasanna says:

    Can you please share ETL testing book. I am new to ETL testing and wanted get start with your valuable inputs from the book.If not please advise as to how can i place a purchase order
    Please send me the book to prasannasrinivas.m@gmail.com,

  173. Azhar says:

    I liked the content of the book. Can u send me the copy at azhar251185@gmail.com

  174. Anil says:

    Hi frnds, if any one having .
    ETL soft copy send to this mail id:anilg304@gmail.com
    Please send me your etl book for interview.

  175. isha says:

    hi i m isha here can u pls send ur book to my email id – ishakalra086@gmail.com

  176. rathan says:

    Hi ,
    Can u Plz send an Ebook as i am involved in MDM and BI Datamart projects.

  177. Anil says:

    Can you please share ETL testing book. I am new to ETL testing and wanted get start with your valuable inputs from the book.
    If not please advise as to how can i place a purchase order: Email: anilg304@gmail.com
    Thx
    Anil

  178. Lincoln says:

    Hi, I am very interested in the ETL Bible. Please send a copy. Thanks!

  179. Debankur Ghosh says:

    Please send me a copy of your book to debankurghosh@ymail.com

Leave a Reply