Cover for Data Mapping for Data Warehouse Design

Data Mapping for Data Warehouse Design

Book2016

Author:

Qamar Shahbaz Ul Haq

Data Mapping for Data Warehouse Design

Book2016

 

Cover for Data Mapping for Data Warehouse Design

Author:

Qamar Shahbaz Ul Haq

About the book

Browse this book

Book description

Data mapping in a data warehouse is the process of creating a link between two distinct data models’ (source and target) tables/attributes. Data mapping is required at many stages ... read full description

Browse content

Table of contents

Actions for selected chapters

Select all / Deselect all

  1. Full text access
  2. Book chapterAbstract only

    Chapter 1 - Introduction

    Page 1

  3. Book chapterAbstract only

    Chapter 2 - Data Mapping Stages

    Pages 3-4

  4. Book chapterAbstract only

    Chapter 3 - Data Mapping Types

    Page 5

  5. Book chapterAbstract only

    Chapter 4 - Data Models

    Pages 7-16

  6. Book chapterAbstract only

    Chapter 5 - Data Mapper’s Strategy and Focus

    Pages 17-20

  7. Book chapterAbstract only

    Chapter 6 - Uniqueness of Attributes and its Importance

    Pages 21-24

  8. Book chapterAbstract only

    Chapter 7 - Prerequisites of Data Mapping

    Pages 25-28

  9. Book chapterAbstract only

    Chapter 8 - Surrogate Keys versus Natural Keys

    Pages 29-30

  10. Book chapterAbstract only

    Chapter 9 - Data Mapping Document Format

    Pages 31-35

  11. Book chapterAbstract only

    Chapter 10 - Data Analysis Techniques

    Pages 37-66

  12. Book chapterAbstract only

    Chapter 11 - Data Quality

    Pages 67-82

  13. Book chapterAbstract only

    Chapter 12 - Data Mapping Scenarios

    Pages 83-165

  14. Book chapterNo access

    Glossary and Nomenclature List

    Pages 167-168

  15. Book chapterNo access

    Bibliography

    Page 169

About the book

Description

Data mapping in a data warehouse is the process of creating a link between two distinct data models’ (source and target) tables/attributes. Data mapping is required at many stages of DW life-cycle to help save processor overhead; every stage has its own unique requirements and challenges. Therefore, many data warehouse professionals want to learn data mapping in order to move from an ETL (extract, transform, and load data between databases) developer to a data modeler role. Data Mapping for Data Warehouse Design provides basic and advanced knowledge about business intelligence and data warehouse concepts including real life scenarios that apply the standard techniques to projects across various domains. After reading this book, readers will understand the importance of data mapping across the data warehouse life cycle.

Data mapping in a data warehouse is the process of creating a link between two distinct data models’ (source and target) tables/attributes. Data mapping is required at many stages of DW life-cycle to help save processor overhead; every stage has its own unique requirements and challenges. Therefore, many data warehouse professionals want to learn data mapping in order to move from an ETL (extract, transform, and load data between databases) developer to a data modeler role. Data Mapping for Data Warehouse Design provides basic and advanced knowledge about business intelligence and data warehouse concepts including real life scenarios that apply the standard techniques to projects across various domains. After reading this book, readers will understand the importance of data mapping across the data warehouse life cycle.

Key Features

  • Covers all stages of data warehousing and the role of data mapping in each
  • Includes a data mapping strategy and techniques that can be applied to many situations
  • Based on the author’s years of real-world experience designing solutions
  • Covers all stages of data warehousing and the role of data mapping in each
  • Includes a data mapping strategy and techniques that can be applied to many situations
  • Based on the author’s years of real-world experience designing solutions

Details

ISBN

978-0-12-805185-6

Language

English

Published

2016

Copyright

Copyright © 2016 Elsevier Inc. All rights reserved.

Imprint

Morgan Kaufmann

Authors

Qamar Shahbaz Ul Haq