Data mapping for data warehouse design / (Record no. 247262)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 05229cam a2200505Ii 4500 |
| 001 - CONTROL NUMBER | |
| control field | ocn932289266 |
| 003 - CONTROL NUMBER IDENTIFIER | |
| control field | OCoLC |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20190328114813.0 |
| 006 - FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS | |
| fixed length control field | m o d |
| 007 - PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION | |
| fixed length control field | cr cnu---unuuu |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 151216s2016 ne ob 000 0 eng d |
| 040 ## - CATALOGING SOURCE | |
| Original cataloging agency | N$T |
| Language of cataloging | eng |
| Description conventions | rda |
| -- | pn |
| Transcribing agency | N$T |
| Modifying agency | IDEBK |
| -- | N$T |
| -- | YDXCP |
| -- | OCLCF |
| -- | CDX |
| -- | OPELS |
| -- | B24X7 |
| -- | STF |
| -- | DEBSZ |
| -- | AU@ |
| -- | OCLCQ |
| -- | D6H |
| -- | LIV |
| -- | OCLCQ |
| -- | U3W |
| -- | WRM |
| -- | COO |
| -- | OCLCQ |
| 019 ## - | |
| -- | 956740331 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9780128053355 |
| Qualifying information | (electronic bk.) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 0128053356 |
| Qualifying information | (electronic bk.) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| Canceled/invalid ISBN | 9780128051856 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (OCoLC)932289266 |
| Canceled/invalid control number | (OCoLC)956740331 |
| 050 #4 - LIBRARY OF CONGRESS CALL NUMBER | |
| Classification number | QA76.9.D37 |
| 072 #7 - SUBJECT CATEGORY CODE | |
| Subject category code | COM |
| Subject category code subdivision | 021030 |
| Source | bisacsh |
| 082 04 - DEWEY DECIMAL CLASSIFICATION NUMBER | |
| Classification number | 005.74 |
| Edition number | 23 |
| 100 1# - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Haq, Qazi Muhammad Rashid Ul, |
| Relator term | author. |
| 245 10 - TITLE STATEMENT | |
| Title | Data mapping for data warehouse design / |
| Medium | [electronic resource] |
| Statement of responsibility, etc. | Qamar Shahbaz Ul Haq. |
| 264 #1 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE | |
| Place of production, publication, distribution, manufacture | Amsterdam : |
| Name of producer, publisher, distributor, manufacturer | Elsevier, |
| Date of production, publication, distribution, manufacture, or copyright notice | 2016. |
| 264 #4 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE | |
| Date of production, publication, distribution, manufacture, or copyright notice | �2016 |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | 1 online resource |
| 336 ## - CONTENT TYPE | |
| Content type term | text |
| Content type code | txt |
| Source | rdacontent |
| 337 ## - MEDIA TYPE | |
| Media type term | computer |
| Media type code | c |
| Source | rdamedia |
| 338 ## - CARRIER TYPE | |
| Carrier type term | online resource |
| Carrier type code | cr |
| Source | rdacarrier |
| 588 0# - SOURCE OF DESCRIPTION NOTE | |
| Source of description note | Online resource; title from PDF title page (EBSCO, viewed December 18, 2015). |
| 504 ## - BIBLIOGRAPHY, ETC. NOTE | |
| Bibliography, etc | Includes bibliographical references. |
| 520 ## - SUMMARY, ETC. | |
| Summary, etc. | Data mapping in data warehouse lifecycle is the process of creating a link between two distinct data models' (source and target) tables/attributes. It is required at many stages of DW life-cycle to transform data from one state to another; every stage has its own unique requirements and challenges. This book provides basic and advanced knowledge about data mapping/data transformation. It contains real life scenarios that readers face and presents solutions/standard techniques across various domains. -- |
| Assigning source | Edited summary from book. |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Front Cover -- Data Mapping for Data Warehouse Design -- Copyright Page -- Dedication -- Contents -- 1 Introduction -- Definition -- 2 Data Mapping Stages -- Mapping from the Source to the Data Warehouse Landing Area -- Mapping from the Landing Area to the Staging Database -- Mapping from the Staging Database to the Load Ready or Target Database -- Mapping from Logical Data Model to the Semantic or Access Layer -- 3 Data Mapping Types -- Logical Data Mapping -- Physical Data Mapping -- 4 Data Models -- Definition -- Entity -- Relationship -- Attributes -- Normalized Data Model. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | First Normal Form -- Second Normal Form -- Third Normal Form -- Dimensional Data Model -- Fact -- Dimension -- Measure -- Drill-Down and Roll-Up -- Star Schema -- Fact Tables -- Dimension Tables -- 5 Data Mapper's Strategy and Focus -- Mapper Who? How Does He or She Do It? -- 6 Uniqueness of Attributes and its Importance -- Telecom -- Manufacturing -- Finance -- Uniqueness in Data Warehouse -- 7 Prerequisites of Data Mapping -- Logical Data Model -- Entities and Their Description -- Attributes and Their Description -- Primary Key of Entities -- Relationship Between Entities. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Cardinality of the Relationship -- Change Capture Column of History-Handled Entities -- Physical Data Model -- Source System Data Model -- Source System Table and Attribute Details -- Subject Matter Expert -- Production Quality Data -- 8 Surrogate Keys versus Natural Keys -- Natural Keys -- Surrogate Keys -- 9 Data Mapping Document Format -- Header-Level Rules -- Column-Level Rules -- Major Parts of the Data Mapping Document -- Data Mapping Columns Explained -- Change Date -- Subject Area -- Target Table Name -- Target Column Name -- Data Type -- PK -- Nullable -- Source System -- Record ID. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Source Table Name -- Source Column Name -- Data Type of Source Column -- Transformation Category -- Transformation Rule -- Updated By -- Mapping Priority or Sequence -- 10 Data Analysis Techniques -- Source Data Sample -- Direct Access -- Extraction from a Source -- Data Files -- What to Look For -- High-Level Inter-Source System Relationship -- Intra-Source System Table-Level Analysis -- Column-Level Analysis -- Uniqueness -- Full Row Duplicates -- Primary Key Duplicates -- Multiple Extracts -- Source System Updates -- History Pattern Analysis -- Type 0 -- Type 1 -- Type 2 -- Type 3 -- Type 4. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Type 6 -- Temporal Database -- Transaction Time -- Definition -- Limitations -- Valid Time -- Definition -- Limitations -- History Data Verification -- SQL Tools -- Automatic Query Generators -- Aggregate Functions -- Window and Rank Functions -- Microsoft Excel and Other Tools -- Remove Duplicates -- Sort -- Pivot Tables -- 11 Data Quality -- What Is Data Quality? -- How Do You Benefit from Data Quality? -- Factors Determining Data Quality -- Accurate Data -- Complete Data -- Legible Data -- Relevant Data -- Reliable Data -- Timely Data -- Valid Data. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | Data warehousing. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | Data mining. |
| 650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | COMPUTERS |
| General subdivision | Databases |
| -- | Data Mining. |
| Source of heading or term | bisacsh |
| 650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | Data mining. |
| Source of heading or term | fast |
| Authority record control number | (OCoLC)fst00887946 |
| 650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | Data warehousing. |
| Source of heading or term | fast |
| Authority record control number | (OCoLC)fst00888026 |
| 655 #4 - INDEX TERM--GENRE/FORM | |
| Genre/form data or focus term | Electronic books. |
| 776 08 - ADDITIONAL PHYSICAL FORM ENTRY | |
| Relationship information | Erscheint auch als: |
| Main entry heading | Ul Haq, Qamar Shahbaz. |
| Title | Data mapping for data warehouse design |
| 856 40 - ELECTRONIC LOCATION AND ACCESS | |
| Materials specified | ScienceDirect |
| Uniform Resource Identifier | http://www.sciencedirect.com/science/book/9780128051856 |
No items available.