Index

A

• ACME data warehouse
  • designing /
  • dimensions, identifying /
  • cube, designing /
• ACME_POS database / The POS transactional source database
• ACME_POS database node / Defining source metadata manually with the Table Editor
• ACME_POS source database /
• ACME_POS SQL Server database / Creating a module
• ACME_WS_ORDERS database / Creating a module
• Add option / Configuring the listener
• Advanced Import Options... button / Importing source database objects from a database
• aggregator /
• aggregator operator
  • adding /
• Aggregator operator window /
• Annotations box /
• Attribute drop-down menu /
• attributes
  • about / The POS transactional source database
• attribute sets tab, table editor /

B

• Bind function /
• birds eye view /
• birds eye view window /
• Business Identifier /

C

• canvas window /
• cardinality
  • about / The POS transactional source database
• change data capture code template /
• check constraint /
• Check Knowledge Module (CKM) /
• code template
  • about /
  • description /
  • types /
  • load code template /
  • integration code template /
  • control code template /
  • change data capture code template /
  • Oracle target code template /
  • function code template /
  • pre-defined code templates /
• code template mapping
  • about /
  • control center agent, starting /
  • template mapping module, defining /
  • mapping, copying /
  • editing /
  • logical view, working in /
  • execution view, working in /
  • execution unit, creating /
  • operator, moving between execution units /
  • executing /
  • deploying /
• code template mappings
  • about /
• Code Template tab /
• compare option, snapshots /
• component palette /
• component palette window /
• Components window /
• composite unique keys /
• configuration window /
• Connection details / An overview of Warehouse Builder Design Center
• constant operator /
• constant operator, lookup operator
  • adding /
• construct object operator /
• Control Center Agent (CCA)
  • about /
  • starting /
• control center jobs window
  • about /
• control center manager
  • about /
  • window, overview /
  • deploying /
• Control Center Manager / OWB components and architecture
• control center service
  • about /
• control code template /
• Convert to Signature option, snapshots /
• copy /
• COUNTRY level /
• COUNTY attribute /
• CSV file / Importing source metadata from files
• cube
  • designing /
  • creating, in OWB /
  • creating, with wizard /
• cube editor
  • name tab /
  • storage tab /
• cube operator /
• cut /

D

• -deduplication /
• database
  • source database objects, importing from / Importing source database objects from a database
• database and OWB, installation
  • Oracle software, downloading / Downloading the Oracle software
  • Optimal Flexible Architecture (OFA) / Installing Oracle database software
  • database software, installng / Installing Oracle database software
  • listener, configuring / Configuring the listener
  • listener, cobfiguring / Configuring the listener
  • default listener port, changing / Configuring the listener
  • database, creating / Creating the database
  • OWB standalone software, installing / Installing the OWB standalone software
  • OWB components / OWB components and architecture
  • workspaces, configuring / Configuring the repository and workspaces
  • repository, configuring / Configuring the repository and workspaces
  • Warehouse Builder Enterprise ETL / Configuring the repository and workspaces
• database and OWB installation
  • hardware systems / A word about hardware and operating systems
  • operating systems / A word about hardware and operating systems
  • Oracle database software, installing / Installing Oracle database software
• Database Configuration Assistant / Creating the database
• database normalization / The POS transactional source database
• Databases modules / Creating a module
• data object center
  • deploying in /
• data object editor
  • navigator windows /
  • canvas /
  • property inspector /
  • configuration /
  • component palette /
  • birds eye view /
  • editor window /
  • no maintenance setting /
  • data viewer /
  • cube editor /
• data object editors
  • using /
• Data Object Editor window /
• data rules / An overview of Warehouse Builder Design Center
• data rules tab, table editor /
• data type and size, store dimension /
• data viewer /
• data warehouse design
  • about /
  • dimensional design /
  • dimensional model, implementing in database /
  • relational implementation (star schema) /
  • multidimensional implementation (OLAP) /
• data warehouse design, in OWB
  • about /
  • target user, creating /
  • module, creating /
  • target module, creating /
  • OWB design objects /
• data warehousing
  • about / Introduction to data warehousing , What is a data warehouse?
• DATE_DIM dimension /
• DATE_DIM mapping /
• DATE_DIM values
  • mapping /
• DATE_DIM_MAP map entry /
• DBA (Database Administrator)
  • about / The POS transactional source database
• de-normalized database structure /
• default operating mode
  • set-based /
  • row-based /
  • row-based (target only) /
• delete option, snapshots /
• deployment order /
• design center
  • object, validating /
  • object, generation /
  • deploying in /
• design center, warehouse builder
  • about / An overview of Warehouse Builder Design Center
  • Logon screen / An overview of Warehouse Builder Design Center
  • Logon dialog box / An overview of Warehouse Builder Design Center
  • User Name / An overview of Warehouse Builder Design Center
  • Connection details / An overview of Warehouse Builder Design Center
  • Password / An overview of Warehouse Builder Design Center
  • Show Details >> button / An overview of Warehouse Builder Design Center
  • Design Center window / An overview of Warehouse Builder Design Center
  • projects tab / An overview of Warehouse Builder Design Center
  • Databases node / An overview of Warehouse Builder Design Center
  • locations tab / An overview of Warehouse Builder Design Center
• Design Center Projects tab / Importing/defining source database object metadata
• Design Center screen
  • about / An overview of Warehouse Builder Design Center
  • projects tab / An overview of Warehouse Builder Design Center
  • locations tab / An overview of Warehouse Builder Design Center
  • globals navigator / An overview of Warehouse Builder Design Center
• Design Center search function /
• Design drop-down menu / Creating a project
• dimensional design
  • about /
  • cube and dimensions /
• dimensional model
  • implementing, in database /
  • relational implementation (star schema) /
  • multidimensional implementation (OLAP) /
• dimension operator /
• dimensions
  • identifying /
  • creating /
  • time dimension /
  • characterisitics /
  • attributes /
  • product dimension /
  • store dimension /
• dimensions, characteristics
  • levels /
  • dimesnion attributes /
  • level attributes /
  • hierarchies /
• downloading
  • Oracle software / Downloading the Oracle software
• DSN (Data Source Name)
  • about / Creating a SQL Server database connection
• Dynamic Host Configuration Protocol (DHCP) / A word about hardware and operating systems

E

• Edit menu entry / Creating a project
• editor window
  • about /
  • name tab /
  • storage tab /
  • attributes tab /
  • levels tab /
  • hierarchies tab /
  • SCD tab /
  • orphan tab /
• effective date attribute /
• Entity-Relationship (ER) diagram
  • about / The POS transactional source database
• ETL (Extract, Transform, and Load)
  • about /
  • manual processes /
• execution order /
• Exit button / Creating the database, Installing the OWB standalone software
• expiration date attribute /
• export option, snapshots /
• expression /
• Expression Builder /
• Expression operator
  • mapping /
• external table / Importing source metadata from files
• external table, lookup operator
  • creating /
• external table operator /
• extract, transform, and load (ETL) / OWB components and architecture

F

• fact table /
• Field Properties screen / Importing source metadata from files
• File Import window / Importing source metadata from files
• Files modules / Creating a module
• filter operator /
• Find button /
• Finish button / Creating the database
• foreign key constraint /
• FTP (File Transfer Protocol) / Importing source metadata from files
• FTP option / Importing source metadata from files
• full snapshot /
• function code template /

G

• generation style
  • selecting /
• Getting Started button / An overview of Warehouse Builder Design Center
• grain /
• graphical navigator /
• Grid Control
  • about / Creating the database

H

• hardware systems
  • about / A word about hardware and operating systems
• heterogeneous service configuration file
  • creating / Creating a heterogeneous service configuration file
• Hide Details << / An overview of Warehouse Builder Design Center
• Host setting /

I

• ID fields /
• indexes tab, table editor /
• Integrated Development Environment (IDE) / An overview of Warehouse Builder Design Center
• integration code template /
• Integration Knowledge Module (IKM) /
• ITEMS table operator /
• ITEM_LIST_PRICE / Defining source metadata manually with the Table Editor

J

• JDBC
  • about /
• JDBC (Java Database Connectivity) / Creating a SQL Server database module
• JDBC database connection
  • used, for connecting to SQL server /
  • JDBC driver, downloading /
  • SQL server module, creating /
• JDBC driver
  • downloading /
• Joiner Editor /
• JOINER operator /
• joiner operator /
• joiner operator attribute groups
  • about /
• join SQL query / The POS transactional source database
• Journalizing Knowledge Module (JKM) /

K

• keys tab, table editor
  • about /
  • check constraint /
  • foreign key constraint /
  • primarty key constraint /
  • unique key constraint /

L

• listener
  • configuring / Configuring the listener
• listener.ora file
  • editing / Editing the listener.ora file
• load code template /
• Loading Knowledge Module (LKM) /
• Loading Type property /
• locations tab / An overview of Warehouse Builder Design Center
• Logon dialog box / An overview of Warehouse Builder Design Center
• Logon screen / An overview of Warehouse Builder Design Center
• lookup operator /
  • using /
  • key, retrieving for /
  • adding /
• lookup table
  • creating /
  • loading /

M

• mapping
  • creating /
  • source tables, adding /
  • target table, adding /
  • source, connecting to target /
  • joiner operator attribute groups /
  • operators, connecting to joiner /
  • operator properties, defining for joiner /
  • aggregator operator, adding /
• mapping editor
  • review /
  • canvas /
  • structure window /
  • properties inspector window /
  • component palette /
  • toolbar icon used, for object validation /
  • icon, used for object generation /
• Mapping Editor window /
• Mapping Input Parameter operator /
• mappings, OWB
  • about /
  • mapping window /
  • structure view /
  • property inspector /
  • component palette /
  • canvas layout /
  • Mapping Input Parameter operator /
• mappings window /
• metadata
  • importing /
• Metadata change management
  • about /
  • Metadata Loader (MDL) imports /
  • Metadata Loader (MDL) exports /
  • recycle bin /
  • copy /
  • cut /
  • paste /
  • snapshots /
• Metadata Import Result Report log file / Importing source database objects from a database
• Metadata Loader (MDL) /
• Metadata Loader log file /
• module
  • creating / Creating a module
  • SQL Server database module, creating / Creating a SQL Server database module
• multidimensional implementation (OLAP) /

N

• Name dimension attribute /
• navigator windows /
• New... / Creating a project
• New Gallery window /
• New menu option /
• New option /
• Next button / Creating the database, Importing source metadata from files,
• Non-Oracle modules / Creating a module
• normalization / The POS transactional source database
• number data type / Defining source metadata manually with the Table Editor

O

• object, deploying
  • about /
  • control center service /
  • in design center /
  • data object editor /
  • control center manager /
  • control center manager window, overview /
  • object details window /
  • control center jobs window /
  • in control center manager /
  • deployment order /
• object, execution
  • about /
  • execution order /
• object, generation
  • about /
  • in design center /
  • icon from mapping editor used /
  • mapping, default operating mode of /
  • generation style, selecting /
• object, validation
  • about /
  • in design center /
  • Validate... entry /
  • POS_TRANS_STAGE table /
  • Results tab /
  • Design Center toolbar /
  • toolbar icon in mapping editor, used /
• object details window
  • about /
• objects
  • pasting /
  • copying /
  • cutting /
• objects, synchronizing
  • about /
  • table updates /
  • object definitions, updating /
  • tables, changes /
  • outbound /
  • inbound /
  • strategy, matching /
  • plan, viewing /
  • dimensional objects, changes /
• objects.source database objects / Importing source database objects from a database
• ODBC (Open Database Connectivity) / Creating a SQL Server database module
• ODBC connection
  • about / Creating a SQL Server database connection
• OK button / Creating the database,
• OLAP (online analytic or analytical processing) /
• OLE-DB (Object Linking and Embedding-Database)
  • about / Creating a SQL Server database module
• operating systems
  • about / A word about hardware and operating systems
• operator properties
  • defining, for joiner /
• operators /
  • connecting, to joiner /
• operators, OWB
  • about /
  • source operators /
  • target operators /
  • cube operator /
  • dimension operator /
  • external table operator /
  • table operator /
  • constant operator /
  • view operator /
  • sequence operator /
  • construct object operator /
  • transformations (data flow operators) /
• Optimal Flexible Architecture (OFA)
  • about / Installing Oracle database software
• Oracle, configuring
  • heterogeneous service configuration file, creating / Creating a heterogeneous service configuration file
  • listener.ora file, editing / Editing the listener.ora file
• Oracle-Managed Files option / Creating the database
• Oracle Business Intelligence Enterprise or Standard Edition (OBIEE) /
• Oracle Database Enterprise Edition /
• Oracle Database Installation Guide
  • URL / Installing Oracle database software
• Oracle Database module
  • creating / Creating an Oracle Database module
• Oracle database software
  • installing / Installing Oracle database software
• Oracle DATE data type /
• Oracle Heterogeneous Services / Creating a SQL Server database module
• Oracle software
  • downloading / Downloading the Oracle software
• Oracle System Identifier / Creating the database
• Oracle target code template /
• Oracle Technology Network website
  • URL / Downloading the Oracle software
• Oracle Universal Installer
  • about / Installing Oracle database software
• Orphan Management policies
  • URL /
• OWB
  • installation / Installation of the database and OWB
  • project, creating / Creating a project
  • module, creating / Creating a module
  • Oracle Database module, creating / Creating an Oracle Database module
  • SQL Server database module, creating / Creating a SQL Server database module
  • data warehouse design /
  • dimensions, creating /
  • cube, creating /
  • mappings /
  • operators /
  • source operators /
  • target operators /
  • features /
  • benefits /
  • snapshots /
  • recycle bin /
• OWB components
  • Design Center / OWB components and architecture
  • Control Center Manager / OWB components and architecture
  • Repository Browser / OWB components and architecture
  • Control Center Service, server components / OWB components and architecture
  • Target Schema, server components / OWB components and architecture
• OWB design objects
  • about /
• OWB standalone software
  • installing / Installing the OWB standalone software
• OWBSYS schema / Creating the database
• OWBSYS_AUDIT schema / Creating the database
• OWB_USER role / Configuring the repository and workspaces

P

• partitions tab, table editor /
• Password / An overview of Warehouse Builder Design Center
• paste /
• pivot operator /
• Point-of-Sale (POS system)
  • about / ACME Toys and Gizmos source data
• POS transactional source database
  • about / The POS transactional source database
• POS_TRANSACTIONS /
• POS_Transactions table / The POS transactional source database
• POS_TRANS_STAGE mapping table /
• POS_TRANS_STAGE staging table /
• POS_TRANS_STAGE table /
• POS_TRANS_STAGE table operator /
• pre-defined code templates
  • about /
• preliminary analysis
  • about / Preliminary analysis
  • issues / Preliminary analysis
  • ACME Toys / ACME Toys and Gizmos source data
  • Gizmos source data / ACME Toys and Gizmos source data
  • POS transactional source database / The POS transactional source database
  • website order management database / The website order management database
• primarty key constraint /
• PRODUCT attribute /
• product attributes (attribute type), product dimension
  • about /
• product dimension /
  • about /
  • product attributes (attribute type) /
  • product levels /
  • product hierarchy (highest to lowest) /
  • creating, with new dimension wizard /
• PRODUCT dimension /
• product hierarchy (highest to lowest), product dimension
  • about /
• product levels, product dimension
  • about /
• PRODUCT mapping
  • about /
  • PRODUCT_NAME to NAME /
  • PRODUCT_NAME to DESCRIPTION /
  • PRODUCT_SKU to SK /
  • PRODUCT_PRICE to LIST_PRICE /
  • PRODUCT_BRAND to BRAND_NAME /
  • PRODUCT_BRAND to NAME (in the BRAND level) /
  • PRODUCT_BRAND to DESCRIPTION (in the BRAND level) /
  • PRODUCT_CATEGORY to CATEGORY_NAME /
  • PRODUCT_CATEGORY to NAME (in the CATEGORY level) /
  • PRODUCT_CATEGORY to DESCRIPTION (in the CATEGORY group) /
  • PRODUCT_DEPARTMENT to DEPARTMENT_NAME /
  • PRODUCT_DEPARTMENT to NAME (in the DEPARTMENT level) /
  • PRODUCT_DEPARTMENT to DESCRIPTION (in the DEPARTMENT level) /
• PRODUCT_BRAND to DESCRIPTION (in the BRAND level) /
• PRODUCT_BRAND to NAME (in the BRAND level) /
• PRODUCT_CATEGORY to CATEGORY_NAME /
• PRODUCT_CATEGORY to DESCRIPTION (in the CATEGORY group) /
• PRODUCT_CATEGORY to NAME (in the CATEGORY level) /
• PRODUCT_DEPARTMENT to DEPARTMENT_NAME /
• PRODUCT_DEPARTMENT to DESCRIPTION (in the DEPARTMENT level) /
• PRODUCT_DEPARTMENT to NAME (in the DEPARTMENT level) /
• PRODUCT_NAME attribute /
• PRODUCT_NAME to DESCRIPTION /
• PRODUCT_NAME to NAME /
• PRODUCT_SKU /
• PRODUCT_SKU attribute /
• PRODUCT_SKU to SK /
• PROGRAM name / Editing the listener.ora file
• project
  • creating / Creating a project
• projects tab / An overview of Warehouse Builder Design Center
• Projects window /
• Properties Inspector window /
• property inspector window /
• Property Inspector window /

Q

• quantity attribute / The POS transactional source database

R

• recycle bin
  • about /
  • launching /
  • Empty Recycle Bin button /
  • OK button /
• REGION level /
• REGISTER attribute /
• REGISTERS_KEY attribute /
• relational implementation (star schema) /
• restore option, snapshots /
• ROLAP option /
• row-based (target-only), default operating mode /
• row-based, default operating mode /

S

• SALES cube /
• SALES cube mapping
  • about /
  • dimension attributes, in cubes /
  • dimension attributes, renaming /
  • DATE_DIM dimension /
  • attributes, in cube /
  • measures, in cube /
  • cube attributes, values mapping to /
  • measures values, mapping to cube /
• SALES_AMOUNT attribute /
• SALES_QUANTITY attribute /
• SALE_QUANTITY /
• Save button /
• sequence operator /
• server
  • versus workstation / A word about hardware and operating systems
• set-based, default operating mode /
• set operation /
• Show Details >> / An overview of Warehouse Builder Design Center
• SID_DESC entry / Editing the listener.ora file
• SID_LIST_LISTENER entry / Editing the listener.ora file
• signature snapshot /
• Slowly Changing Dimension (SCD) type /
• Slowly Changing Dimensions (SCD) /
• slowly changing dimension type /
• snapshots
  • about /
  • full snapshot /
  • signature snapshot /
  • Components window /
  • restore /
  • delete /
  • Convert to Signature /
  • export /
  • compare /
• snowflake schema /
• source and target operators, OWB operator
  • sequence operator /
• Source Connections tab /
• source database object metadata
  • importing / Importing/defining source database object metadata
  • defining / Importing/defining source database object metadata
  • Design Center Projects tab / Importing/defining source database object metadata
  • importing, from database / Importing source database objects from a database
  • defining manually, with table editor / Defining source metadata manually with the Table Editor
  • importing, from files / Importing source metadata from files
• source database objects
  • importing, from database / Importing source database objects from a database
• source metadata
  • defining manually, with table editor / Defining source metadata manually with the Table Editor
  • importing, from files / Importing source metadata from files
  • File Import screens / Importing source metadata from files
  • Flat File Sample Wizard / Importing source metadata from files
  • Next button / Importing source metadata from files
  • Advanced option steps / Importing source metadata from files
• source operator
  • adding /
• source tables, mapping
  • adding /
  • adding, projects navigator window used /
  • adding, palette window used /
  • Design Center search function /
  • Find button /
  • POS_TRANSACTIONS /
  • Properties Inspector window /
  • operators /
  • ITEMS table operator /
  • mapping editor window /
• source to target connection, mapping
  • about /
  • joiner operator attribute groups /
  • operators, connecting to joiner /
  • operator properties, defining for joiner /
  • aggregator operator, adding /
• sProjects tab window / Importing source database objects from a database
• SQL (Structured Query Language) / Installing the OWB standalone software
• SQL*Loader /
• SQL*Loader utility / Importing source metadata from files
• SQL Data Definition Language (or DDL) /
• SQL server connection, JDBC database connection used
  • about /
  • JDBC driver, downloading /
  • SQL server module, creating /
  • SQL server TCP/IP port, configuring /
  • metadata, importing /
• SQL Server database connection
  • creating / Creating a SQL Server database connection
  • DSN configuring, steps / Creating a SQL Server database connection
• SQL Server database module
  • creating / Creating a SQL Server database module
  • other database platforms, creating / Creating a SQL Server database module
  • SQL Server database connection, creating / Creating a SQL Server database connection
  • Oracle configuring, for SQL Server connection / Configuring 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
  • Warehouse Builder ODBC module, creating for SQL server / Creating the Warehouse Builder ODBC module for SQL Server
• SQL server module
  • creating /
  • SQL server TCP/IP port, configuring /
  • metadata, importing /
• SQL server TCP/IP port
  • configuring /
• SQL_SERVER_JDBC module /
• STAGE_MAP mapping /
• staging
  • about /
  • area, configuration /
• staging area
  • designing /
  • contents, designing /
  • table building, table editor used /
• star schema /
• Stock Keeping Unit (SKU) /
• STORE attribute /
• store attributes (attribute type), store dimension /
• store dimension /
  • store attributes (attribute type) /
  • data type and size /
  • store levels /
  • store hierarchy (highest to lowest) /
  • creating, with new dimension wizard /
• STORE dimension /
• STORE group /
• store hierarchy (highest to lowest), store dimension /
• STORE level /
• store levels, store dimension /
• STORE mapping
  • about /
  • target operators, adding /
  • source operators, adding /
  • transformation operators, adding /
  • uppercase, issues /
  • lowercase, issues /
  • UPPER() function /
  • UPPER transformation /
  • NAME attributes /
  • TRIM operators /
  • TRIM output /
  • STORE_REGION attributes /
  • STORE_COUNTRY attributes /
  • REGION_NAME attribute /
  • COUNTY attribute /
  • lookup operator, using /
  • external table, creating /
  • lookup table, loading /
  • lookup table, creating /
  • lookup operator, key retrieving for /
  • SUBSTR transformation operator, adding /
  • constant operator, adding /
  • TO_NUMBER transformation, adding /
  • lookup operator, adding /
  /
• STORE_ADDRESS1, ADDRESS2, CITY, STATE, and ZIP_POSTALCODE /
• STORE_COUNTRY column /
• STORE_MAP /
• STORE_NAME, STORE_NUMBER /
• STORE_NAME field /
• STORE_REGION /
• structure view /
• structure window /
• SUBSTR transformation operator, lookup operator
  • adding /
• Surrogate Identifier /
• SYSDATE Oracle function /
• SYSDBA
  • about / OWB components and architecture

T

• table editor
  • source metadata, defining manually / Defining source metadata manually with the Table Editor
  • used, for building staging area table /
  • keys tab /
  • indexes tab /
  • partitions tab /
  • attribute sets tab /
  • data rules tab /
• table editor tool / Defining source metadata manually with the Table Editor
• table operator /
• tablespace
  • about / Configuring the repository and workspaces
• target module
  • creating /
• target operator
  • adding /
• Target Schema / OWB components and architecture
• target table, mapping
  • adding /
• target user
  • creating /
• template mapping module
  • defining /
• template mappings
  • about /
• Test Connection button / Creating an Oracle Database module
• time dimension /
  • about /
  • creating, time dimension wizard used /
• time dimension wizard
  • used, for creating time dimension /
• toolbar icon
  • in mapping editor, used for validating /
• TO_NUMBER transformation, lookup operator
  • adding /
• transactional database
  • about / The POS transactional source database
• transformation / An overview of Warehouse Builder Design Center
• transformation operators
  • about /
  • adding /
  • TRIM() function /
  • TRIM function /
  • VALUE output attribute /
  • STORE dimension /
  • UPPER transformation /
  • UPPER() function /
  • TRIM operator /
  • NAME attribute /
  • STORE dimension operator /
  • POS_TRANS_STAGE mapping table /
  • POS_TRANS_STAGE mapping table operator /
  • STORE_NUMBER attribute /
  • TRIM operators /
  • TRIM output /
• transformations (data flow operators)
  • about /
  • aggregator /
  • deduplication /
  • expression /
  • filter /
  • joiner /
  • lookup /
  • pivot /
  • set operation /
  • splitter operator /
  • transformation operator /
• triggering attributes /
• TRIM operator /
• TRUNC() function /
• trunc() function /

U

• UML (Universal Modeling Language) notation
  • about / The POS transactional source database
• unique key constraint /
• UPPER operators /
• UPPER transformation /
• Use Above Values button /
• User Name / An overview of Warehouse Builder Design Center

V

• values, mapping to code attributes
  • about /
• varchar type / Defining source metadata manually with the Table Editor
• Vendors / The POS transactional source database
• Very Large Databases (VLDB) /
• view operator /

W

• Warehouse builder
  • online resources /
• Warehouse Builder Enterprise ETL / Configuring the repository and workspaces
• Warehouse Builder ODBC module
  • creating, for SQL server / Creating the Warehouse Builder ODBC module for SQL Server
• website order management database
  • about / The website order management database
• Welcome screen / Creating an Oracle Database module
• Workspace Management button / An overview of Warehouse Builder Design Center
• workstation
  • versus server / A word about hardware and operating systems