Index
A
- ACME, data warehouse design
- designing / Designing the ACME data warehouse
- dimensions, designing / Identifying the dimensions
- cube, designing / Designing the cube
- Add option
- about / Configuring the listener
- advanced installation method
- AND function
- Automatic SQL Tuning Advisor
- about / Creating the database
B
- basic installation method
- Business Identifier
C
- cardinality
- Control Center Service, deployment process
- launching / The Control Center Manager
- window overview / The Control Center Manager window overview, The Object Details window, The Control Center Jobs window
- window, using / The Control Center Manager window overview
- Object Details window / The Object Details window
- Control Center Jobs window / The Control Center Jobs window
- deploying / Deploying in the Control Center Manager
- cube details window, Data Object Editor
- name tab / Using the Data Object Editor
- storage tab / Using the Data Object Editor
- dimensions tab / Using the Data Object Editor
- measures tab / Using the Data Object Editor
- data viewer tab / Using the Data Object Editor
D
- database
- database and OWB installation
- Oracle software, downloading / Downloading the Oracle software
- hardware systems / A word about hardware and operating systems
- operating systems / A word about hardware and operating systems
- Enterprise Edition / A word about hardware and operating systems
- hard disk space / A word about hardware and operating systems
- Intel Core 2 processor / A word about hardware and operating systems
- on Windows installation / A word about hardware and operating systems
- Oracle database software, installing / Installing Oracle database software
- listener, configuring / Configuring the listener
- default listener port, changing or not / Configuring the listener
- database, creating / Creating the database, Insdatabase and OWB installationdatabase, creatingtalling the OWB standalone software
- OWB standalone software, installing / Insdatabase and OWB installationdatabase, creatingtalling the OWB standalone software
- OWB, components / OWB components and architecture
- repository, configuring / Configuring the repository and workspaces
- workspace, configuring / Configuring the repository and workspaces
- data flow operator, OWB operator
- aggregator / Data flow operators
- deduplicator / Data flow operators
- expression / Data flow operators
- joiner / Data flow operators
- filter / Data flow operators
- key lookup / Data flow operators
- pivot / Data flow operators
- set operation / Data flow operators
- splitter / Data flow operators
- transformation operator / Data flow operators
- Data Object Editor
- about / The Time dimension
- using / Using the Data Object Editor
- canvas window / Using the Data Object Editor
- explorer window / Using the Data Object Editor
- configuration window / Using the Data Object Editor
- using, palette window / Using the Data Object Editor
- Bird's Eye View window / Using the Data Object Editor
- Dimension Details window / Using the Data Object Editor
- cube details window / Using the Data Object Editor
- using, to build stage area table / Building the staging area table with the Data Object Editor
- name tab / Building the staging area table with the Data Object Editor
- columns tab / Building the staging area table with the Data Object Editor
- constraints tab / Building the staging area table with the Data Object Editor
- indexes tab / Building the staging area table with the Data Object Editor
- partition tab / Building the staging area table with the Data Object Editor
- attribute set tab / Building the staging area table with the Data Object Editor
- data rule tab / Building the staging area table with the Data Object Editor
- Data Viewser tab / Building the staging area table with the Data Object Editor
- and Mapping Editor, comparing / Review of the Mapping Editor
- validating / Validating in the Data Object Editor, Validating in the Mapping Editor
- data rule
- data warehouse, building
- validation process / Validating
- steps / Generating, Deploying, Executing, Deploying and executing remaining objects
- generation process / Generating
- deployment process / Deploying
- execution process / Executing
- remaining objects, exdecuting / Deploying and executing remaining objects
- remaining objects, deploying / Deploying and executing remaining objects
- data warehouse design
- about / Data warehouse design
- advantage / Data warehouse design
- dimensional design / Dimensional design
- ACME, designing / Designing the ACME data warehouse
- data warehouse design, in OWB
- about / Data warehouse design in OWB
- target user, creating / Creating a target user and module, Create a target user
- target module, creating / Creating a target user and module, Create a target module
- design objects / OWB design objects
- data warehousing
- capitalization / Adding a Constant operator
- DBA (Database Administrator)
- defining / The POS transactional source database
- DDL
- about / Generating
- deployment process
- Control Center Service / Deploying, Deploying in the Design Center and Data Object Editor, The Control Center Manager
- Control Centre Service, starting / The Control Center Service
- Control Centre Service, stoping / The Control Center Service
- in Design Centre / Deploying in the Design Center and Data Object Editor
- in Data Object Editor / Deploying in the Design Center and Data Object Editor
- of remaining objects / Deploying and executing remaining objects
- objects, deploying / Deployment Order
- sequence, deploying / Deployment Order
- tables, deploying / Deployment Order
- dimensions, deploying / Deployment Order
- cube, deploying / Deployment Order
- external tables, deploying / Deployment Order
- mapping, deploying / Deployment Order
- Design Centre
- overview / An overview of Warehouse Builder Design Center
- screen structure / An overview of Warehouse Builder Design Center
- Project Explorer / An overview of Warehouse Builder Design Center
- Connection Explorer / An overview of Warehouse Builder Design Center
- PL/SQL / An overview of Warehouse Builder Design Center
- Global Explorer / An overview of Warehouse Builder Design Center
- transformation / An overview of Warehouse Builder Design Center
- data rules / An overview of Warehouse Builder Design Center
- dimensional design, data warehouse design
- about / Dimensional design
- time dimensions / Cube and dimensions
- store dimensions / Cube and dimensions
- product dimensions / Cube and dimensions
- Rubik's Cube / Cube and dimensions
- cube, depth dimension / Cube and dimensions
- cube, width dimension / Cube and dimensions
- cube, length dimension / Cube and dimensions
- implementing, in database / Implementation of a dimensional model in a database
- relational implementation (star schema) / Implementation of a dimensional model in a database, Relational implementation (star schema)
- multidimensional implementation / Implementation of a dimensional model in a database, Multidimensional implementation (OLAP)
- Dimension Details window, Data Object Editor
- name tab / Using the Data Object Editor
- storage tab / Using the Data Object Editor
- attributes tab / Using the Data Object Editor
- levels tab / Using the Data Object Editor
- Hierarchies tab / Using the Data Object Editor
- Data Viewer tab / Using the Data Object Editor
- DSN
- configuring / Creating a SQL Server database connection
- Dynamic Host Configuration Protocol (DHCP)
E
- Effective Date attribute
- Entity-Relationship (ER) diagram
- defining / The POS transactional source database
- about / The POS transactional source database
- ETL
- about / ETL
- manual processes / Manual ETL processes
- flat files, importing / Manual ETL processes
- ETL mapping
- building / Designing and building an ETL mapping
- designing / Designing our mapping
- creating / Creating a mapping
- ETL mapping, building
- staging area, designing / Designing our staging area
- ETL mapping, creating
- sources tables, adding / Adding source tables
- table, adding / Adding source tables
- operator, adding / Adding source tables
- operators, organizing / Adding source tables
- window, resizing / Adding source tables
- windows, zooming / Adding source tables
- target table, creating / Adding a target table
- source to data connection / Connecting source to target
- ETL mapping, designing
- about / Designing and building an ETL mapping
- Mapping Editor / Review of the Mapping Editor
- Mapping Editor, properties / Adding source tables
- Mapping Editor, operator properties displayed / Adding source tables
- execution process
- about / Executing
- STAGE_MAP mapping, executing / Executing
- code, dealing with / Executing
- input parameters / Executing
- runtime parameters / Executing
- Job Details dialog box / Executing
- of remaining objects / Deploying and executing remaining objects
- mapping order / Execution order
- objects, executing / Execution order
- Expiration Date attribute
- Expression Builder
- about / Defining operator properties for the Joiner
- expression, writing / Defining operator properties for the Joiner
- bracket matching feature / Mapping an Expression operator
- external table
F
- foreign key
- FTP (File Transfer Protocol)
G
- generation process
- in Design Centre / Generating in the Design Center
- in Design Centre, options / Generating in the Design Center
- PL/SQL Package / Generating in the Design Center
- in editors / Generating from the editors, Generating in the Data Object Editor, Generating in the Mapping Editor, Default operating mode of the mapping, Selecting the generation style
- in Data Object Editor / Generating in the Data Object Editor
- in Mapping Editor / Generating in the Mapping Editor
- generation process, in Mapping Editor
- about / Generating in the Mapping Editor
- default operating mode / Generating in the Mapping Editor
- default operating mode, mapping / Default operating mode of the mapping
- default operating mode, set-based mode / Default operating mode of the mapping
- default operating mode, row-based mode / Default operating mode of the mapping
- default operating mode, row-based (target only) mode / Default operating mode of the mapping
- default operating mode, additional options / Default operating mode of the mapping
- Full generation style / Selecting the generation style
- intermediate generation style / Selecting the generation style
- Grid Control
- about / Creating the database
H
- Host Name
K
- key, retrieving
- about / Retrieving the key to use for a Lookup Operator
- SUBSTR Transformation Operator, adding / Adding a SUBSTR Transformation Operator
- operators, maximizing / Adding a SUBSTR Transformation Operator
- Constant operator, adding / Adding a Constant operator
- groups, adding to Constant operator / Adding a Constant operator
- output attributes, adding to Constant operator / Adding a Constant operator
- input attributes, adding to Constant operator / Adding a Constant operator
- attributes, adding to Constant operator / Adding a Constant operator
- Constant operator, data type / Adding a Constant operator
- Constant operator, POSITION attribute / Adding a Constant operator
- Constant operator, LENGTH attribute / Adding a Constant operator
- TO_NUMBER transformation function, adding / Adding a TO_NUMBER transformation
- Key Lookup operator, STORE mapping
- using / Using a Key Lookup operator
- external table, creating / Creating an external table
- lookup table, creating / Creating and loading a lookup table
- lookup table, loading / Creating and loading a lookup table
- groups, mapping / Creating and loading a lookup table
- binding, steps / Creating and loading a lookup table
- table verification / Creating and loading a lookup table
- primary key, adding to table / Creating and loading a lookup table
- key, retrieving / Retrieving the key to use for a Lookup Operator
- adding / Adding a Key Lookup operator
- adding, steps / Adding a Key Lookup operator
M
- mapping
- about / Mappings and operators in OWB
- creating / Mappings and operators in OWB
- node / Mappings and operators in OWB
- Time Dimension Wizard / Mappings and operators in OWB
- Mapping Editor / Mappings and operators in OWB
- Mapping Editor, mapping window / Mappings and operators in OWB
- canvas / Mappings and operators in OWB
- Mapping Editor, explorer window / Mappings and operators in OWB
- properties window / Mappings and operators in OWB
- Mapping Editor, palette window / Mappings and operators in OWB
- Mapping Editor, Bird 's Eye Viewwindow / Mappings and operators in OWB
- Mapping Editor
- reviewing / Review of the Mapping Editor
- validation process / Validating in the Mapping Editor
- metadata
- module, source metadata
- about / Creating a module
- Oracle Database module, creating / Creating an Oracle Database module
- SQL Server database module, creating / Creating a SQL Server database module
- MS SQL Database
- uppercase issues / Adding Transformation Operators
- lowercase issues / Adding Transformation Operators
N
- named instance
- normalization
O
- Object Details window, Control Center Service
- object / The Object Details window
- design status / The Object Details window
- deploy action / The Object Details window
- deployed / The Object Details window
- deploy status / The Object Details window
- location / The Object Details window
- module / The Object Details window
- create option / The Object Details window
- drop option / The Object Details window
- update option / The Object Details window
- Default Actions button / The Object Details window
- Reset Actions button / The Object Details window
- ODBC
- OLAP
- OLE-DB
- operator
- about / Mappings and operators in OWB
- canvas layout / The canvas layout
- joiner operator / The canvas layout
- OWB operators / OWB operators
- Optimal Flexible Architecture (OFA)
- Oracle-Managed Files option
- about / Creating the database
- Oracle database
- SQL*Loader / Manual ETL processes
- Very Large Databases (VLDB) / Building the staging area table with the Data Object Editor
- Oracle Database module, creating
- module, naming / Creating an Oracle Database module
- connection name, setting / Creating an Oracle Database module
- connection details, setting / Creating an Oracle Database module
- connection, testing / Creating an Oracle Database module
- errors, handling / Creating an Oracle Database module
- created module, verifying / Creating a SQL Server database module
- Oracle Universal Installer
- OWB
- dimensions, creating / Creating dimensions in OWB
- cube, creating / Creating a cube in OWB
- cube, designing with wizard / Creating a cube with the wizard, Using the Data Object Editor
- mapping / Mappings and operators in OWB
- operators / Mappings and operators in OWB
- features / Features and benefits of OWB
- benefits / Features and benefits of OWB
- ROLAP option / Features and benefits of OWB
- OWB, components
- Design Center / OWB components and architecture
- Repository Browser / OWB components and architecture
- sever components, Target Schema / OWB components and architecture
- sever components, Repository / OWB components and architecture
- sever components, Control Center Service / OWB components and architecture
- Control Center Manager, using / OWB components and architecture
- sever components, workspaces / OWB components and architecture
- OWB dimensions, creating
- requirements / Creating dimensions in OWB
- Time dimension / The Time dimension
- Product dimension / The Product dimension
- Store dimension / The Store dimension
- OWB operator
- source and target operators / OWB operators, Source and target operators
- data flow operator / OWB operators, Data flow operators
- pre/post processing operators / OWB operators, Pre/post-processing operators
- about / OWB operators
P
- Port Number
- POS (Point-of-Sale ) system
- about / ACME Toys and Gizmos source data
- pre/post processing operators, OWB operator
- mapping input parameter / Pre/post-processing operators
- mapping output parameter / Pre/post-processing operators
- post-mapping process / Pre/post-processing operators
- pre-mapping parameter / Pre/post-processing operators
- precision
- preliminary analysis
- use / Preliminary analysis
- ACME toys / ACME Toys and Gizmos source data
- gizmos source data / ACME Toys and Gizmos source data
- POS Transactional database / The POS transactional source database
- POS Transactional database, elements / The POS transactional source database
- POS Transactional database, attributes / The POS transactional source database
- POS Transactional database, join query / The POS transactional source database
- site order management database / The web site order management database
- site order management database, elements / The web site order management database
- site order management database, issues / The web site order management database
- primary key
- PRODUCT, mapping
- about / PRODUCT mapping
- data element, issues / PRODUCT mapping
- BRAND level / PRODUCT mapping
- CATEGORY level / PRODUCT mapping
- DEPARTMENT level / PRODUCT mapping
- changes, saving / PRODUCT mapping
- Product dimension, OWB dimensions
- attribute type / Product Attributes (attribute type)
- product level / Product Levels
- product hierarchy / Product Hierarchy (highest to lowest)
- creating, New Dimension Wizard used / Creating the Product dimension with the New Dimension Wizard
- PROGRAM
- naming / Editing the listener.ora file
S
- SALES cube, mapping
- about / SALES cube mapping
- dimension attributes / Dimension attributes in the cube
- dimension attributes, naming convention / Dimension attributes in the cube
- dimension attributes, editing / Dimension attributes in the cube
- dimension attributes, Data Object Editor window / Dimension attributes in the cube
- naming convension, DATE_DIM_DAY_CODE / Dimension attributes in the cube
- measure attribute / Measures and other attributes in the cube
- ACTIVE_DATE attribute / Measures and other attributes in the cube
- values, mapping to cube / Mapping values to cube attributes
- measures values, mapping to cube / Mapping measures' values to a cube
- PRODUCT values, mapping to cube / Mapping PRODUCT and STORE dimension values to the cube
- STORE values, mapping to cube / Mapping PRODUCT and STORE dimension values to the cube
- DATE_DIM values, mapping to cube / Mapping DATE_DIM values to the cube
- mapping, validating / Mapping DATE_DIM values to the cube
- link, deleting / Mapping DATE_DIM values to the cube
- Expression operator, mapping / Mapping an Expression operator
- scale of numbers
- SCD
- Server versus workstation
- SID (System Identifier)
- about / Creating the database
- SKU
- about / The Product dimension
- snowflake schema
- source and target operators, OWB operator
- cube operator / Source and target operators
- dimension operator / Source and target operators
- external table operator / Source and target operators
- table operator / Source and target operators
- constant / Source and target operators
- view operator / Source and target operators
- sequence operator / Source and target operators
- construct object / Source and target operators
- source metadata, defining
- about / Importing/defining source metadata
- project, creating / Creating a project
- module, creating / Creating a module
- manually, with Data Object Editor / Defining source metadata manually with the Data Object Editor
- source metadata, importing
- Data Object Editor / Importing source metadata from a database
- objects, selecting / Importing source metadata from a database
- Import results screen / Importing source metadata from a database
- Save button / Importing source metadata from a database
- MDL file / Importing source metadata from a database
- Undo button / Importing source metadata from a database
- OK button / Importing source metadata from a database
- from flat files / Importing source metadata from files
- module, creating / Importing source metadata from files
- module details, editing / Importing source metadata from files
- Aggregator operator and table, connecting / Adding an Aggregator operator
- source tables, STORE mapping
- target data, elements / Adding source and target operators
- region level, attributes / Adding source and target operators
- country level, attributes / Adding source and target operators
- data, populating in STORE dimension / Adding source and target operators
- attributes, connecting together / Adding source and target operators
- issues, dealing with / Adding source and target operators
- source to data connection, ETL mapping
- granularity / Connecting source to target
- Data Flow operators, using / Connecting source to target
- Joiner operator / Connecting source to target
- Aggregator operator / Connecting source to target
- Joiner operator, adding / Connecting source to target
- Joiner operator, attribute groups / Joiner operator attribute groups
- operator type, identifying / Joiner operator attribute groups
- Joiner operator attribute groups, configuring / Joiner operator attribute groups
- Joiner operator attribute groups, renaming / Joiner operator attribute groups
- operators, connecting to Joiner / Connecting operators to the Joiner
- Joiner operator properties, defining / Defining operator properties for the Joiner
- Aggregator operator, adding / Adding an Aggregator operator
- SQL*Loader
- about / Manual ETL processes
- SQL Server
- column name sensitivity / Defining source metadata manually with the Data Object Editor
- SQL Server database module, creating
- Oracle Heterogeneous Services used / Creating a SQL Server database module
- agent / Creating a SQL Server database module
- agent, transparent gateway agent / Creating a SQL Server database module
- agent, generic connectivity agent / Creating a SQL Server database module
- agent, differences / Creating a SQL Server database module
- database connection, creating / Creating a SQL Server database connection
- Oracle, configuring / Configure Oracle to connect to SQL Server
- heterogeneous service configuration file, creating / Creating a heterogeneous service configuration file
- listener.ora file, editing / Editing the listener.ora file
- ODBC module, creating in Warehouse Builder / Creating the Warehouse Builder ODBC module for SQL Server
- staging
- about / Staging
- area usage, considerations / To stage or not to stage
- disadvantages / To stage or not to stage
- advantages / To stage or not to stage
- area, configuring / Configuration of a staging area
- staging area, ETL mapping
- designing / Designing our staging area
- content, designing / Designing the staging area contents
- dimensional objects / Designing the staging area contents
- table, building with Data Object Editor / Building the staging area table with the Data Object Editor
- staging area table, ETL mapping
- building, Data Object Editor used / Building the staging area table with the Data Object Editor
- creating, steps / Building the staging area table with the Data Object Editor
- naming / Building the staging area table with the Data Object Editor
- Data Object Editor used, name tab / Building the staging area table with the Data Object Editor
- Data Object Editor used, columns tab / Building the staging area table with the Data Object Editor
- columns, adding to / Building the staging area table with the Data Object Editor
- column name, precautions / Building the staging area table with the Data Object Editor
- POS Transaction database / Building the staging area table with the Data Object Editor
- data, aggregating / Building the staging area table with the Data Object Editor
- columns, creating / Building the staging area table with the Data Object Editor
- saving / Building the staging area table with the Data Object Editor
- constraints tab / Building the staging area table with the Data Object Editor
- constraint, check / Building the staging area table with the Data Object Editor
- constraints, foreign key / Building the staging area table with the Data Object Editor
- constraints, primay key / Building the staging area table with the Data Object Editor
- constraints, unique key / Building the staging area table with the Data Object Editor
- Data Object Editor used, indexes tab / Building the staging area table with the Data Object Editor
- Data Object Editor used, partition tab / Building the staging area table with the Data Object Editor
- Data Object Editor used, attribute sets tab / Building the staging area table with the Data Object Editor
- Data Object Editor used, data rule tab / Building the staging area table with the Data Object Editor
- Data Object Editor used, Data Viewser tab / Building the staging area table with the Data Object Editor
- STORE, mapping
- new map, creating / STORE mapping
- about / STORE mapping
- source tables, adding / Adding source and target operators
- Transformation Operator, adding / Adding Transformation Operators
- Key Lookup operator, using / Using a Key Lookup operator
- Store dimension, OWB dimensions
- Store attributes / Store Attributes (attribute type), data type and size, and (Identifier)
- identifier / Store Attributes (attribute type), data type and size, and (Identifier)
- data size / Store Attributes (attribute type), data type and size, and (Identifier)
- data type / Store Attributes (attribute type), data type and size, and (Identifier)
- levels / Store Levels
- hierarchy / Store Hierarchy (highest to lowest)
- creating, New Dimension Wizard used / Creating the Store dimension with the New Dimension Wizard
- SUM() function
- about / Adding an Aggregator operator
- Surrogate Identifier
- SYSDATE Oracle function
- SYSDBA
- about / OWB components and architecture
T
- tablespace
- Time dimension, OWB dimensions
- about / The Time dimension
- levels / The Time dimension
- levels, in Warehouse Builder / The Time dimension
- Dimension Attributes / The Time dimension
- Level Attributes / The Time dimension
- Hierarchy / The Time dimension
- creating, Time Dimension Wizard used / Creating a Time dimension with the Time Dimension Wizard
- Transformation Operator, STORE mapping
- adding / Adding Transformation Operators
- Public Transformations / Adding Transformation Operators
- character built-in / Adding Transformation Operators
- upper() function / Adding Transformation Operators
- trim() function / Adding Transformation Operators
- adding, to mapping / Adding Transformation Operators
- function, searching for / Adding Transformation Operators
- TRIM function, attributes / Adding Transformation Operators
- type indicator / Adding Transformation Operators
- dimension attributes / Adding Transformation Operators
- reusing / Adding Transformation Operators
- POS_TRANS_STAGE mapping table, attributes / Adding Transformation Operators
- STORE level attributes / Adding Transformation Operators
- NAME field / Adding Transformation Operators
- business identifier / Adding Transformation Operators
- tips, implementing / Adding Transformation Operators
- Triggering attributes
- trim() function
- about / Adding Transformation Operators
U
- UML (Universal Modeling Language)
- unbound operator
- about / Adding source tables
- upper() function
- about / Adding Transformation Operators
V
- validation bug
- validation process
- purpose / Validating
- in Design Centre / Validating in the Design Center
- in Design Centre, possibilities / Validating in the Design Center
- in editors / Validating from the editors, Validating in the Data Object Editor, Validating in the Mapping Editor
- in Data Object Editor / Validating in the Data Object Editor, Validating in the Mapping Editor
- in Mapping Editor / Validating in the Mapping Editor