Table of Contents

Introduction & Roadmap; What is an Operational Data Store (ODS)?; What is Schema Integration?; The Role of the ODS within DW Architectures; Reverse Engineering the four Source Schema; Designing the Interim Schema; Preparing the ETL Specifications; Designing the Physical ODS Database Model; Designing Our ETL processes with SSIS; Data Quality Profiling.

About the Author

Angelo Bobak currently holds the position of Director of Data Architecture for an international ITIL services company. He holds a Masters in Computer Science and Bachelor of Electrical Engineering degrees. He has written several books on data modelling and distributed database architectures. Angelo lives in New York with his wife Cathy.