Oracle Warehouse Builder 11g [[electronic resource] ] : getting started : extract, transform, and load data to build a dynamic, operational data warehouse / / Bob Griesemer ; reviewers, Anitha Kadaru, Yasodarani Venkatesan |
Autore | Griesemer Bob |
Pubbl/distr/stampa | Birmingham, UK, : Packt Publishing, 2009 |
Descrizione fisica | 1 online resource (368 p.) |
Disciplina | 005.75/75 |
Altri autori (Persone) |
KadaruAnitha
VenkatesanYasodarani |
Collana | From technologies to solutions |
Soggetto topico |
Data warehousing
Database management |
Soggetto genere / forma | Electronic books. |
ISBN |
9786612257292
1-282-25729-3 1-84719-575-X |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; 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
Chapter 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 Data 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 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 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 Mappings 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 Using a Key Lookup operator |
Record Nr. | UNINA-9910456634703321 |
Griesemer Bob | ||
Birmingham, UK, : Packt Publishing, 2009 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Oracle Warehouse Builder 11g [[electronic resource] ] : getting started : extract, transform, and load data to build a dynamic, operational data warehouse / / Bob Griesemer ; reviewers, Anitha Kadaru, Yasodarani Venkatesan |
Autore | Griesemer Bob |
Pubbl/distr/stampa | Birmingham, UK, : Packt Publishing, 2009 |
Descrizione fisica | 1 online resource (368 p.) |
Disciplina | 005.75/75 |
Altri autori (Persone) |
KadaruAnitha
VenkatesanYasodarani |
Collana | From technologies to solutions |
Soggetto topico |
Data warehousing
Database management |
ISBN |
9786612257292
1-282-25729-3 1-84719-575-X |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; 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
Chapter 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 Data 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 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 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 Mappings 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 Using a Key Lookup operator |
Record Nr. | UNINA-9910780781803321 |
Griesemer Bob | ||
Birmingham, UK, : Packt Publishing, 2009 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Oracle Warehouse Builder 11g : getting started : extract, transform, and load data to build a dynamic, operational data warehouse / / Bob Griesemer ; reviewers, Anitha Kadaru, Yasodarani Venkatesan |
Autore | Griesemer Bob |
Edizione | [1st ed.] |
Pubbl/distr/stampa | Birmingham, UK, : Packt Publishing, 2009 |
Descrizione fisica | 1 online resource (368 p.) |
Disciplina | 005.75/75 |
Altri autori (Persone) |
KadaruAnitha
VenkatesanYasodarani |
Collana | From technologies to solutions |
Soggetto topico |
Data warehousing
Database management |
ISBN |
9786612257292
1-282-25729-3 1-84719-575-X |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; 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
Chapter 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 Data 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 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 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 Mappings 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 Using a Key Lookup operator |
Record Nr. | UNINA-9910829291803321 |
Griesemer Bob | ||
Birmingham, UK, : Packt Publishing, 2009 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Oracle Warehouse Builder 11gR2 [[electronic resource] ] : getting started : extract, transform, and load data to build a dynamic, operational data warehouse / / Bob Griesemer |
Autore | Griesemer Bob |
Pubbl/distr/stampa | Olton, Birmingham, : Packt Pub., 2011 |
Descrizione fisica | 1 online resource (424 p.) |
Disciplina | 005.7575 |
Soggetto topico | Data warehousing |
Soggetto genere / forma | Electronic books. |
ISBN |
1-283-34962-0
9786613349620 1-84968-345-X |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; 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
Configuring 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 Importing 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 The 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 Chapter 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 Joiner operator attribute groups |
Record Nr. | UNINA-9910461295303321 |
Griesemer Bob | ||
Olton, Birmingham, : Packt Pub., 2011 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Oracle Warehouse Builder 11gR2 [[electronic resource] ] : getting started : extract, transform, and load data to build a dynamic, operational data warehouse / / Bob Griesemer |
Autore | Griesemer Bob |
Pubbl/distr/stampa | Olton, Birmingham, : Packt Pub., 2011 |
Descrizione fisica | 1 online resource (424 p.) |
Disciplina | 005.7575 |
Soggetto topico | Data warehousing |
ISBN |
1-283-34962-0
9786613349620 1-84968-345-X |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; 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
Configuring 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 Importing 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 The 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 Chapter 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 Joiner operator attribute groups |
Record Nr. | UNINA-9910789433603321 |
Griesemer Bob | ||
Olton, Birmingham, : Packt Pub., 2011 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Oracle Warehouse Builder 11gR2 : getting started : extract, transform, and load data to build a dynamic, operational data warehouse / / Bob Griesemer |
Autore | Griesemer Bob |
Edizione | [1st ed.] |
Pubbl/distr/stampa | Olton, Birmingham, : Packt Pub., 2011 |
Descrizione fisica | 1 online resource (424 p.) |
Disciplina | 005.7575 |
Soggetto topico | Data warehousing |
ISBN |
1-283-34962-0
9786613349620 1-84968-345-X |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; 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
Configuring 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 Importing 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 The 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 Chapter 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 Joiner operator attribute groups |
Record Nr. | UNINA-9910826760303321 |
Griesemer Bob | ||
Olton, Birmingham, : Packt Pub., 2011 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|