36,95 €*
Versandkostenfrei per Post / DHL
Lieferzeit 4-7 Werktage
This book contains three sections spanning ten chapters. Section I, Foundational Concepts, will provide you with the necessary basic concepts and discuss schema integration. Section II, Preparation and Design, introduces the case study and we will reverse engineer each of the data sources to create a set of data dictionary reports which will provide us with the meta data we need to apply the schema integration process. Section III, Physical Implementation, will present scripts to populate each of the source databases and spreadsheets and use reports to create Extract, Transform, and Load (ETL) specifications. The ten chapters within these three sections are:
Chapter 1 - Introduction and Roadmap
Chapter 2 - What is an Operational Data Store (ODS)?
Chapter 3 - What is Schema Integration?
Chapter 4 - The Role of the ODS within DW Architectures
Chapter 5 - Reverse Engineering the four Source Schema
Chapter 6 - Designing the Interim Schema
Chapter 7 - Preparing the ETL Specifications
Chapter 8 - Designing the Physical ODS Database Model
Chapter 9 - Designing Our ETL processes with SSIS
Chapter 10 - Data Quality Profiling
This book contains three sections spanning ten chapters. Section I, Foundational Concepts, will provide you with the necessary basic concepts and discuss schema integration. Section II, Preparation and Design, introduces the case study and we will reverse engineer each of the data sources to create a set of data dictionary reports which will provide us with the meta data we need to apply the schema integration process. Section III, Physical Implementation, will present scripts to populate each of the source databases and spreadsheets and use reports to create Extract, Transform, and Load (ETL) specifications. The ten chapters within these three sections are:
Chapter 1 - Introduction and Roadmap
Chapter 2 - What is an Operational Data Store (ODS)?
Chapter 3 - What is Schema Integration?
Chapter 4 - The Role of the ODS within DW Architectures
Chapter 5 - Reverse Engineering the four Source Schema
Chapter 6 - Designing the Interim Schema
Chapter 7 - Preparing the ETL Specifications
Chapter 8 - Designing the Physical ODS Database Model
Chapter 9 - Designing Our ETL processes with SSIS
Chapter 10 - Data Quality Profiling
| Erscheinungsjahr: | 2012 |
|---|---|
| Genre: | Informatik |
| Rubrik: | Naturwissenschaften & Technik |
| Medium: | Taschenbuch |
| Seiten: | 250 |
| ISBN-13: | 9781935504221 |
| ISBN-10: | 1935504223 |
| Sprache: | Englisch |
| Ausstattung / Beilage: | Paperback |
| Einband: | Kartoniert / Broschiert |
| Autor: | Bobak, Angelo |
| Hersteller: | Technics Publications |
| Maße: | 254 x 203 x 14 mm |
| Von/Mit: | Angelo Bobak |
| Erscheinungsdatum: | 15.10.2012 |
| Gewicht: | 0,545 kg |
| Erscheinungsjahr: | 2012 |
|---|---|
| Genre: | Informatik |
| Rubrik: | Naturwissenschaften & Technik |
| Medium: | Taschenbuch |
| Seiten: | 250 |
| ISBN-13: | 9781935504221 |
| ISBN-10: | 1935504223 |
| Sprache: | Englisch |
| Ausstattung / Beilage: | Paperback |
| Einband: | Kartoniert / Broschiert |
| Autor: | Bobak, Angelo |
| Hersteller: | Technics Publications |
| Maße: | 254 x 203 x 14 mm |
| Von/Mit: | Angelo Bobak |
| Erscheinungsdatum: | 15.10.2012 |
| Gewicht: | 0,545 kg |
Ähnliche Produkte
Lieferzeit 4-7 Werktage
Lieferzeit 1-2 Werktage
Lieferzeit 4-7 Werktage
Lieferzeit 1-2 Wochen
Lieferzeit 1-2 Wochen
Lieferzeit 4-7 Werktage