LEADER 04991nam 2200673Ia 450 001 9910780781803321 005 20200520144314.0 010 $a9786612257292 010 $a1-282-25729-3 010 $a1-84719-575-X 035 $a(CKB)2430000000040696 035 $a(EBL)956349 035 $a(OCoLC)798536452 035 $a(SSID)ssj0000349335 035 $a(PQKBManifestationID)11297042 035 $a(PQKBTitleCode)TC0000349335 035 $a(PQKBWorkID)10348301 035 $a(PQKB)10626386 035 $a(MiAaPQ)EBC956349 035 $a(Au-PeEL)EBL956349 035 $a(CaPaEBR)ebr10448382 035 $a(CaONFJC)MIL225729 035 $a(PPN)228021758 035 $a(EXLCZ)992430000000040696 100 $a20091207d2009 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aOracle Warehouse Builder 11g$b[electronic resource] $egetting started : extract, transform, and load data to build a dynamic, operational data warehouse /$fBob Griesemer ; reviewers, Anitha Kadaru, Yasodarani Venkatesan 210 $aBirmingham, UK $cPackt Publishing$d2009 215 $a1 online resource (368 p.) 225 1 $aFrom technologies to solutions 300 $aDescription based upon print version of record. 311 $a1-84719-574-1 320 $aIncludes bibliographical references and index. 327 $aCover; Table of Contents; Preface; Chapter 1: An Introduction to Oracle Warehouse Builder; Introduction to data warehousing; Introduction to our fictional organization; What is a data warehouse?; Where does OWB fit in?; Installation of the database and OWB; Downloading the Oracle software; A word about hardware and operating systems; Installing Oracle database software; Configuring the listener; Creating the database; Installing the OWB standalone software; OWB components and architecture; Configuring the repository and workspaces; Summary 327 $aChapter 2: Defining and Importing Source Data StructuresPreliminary analysis; ACME Toys and Gizmos source data; The POS transactional source database; The web site order management database; An overview of Warehouse Builder Design Center; Importing/defining source metadata; Creating a project; Creating a module; Creating an Oracle Database module; Creating a SQL Server database module; Importing source metadata from a database; Defining source metadata manually with the Data Object Editor; Importing source metadata from files; Summary; Chapter 3: Designing the Target Structure 327 $aData warehouse designDimensional design; Cube and dimensions; Implementation of a dimensional model in a database; Relational implementation (star schema); Multidimensional implementation (OLAP); Designing the ACME data warehouse; Identifying the dimensions; Designing the cube; Data warehouse design in OWB; Creating a target user and module; Create a target user; Create a target module; OWB design objects; Summary; Chapter 4: Creating the Target Structure in OWB; Creating dimensions in OWB; The Time dimension; Creating a Time dimension with the Time Dimension Wizard; The Product dimension 327 $aProduct Attributes (attribute type)Product Levels; Product Hierarchy (highest to lowest); Creating the Product dimension with the New Dimension Wizard; The Store dimension; Store Attributes (attribute type), data type and size, and (Identifier); Store Levels; Store Hierarchy (highest to lowest); Creating the Store dimension with the New Dimension Wizard; Creating a cube in OWB; Creating a cube with the wizard; Using the Data Object Editor; Summary; Chapter 5: Extract, Transform, and Load Basics; ETL; Manual ETL processes; Staging; To stage or not to stage; Configuration of a staging area 327 $aMappings and operators in OWBThe canvas layout; OWB operators; Source and target operators; Data flow operators; Pre/post-processing operators; Summary; Chapter 6: ETL: Putting it Together; Designing and building an ETL mapping; Designing our staging area; Designing the staging area contents; Building the staging area table with the Data Object Editor; Designing our mapping; Review of the Mapping Editor; Creating a mapping; Summary; Chapter 7: ETL: Transformations and Other Operators; STORE mapping; Adding source and target operators; Adding Transformation Operators 327 $aUsing a Key Lookup operator 330 $aExtract, Transform, and Load data to build a dynamic, operational data warehouse 606 $aData warehousing 606 $aDatabase management 615 0$aData warehousing. 615 0$aDatabase management. 676 $a005.75/75 700 $aGriesemer$b Bob$01535080 701 $aKadaru$b Anitha$01535081 701 $aVenkatesan$b Yasodarani$01535082 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910780781803321 996 $aOracle Warehouse Builder 11g$93783063 997 $aUNINA