LEADER 04746nam 2200625 a 450 001 9910789433603321 005 20200520144314.0 010 $a1-283-34962-0 010 $a9786613349620 010 $a1-84968-345-X 035 $a(CKB)2670000000093584 035 $a(EBL)950523 035 $a(OCoLC)797916385 035 $a(SSID)ssj0000644200 035 $a(PQKBManifestationID)11384122 035 $a(PQKBTitleCode)TC0000644200 035 $a(PQKBWorkID)10670205 035 $a(PQKB)11756590 035 $a(WaSeSS)Ind00024375 035 $a(Au-PeEL)EBL950523 035 $a(CaPaEBR)ebr10471853 035 $a(CaONFJC)MIL334962 035 $a(MiAaPQ)EBC950523 035 $a(PPN)228023904 035 $a(EXLCZ)992670000000093584 100 $a20110607d2011 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aOracle Warehouse Builder 11gR2$b[electronic resource] $egetting started : extract, transform, and load data to build a dynamic, operational data warehouse /$fBob Griesemer 210 $aOlton, Birmingham $cPackt Pub.$d2011 215 $a1 online resource (424 p.) 300 $aIncludes index. 311 $a1-84968-344-1 320 $aIncludes index. 327 $aCover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; 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 327 $aConfiguring the repository and workspacesSummary; Chapter 2: Defining and Importing Source Data Structures; Preliminary analysis; ACME Toys and Gizmos source data; The POS transactional source database; The website order management database; An overview of Warehouse Builder Design Center; Importing/defining source database object metadata; Creating a project; Creating a module; Creating an Oracle Database module; Creating a SQL Server database module; Importing source database objects from a database; Defining source metadata manually with the Table Editor 327 $aImporting source metadata from filesSummary; Chapter 3: Designing the Target Structure; Data warehouse design; Dimensional 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; Creating a target user; Create a target module; OWB design objects; Summary; Chapter 4: Creating the Target Structure in OWB; Creating dimensions in OWB 327 $aThe Time dimensionCreating a Time dimension with the Time Dimension Wizard; The Product dimension; Product 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 editors; Summary 327 $aChapter 5: Extract, Transform, and Load BasicsETL; Manual ETL processes; Staging; To stage or not to stage; Configuration of a staging area; Mappings and operators in OWB; OWB Mappings; The canvas layout; OWB operators; Source and target operators; Transformations (data flow operators); Other operators; Summary; Chapter 6: ETL: Putting it Together; Designing our staging area; Designing the staging area contents; Building the staging area table with the Table Editor; Review of the Mapping Editor; Creating a mapping; Adding source tables; Adding a target table; Connecting source to target 327 $aJoiner operator attribute groups 330 $aExtract, Transform, and Load data to build a dynamic, operational data warehouse with Oracle Warehouse Builder 11g R2 with this book and eBook 606 $aData warehousing 615 0$aData warehousing. 676 $a005.7575 700 $aGriesemer$b Bob$01535080 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910789433603321 996 $aOracle Warehouse Builder 11gR2$93807361 997 $aUNINA