Cargando…
Oracle Warehouse Builder 11g R2 Getting Started 2011.
Extract, Transform, and Load data to build a dynamic, operational data warehouse with Oracle Warehouse Builder 11g R2 with this book and eBook.
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Pub.,
2011.
|
| Temas: | |
| Acceso en línea: | Texto completo |
MARC
| LEADER | 00000cam a2200000Mu 4500 | ||
|---|---|---|---|
| 001 | EBOOKCENTRAL_ocn797916385 | ||
| 003 | OCoLC | ||
| 005 | 20240329122006.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 121121s2011 enk o 000 0 eng d | ||
| 040 | |a EBLCP |b eng |e pn |c EBLCP |d OCLCQ |d S4S |d OCLCQ |d DEBSZ |d OCLCQ |d FEM |d ZCU |d MERUC |d ICG |d OCLCO |d OCLCF |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO |d DKC |d AU@ |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO | ||
| 019 | |a 793586004 |a 968073801 |a 969035961 | ||
| 020 | |a 9781849683456 | ||
| 020 | |a 184968345X | ||
| 029 | 1 | |a DEBBG |b BV044166740 | |
| 029 | 1 | |a DEBSZ |b 39733396X | |
| 035 | |a (OCoLC)797916385 |z (OCoLC)793586004 |z (OCoLC)968073801 |z (OCoLC)969035961 | ||
| 037 | |b 01201872 | ||
| 050 | 4 | |a QA76.9 .D37 G74 2011 | |
| 082 | 0 | 4 | |a 005.7575 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Griesemer, Bob. | |
| 245 | 1 | 0 | |a Oracle Warehouse Builder 11g R2 Getting Started 2011. |
| 260 | |a Birmingham : |b Packt Pub., |c 2011. | ||
| 300 | |a 1 online resource (710 pages) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 347 | |a text file |2 rda | ||
| 505 | 0 | |a Oracle Warehouse Builder 11gR2: Getting Started; Oracle Warehouse Builder 11gR2: Getting Started; Credits; About the Author; About the Reviewers; www.PacktPub.com; Support files, eBooks, discount offers, and more; Why Subscribe?; Free Access for Packt account holders; Instant Updates on New Packt Books; Preface; What this book covers; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Downloading the example code; Errata; Piracy; Questions; 1. An Introduction to Oracle Warehouse Builder; Introduction to data warehousing. | |
| 505 | 8 | |a Introduction to our fictional organizationWhat 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; 2. Defining and Importing Source Data Structures; Preliminary analysis; ACME Toys and Gizmos source data; The POS transactional source database. | |
| 505 | 8 | |a The website order management databaseAn 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; Creating a SQL Server database connection; Configuring Oracle to connect to SQL Server; Creating a heterogeneous service configuration file; Editing the listener.ora file; Creating the Warehouse Builder ODBC module for SQL Server; Importing source database objects from a database; Defining source metadata manually with the Table Editor. | |
| 505 | 8 | |a Importing source metadata from filesSummary; 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; 4. Creating the Target Structure in OWB; Creating dimensions in OWB; The Time dimension. | |
| 505 | 8 | |a Creating a Time dimension with the Time Dimension WizardThe 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; 5. Extract, Transform, and Load Basics; ETL. | |
| 500 | |a Manual ETL processes. | ||
| 520 | |a Extract, Transform, and Load data to build a dynamic, operational data warehouse with Oracle Warehouse Builder 11g R2 with this book and eBook. | ||
| 588 | 0 | |a Print version record. | |
| 590 | |a ProQuest Ebook Central |b Ebook Central Academic Complete | ||
| 630 | 0 | 0 | |a Oracle (Computer file) |
| 630 | 0 | 7 | |a Oracle (Computer file) |2 fast |
| 650 | 0 | |a Data warehousing. | |
| 650 | 6 | |a Entrepôts de données (Informatique) | |
| 650 | 7 | |a Data warehousing |2 fast | |
| 776 | 0 | 8 | |i Print version: |a Griesemer, Bob. |t Oracle Warehouse Builder 11g R2 Getting Started 2011. |d Birmingham : Packt Publishing, ©2011 |z 9781849683449 |
| 856 | 4 | 0 | |u https://ebookcentral.uam.elogim.com/lib/uam-ebooks/detail.action?docID=950523 |z Texto completo |
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL950523 | ||
| 994 | |a 92 |b IZTAP | ||