TY  - BOOK
AU  - Kimball,Ralph
AU  - Caserta,Joe
TI  - The data warehouse ETL toolkit: practical techniques for extracting, cleaning, conforming, and delivering data 
SN  - 0764579231 (electronic bk.)
AV  - QA76.9.D37 K53 2004eb
U1  - 005.74 22
PY  - 2004///
CY  - Indianapolis, IN
PB  - Wiley
KW  - Data warehousing
KW  - Database design
KW  - COMPUTERS
KW  - Desktop Applications
KW  - Databases
KW  - bisacsh
KW  - Database Management
KW  - General
KW  - System Administration
KW  - Storage & Retrieval
KW  - fast
KW  - Electronic book collection
KW  - Entrepôts de données (Informatique)
KW  - Bases de données
KW  - Conception
KW  - local
KW  - Data-Warehouse-Konzept
KW  - swd
KW  - Electronic books
N1  - Includes index; 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; Electronic reproduction; [S.l.]; HathiTrust Digital Library; 2010
N2  - Annotation; Cowritten by Ralph Kimball, the world's leading data warehousing authority, whose previous books have sold more than 150,000 copiesDelivers real-world solutions for the most time- and labor-intensive portion of data warehousing-data staging, or the extract, transform, load (ETL) processDelineates best practices for extracting data from scattered sources, removing redundant and inaccurate data, transforming the remaining data into correctly formatted data structures, and then loading the end product into the data warehouseOffers proven time-saving ETL techniques, comprehensive guidance on building dimensional structures, and crucial advice on ensuring data quality
UR  - http://148.231.10.114:2048/login?url=http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&an=124355
ER  -