skip to content
The data warehouse ETL toolkit : practical techniques for extracting, cleaning, conforming, and delivering data Preview this item
ClosePreview this item
Checking...

The data warehouse ETL toolkit : practical techniques for extracting, cleaning, conforming, and delivering data

Author: Ralph Kimball; Joe Caserta
Publisher: Indianapolis, IN : Wiley, ©2004.
Edition/Format:   eBook : Document : EnglishView all editions and formats
Summary:
Annotation
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

 

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Genre/Form: Electronic books
Additional Physical Format: Print version:
Kimball, Ralph.
Data warehouse ETL toolkit.
Indianapolis, IN : Wiley, ©2004
(DLC) 2004016909
(OCoLC)56012371
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Ralph Kimball; Joe Caserta
ISBN: 0764579231 9780764579233 0764567578 9780764567575
OCLC Number: 57301227
Reproduction Notes: Electronic reproduction. [S.l.] : HathiTrust Digital Library, 2010. MiAaHDL
Description: 1 online resource (xxxiv, 491 pages) : illustrations
Details: Master and use copy. Digital master created according to Benchmark for Faithful Digital Reproductions of Monographs and Serials, Version 1. Digital Library Federation, December 2002.
Contents: Requirements, Realities, and Architecture --
Surrounding the Requirements --
The Mission of the Data Warehouse --
The Mission of the ETL Team --
ETL Data Structures --
To Stage or Not to Stage --
Designing the Staging Area --
Data Structures in the ETL System --
Planning and Design Standards --
Data Flow --
Extracting --
The Logical Data Map --
Building the Logical Data Map --
Integrating Heterogeneous Data Sources --
The Challenge of Extracting from Disparate Platforms --
Mainframe Sources --
Flat Files --
XML Sources --
Web Log Sources --
ERP System Sources --
Extracting Changed Data --
Cleaning and Conforming --
Defining Data Quality --
Assumptions --
Design Objectives --
Cleaning Deliverables --
Screens and Their Measurements --
Conforming Deliverables --
Delivering Dimension Tables --
The Basic Structure of a Dimension --
The Grain of a Dimension --
The Basic Load Plan for a Dimension --
Flat Dimensions and Snowflaked Dimensions --
Date and Time Dimensions --
Big Dimensions --
Small Dimensions --
One Dimension or Two --
Dimensional Roles --
Dimensions as Subdimensions of Another Dimension --
Degenerate Dimensions --
Slowly Changing Dimensions --
Type 1 Slowly Changing Dimension (Overwrite) --
Type 2 Slowly Changing Dimension (Partitioning History) --
Precise Time Stamping of a Type 2 Slowly Changing Dimension --
Type 3 Slowly Changing Dimension (Alternate Realities) --
Hybrid Slowly Changing Dimensions --
Late-Arriving Dimension Records and Correcting Bad Data --
Multivalued Dimensions and Bridge Tables.
Responsibility: Ralph Kimball, Joe Caserta.
More information:

Abstract:

This text provides solutions to the most labour and time intensive part of data warehouse development.  Read more...

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

All user tags (1)

View most popular tags as: tag list | tag cloud

  • misc  (by 1 person)
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/57301227> # The data warehouse ETL toolkit : practical techniques for extracting, cleaning, conforming, and delivering data
    a schema:MediaObject, schema:CreativeWork, schema:Book ;
   library:oclcnum "57301227" ;
   library:placeOfPublication <http://id.loc.gov/vocabulary/countries/inu> ;
   library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/801288034#Place/indianapolis_in> ; # Indianapolis, IN
   rdfs:comment "Warning: This malformed URI has been treated as a string - 'http://images.contentreserve.com/ImageType-100/0128-1/{8A17B95E-B496-4299-BF63-90AB89AD182A}Img100.jpg'" ;
   schema:about <http://experiment.worldcat.org/entity/work/data/801288034#Topic/computers_database_management_general> ; # COMPUTERS--Database Management--General
   schema:about <http://experiment.worldcat.org/entity/work/data/801288034#Topic/data_warehouse_konzept> ; # Data-Warehouse-Konzept
   schema:about <http://id.worldcat.org/fast/888026> ; # Data warehousing
   schema:about <http://dewey.info/class/005.74/e22/> ;
   schema:about <http://experiment.worldcat.org/entity/work/data/801288034#Topic/bases_de_donnees_conception> ; # Bases de données--Conception
   schema:about <http://experiment.worldcat.org/entity/work/data/801288034#Topic/computers_system_administration_storage_&_retrieval> ; # COMPUTERS--System Administration--Storage & Retrieval
   schema:about <http://experiment.worldcat.org/entity/work/data/801288034#Topic/computers_desktop_applications_databases> ; # COMPUTERS--Desktop Applications--Databases
   schema:about <http://experiment.worldcat.org/entity/work/data/801288034#Topic/entrepots_de_donnees_informatique> ; # Entrepôts de données (Informatique)
   schema:about <http://id.worldcat.org/fast/888032> ; # Database design
   schema:bookFormat schema:EBook ;
   schema:contributor <http://viaf.org/viaf/267463044> ; # Joe Caserta
   schema:copyrightYear "2004" ;
   schema:creator <http://viaf.org/viaf/24756580> ; # Ralph Kimball
   schema:datePublished "2004" ;
   schema:description "Annotation"@en ;
   schema:exampleOfWork <http://worldcat.org/entity/work/id/801288034> ;
   schema:genre "Electronic books"@en ;
   schema:inLanguage "en" ;
   schema:isSimilarTo <http://www.worldcat.org/oclc/56012371> ;
   schema:name "The data warehouse ETL toolkit : practical techniques for extracting, cleaning, conforming, and delivering data"@en ;
   schema:productID "57301227" ;
   schema:publication <http://www.worldcat.org/title/-/oclc/57301227#PublicationEvent/indianapolis_in_wiley_2004> ;
   schema:publisher <http://experiment.worldcat.org/entity/work/data/801288034#Agent/wiley> ; # Wiley
   schema:url <http://site.ebrary.com/id/10274663> ;
   schema:url <http://public.eblib.com/choice/publicfullrecord.aspx?p=219051> ;
   schema:url <http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=124355> ;
   schema:url <http://www.books24x7.com/marc.asp?isbn=0764567578> ;
   schema:url <http://proquest.tech.safaribooksonline.de/9780764567575> ;
   schema:url <http://swbplus.bsz-bw.de/bsz355428644cov.htm> ;
   schema:url <https://www.overdrive.com/search?q=8A17B95E-B496-4299-BF63-90AB89AD182A> ;
   schema:url <http://belhaven.idm.oclc.org/login?url=http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=124355> ;
   schema:url "http://images.contentreserve.com/ImageType-100/0128-1/{8A17B95E-B496-4299-BF63-90AB89AD182A}Img100.jpg" ;
   schema:url <http://public.ebookcentral.proquest.com/choice/publicfullrecord.aspx?p=219051> ;
   schema:url <http://www.books24x7.com/marc.asp?bookid=11237> ;
   schema:url <http://proquest.safaribooksonline.com/9780764567575> ;
   schema:url <http://www.myilibrary.com?id=25228> ;
   schema:url <https://samples.overdrive.com/data-warehouse-etl?.epub-sample.overdrive.com> ;
   schema:url <http://catdir.loc.gov/catdir/toc/ecip0420/2004016909.html> ;
   schema:url <http://catalog.hathitrust.org/api/volumes/oclc/56012371.html> ;
   schema:url <http://books.google.com/books?id=AeBQAAAAMAAJ> ;
   schema:workExample <http://worldcat.org/isbn/9780764579233> ;
   schema:workExample <http://worldcat.org/isbn/9780764567575> ;
   wdrs:describedby <http://www.worldcat.org/title/-/oclc/57301227> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/801288034#Place/indianapolis_in> # Indianapolis, IN
    a schema:Place ;
   schema:name "Indianapolis, IN" ;
    .

<http://experiment.worldcat.org/entity/work/data/801288034#Topic/bases_de_donnees_conception> # Bases de données--Conception
    a schema:Intangible ;
   schema:name "Bases de données--Conception"@fr ;
    .

<http://experiment.worldcat.org/entity/work/data/801288034#Topic/computers_database_management_general> # COMPUTERS--Database Management--General
    a schema:Intangible ;
   schema:name "COMPUTERS--Database Management--General"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/801288034#Topic/computers_desktop_applications_databases> # COMPUTERS--Desktop Applications--Databases
    a schema:Intangible ;
   schema:name "COMPUTERS--Desktop Applications--Databases"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/801288034#Topic/computers_system_administration_storage_&_retrieval> # COMPUTERS--System Administration--Storage & Retrieval
    a schema:Intangible ;
   schema:name "COMPUTERS--System Administration--Storage & Retrieval"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/801288034#Topic/data_warehouse_konzept> # Data-Warehouse-Konzept
    a schema:Intangible ;
   schema:name "Data-Warehouse-Konzept"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/801288034#Topic/entrepots_de_donnees_informatique> # Entrepôts de données (Informatique)
    a schema:Intangible ;
   schema:name "Entrepôts de données (Informatique)"@fr ;
    .

<http://id.worldcat.org/fast/888026> # Data warehousing
    a schema:Intangible ;
   schema:name "Data warehousing"@en ;
    .

<http://id.worldcat.org/fast/888032> # Database design
    a schema:Intangible ;
   schema:name "Database design"@en ;
    .

<http://viaf.org/viaf/24756580> # Ralph Kimball
    a schema:Person ;
   schema:familyName "Kimball" ;
   schema:givenName "Ralph" ;
   schema:name "Ralph Kimball" ;
    .

<http://viaf.org/viaf/267463044> # Joe Caserta
    a schema:Person ;
   schema:birthDate "1965" ;
   schema:familyName "Caserta" ;
   schema:givenName "Joe" ;
   schema:name "Joe Caserta" ;
    .

<http://worldcat.org/isbn/9780764567575>
    a schema:ProductModel ;
   schema:isbn "0764567578" ;
   schema:isbn "9780764567575" ;
    .

<http://worldcat.org/isbn/9780764579233>
    a schema:ProductModel ;
   schema:isbn "0764579231" ;
   schema:isbn "9780764579233" ;
    .

<http://www.worldcat.org/oclc/56012371>
    a schema:CreativeWork ;
   rdfs:label "Data warehouse ETL toolkit." ;
   schema:description "Print version:" ;
   schema:isSimilarTo <http://www.worldcat.org/oclc/57301227> ; # The data warehouse ETL toolkit : practical techniques for extracting, cleaning, conforming, and delivering data
    .

<http://www.worldcat.org/title/-/oclc/57301227>
    a genont:InformationResource, genont:ContentTypeGenericResource ;
   schema:about <http://www.worldcat.org/oclc/57301227> ; # The data warehouse ETL toolkit : practical techniques for extracting, cleaning, conforming, and delivering data
   schema:dateModified "2017-12-23" ;
   void:inDataset <http://purl.oclc.org/dataset/WorldCat> ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.