Skip Headers
Oracle® Warehouse Builder Concepts
11g Release 2 (11.2)

Part Number E10581-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X 

A

Access, 4.3
access online help, 3.3.1
access to an OWB workspace, 2.2.1
ACCESS_PUBLICVIEW_BROWSER system privilege, 3.8
accessing and moving data, 4
accounts
OWBSYS and OWBSYS_AUDIT, 2.2
activity details
viewing for process flows, 3.8
activity types, 1.2.7
ADMINISTRATOR, 7.1.1
administrator usability, 1.2.5
advanced find, 1.3.1
ALL_OLAP2_AW views, 5.2.2.5
analytic MOLAP, 5.2.1
application
adaptors, 4.1
sources, ERP, 4.1
ASCII files, 4.4
attribute analysis, 8.6.1
attribute values for multiple configurations, 1.3.22
attributes
dimension attributes, 5.3.2.1
level attributes, 5.3.2.3
Auto Mapping dialog box, 1.3.26
automated corrections, 8.7
automated data cleansing, 8.7
automatic layout, 3.6
automation features, 10

B

basic metadata, 4.1
batch operations, 3.3.3
binary formats, 4.4, Glossary
Bird's Eye View, 7.5.1
browser listener, 3.3.1
Business Area Editor, B.2
business identifier, 5.3.2.2.2
business intelligence enhancements, 1.2.3
Business Intelligence node, 5.1
business names
business name mode, A.1.11.1
maximum length, A.1.11.1
requirements, A.1.11.1
syntax for business object names, A.1.11.1, A.1.11.1, A.1.11.1

C

Canvas, 3.6.1, 7.5.1
change management, 7.5
Change Manager, 3.3.1
character set, 4.4
check for updates, 2.4.1
chunking, 1.3.28
classes
Design Center, 3.3
Clipboard, 3.3.1
COBOL Copybooks, 1.3.21
code generation in mappings, 6.2
Code Template mappings, 1.3.4
Code Templates, 4.5
Code Templates (CT mappings), 6.2
collections, 3.2.3
deleting shortcuts in, 3.2.3
comma-separated, 4.4, Glossary
comments in operators, 1.3.24
complex transformation, 4.4.1
conditional operations, 3.3.3
configuration drop-down box, 1.3.6
configuration templates, 1.3.22
configuring groups of objects, 1.3.22
Connection Navigator, 4.2.1
connectivity
ODBC, 4.6
OLE DB drivers for heterogeneous data sources, 4.6
connectivity agent, 4.6, 4.6
connectors, 4.1
about, 4.2.1
Connectors Navigator of Locations, 3.5.2.1
CONSTRUCT, 1.3.20
context-sensitive help, 2.4
Control Center Agent, 1.3.18, 1.3.18
Control Center Manager, 3.4
copy and paste, 1.3.5
copying and moving metadata, 7.2
correction mappings, 8.7
correlated joins, 1.3.20
Create Business Area Wizard, B.2
Create Dimension Wizard, 5.2.2.1
Create Flat File Wizard, 4.4
credentials, 4.2.1
CRM, 4.1, 4.3
cube Data Viewer, 5.1.2
Cube Editor, B.2
cube-organized materialized views, 1.3.3
cubes, 5.6
default aggregation method, 5.6.1.2
dimensionality, 5.6.1.2
measures, 5.6.1.1
MOLAP implementation, 5.6.2.2
relational implementation, 5.6.2.1
ROLAP implementation, 5.6.2.1
solve dependency order, 5.6.3
current software release
version information, 2.4.1
current workspace session, 2.4.1
custom metadata stores, 4.1

D

data auditors, 8.4
data cleansing
automated, 8.7
data correction, 8.7.1.1
data correction, automatic, 8.7.1
data flow, 6.2
data matching, 8.8
Data Object Editor
components, 5.1.1
data object editors, 5.1.1
data objects
dimensional objects, implementing, 5.2.2.2
data profiling
about, 8.2
features in OWB, 8.5
types, 8.6
types, attribute analysis, 8.6.1
types, functional dependency, 8.6.2
types, referential analysis, 8.6.3
data quality
ensuring, 8.1
lifecycle, 8.1.1
management, 8.1
data rules
about, 8.3
custom profiling and, 8.6.4
data sources
Oracle Transparent Gateways, 4.6
Data transformation, 6.1
data type analysis, 8.6.1
Data Viewer, 3.3.1, 5.1.2
data viewer area, 3.6.1.8
database connector, 4.2.1
database dictionary and metadata, 4.1
DB2, 4.3
Debug Toolbar, 3.6.1.6
default naming mode, A.1.11.1
default project, 3.2
Dependency Manager, 1.3.16
deploying
about, 9.1.1
deployment status, 9.1.1.1
deploying a mapping, 9.1.1
deploying a process flow, 9.1.1
deployment, 4.7
deployment information
viewing to manage target environments, 3.8
Deployment Option configuration property, 5.2.2.2
Design Center, 1.3.23, 3.3, 3.6.1
classes not found, 3.3
Design menu, 3.3.1
Edit menu, 3.3.1
galleries, 3.3
menus, 3.3.1
toolbar, 3.3.2
Tools menu, 3.3.1
View menu, 3.3.1
Design Center, starting, 2.2.1
design decisions with OWB wizards, 3.7
design environment for Experts, 10.2.1
Design menu, 3.3.1
developer usability, 1.2.4
Diagram Toolbar, 3.6.1.6
differences between external tables and SQL*Loader, 4.4.2
dimension Data Viewer, 5.1.2
Dimension Editor, 5.2.2.1, B.2
dimension loading, 5.2.2.4
dimensional objects, 5.2
deployment options, 5.2.2.3
implementing, 5.2.2.2
dimensions
about, 5.3
business identifier, 5.3.2.2.2
control rows, 5.3.2.7
dimension attributes, 5.3.2.1
dimension roles, 5.3.2.5
hierarchies, 5.3.2.4
implementing, 5.3.3
level attributes, 5.3.2.3
level relationships, 5.3.2.6
levels, 5.3.2.2
orphan management policy, 5.2.2.6
parent identifier, 5.3.2.2.3
rules, 5.3.1
snowflake schema implementation, 5.3.3.2
star schema implementation, 5.3.3.1
surrogate identifier, 5.3.2.2.1
time dimensions, about, 5.5
value-based hierarchies, 5.3.2.8
dimensions and cubes, 5.2
display options for editors, 3.6.1.7
displaying Clipboard contents, 3.3.1
displaying generated scripts, 3.6.1.9
displaying preferences, 3.3.1
displaying the messages log area, 3.3.1
displaying validation messages for objects, 3.6.1.9
displaying welcome pages for wizards, A.1.5
DM Tree, 7.5.1
dockable panels, 3.6
domain analysis, 8.6.1
DRDA, 4.3

E

editor components, 3.6.1
editor display options, 3.6.1.7
editor modes, 3.6.1
editor toolbars, 3.6.1.6
editor windows, 3.6.1.1
editors, 3.6, 3.6.1
common components, 3.6.1
EJB/Java activity type in Process Flows, 1.3.30
enforcing data quality, 8.3
ensuring data quality, 8.1
ERP, 4.3
error details
viewing for ETL runtime, 3.8
errors
Extension tab, 3.3.1
EVERYONE, 7.1.1
Excel, 4.3
execution
about, 9.1.2
EXPAND, 1.3.20
Expert Editor, 10.2.1
Experts, 1.3.9
about, 10.2
design environment, 10.2.1
Guided Assistance, 10.3
storage, 10.2.2
expression editing, 1.3.10
extensible platform framework, 1.3.11
extensions, 2.4.1
Extensions tab, 3.3.1
external table update, 3.3.1
external tables
defined, 4.4.1
External Table option, 4.4.1
extracting existing metadata, 4.1

F

file object, 4.4
Flat File Sample Wizard, 4.4
flat files
as data sources, 4.4
as targets, 4.4
Create Flat File Wizard, 4.4
definitions, 4.4
operators, 4.4.2
what's new, 1.3.7
foldering, 1.3.27
user folders, 1.3.25
folders, 3.2.2
functional dependency analysis, 8.6.2
Fusion Client Platform, 3.3

G

Gallery, 3.3
gallery
new, 3.6.1.4
Gateway, 4.6
Gateways, 4.6
DRDA, 4.6
Informix, 4.6
ODBC, 4.6
SQL Server, 4.6
Sybase, 4.6
Teradata, 4.6
General Toolbar, 3.6.1.6
generated scripts
displaying for selected object, 3.3.1
generating reports about workspace objects, 3.8
generation, 3.6.1.9
Generation panel, 3.6.1.9
Global Search, 3.3
Globals Navigator, 3.5.3
Go to File, 3.3
Go to Java Class, 3.3
government regulations, 7.6
GRAPHIC, 4.4
Graphical Navigator, B.1
grouping objects, 1.3.13
Guided Assistance Experts
about, 10.3

H

help
F1 key, 2.4
online documentation, 2.4
search, 2.4.1
Help Center, 2.4.2
Help menu, 2.4.1
heterogeneous audit, 1.3.14
heterogeneous databases, 1.2.1, 1.3.11
heterogeneous reporting, 1.3.14
hiding navigators, 3.3.1
hiding OMB*Plus, 3.3.1
hiding welcome pages for wizards, A.1.5
hierarchies
about, 5.3.2.4
value-based hierarchies, 5.3.2.8
highlights, 1.1

I

IDE, 1.3.23, 3.3
impact analysis
displaying on metadata, 3.3.1
implementing
dimensional objects, 5.2.2.2
MOLAP cubes, 5.6.2.2
relational cubes, 5.6.2.1
ROLAP cubes, 5.6.2.1
snowflake schema, 5.3.3.2
star schema, 5.3.3.1
Import Metadata Wizard
metadata
Import Metadata Wizard, 4.1.1
import wizard
Metadata Import Wizard, 4.1.1
importing source metadata, 4.1
improving execution time, 3.3.1
Indicator Bar, 3.6.1
Informix, 4.3
Integrated Development Environment (IDE), 1.3.23
intelligence objects, 5.1
Item Folder Editor, B.2

J

J2EE User Management window, 3.3.1
Jacl, 10.1
JAR files, 10.2.1
Java-based (J2EE) Control Center Agent, 1.3.18
Java-based runtime environment, 1.3.18
JDBC connectivity support, 1.3.4
JDev-based IDE, 3.6.1.4
JDeveloper-style user interface, 1.3.23
JDev-style editors, 3.6
Job Monitor, 3.3.1
job scheduling, 9.4
Join operator, 1.3.33

K

Key Lookup operator, 1.3.19

L

large updates, 1.3.28
large volumes of data, 4.4.2
levels
dimension, 5.3.2.2
lifecycle of a data system, 9.2
lineage analysis
displaying on metadata, 3.3.1
Lineage and Impact Analysis (LIA), 7.6.1
lineage diagram, 7.6.1
locale
setting, 2.2.2
locations, 1.3.17, 4.2
Locations Navigator, 3.5.2
locations registered in multiple Control Centers, 1.3.15
logging in to a workspace, 3.1
logical name mode See business name mode
logical names See business names, A.1.11.1, A.1.11.1
logs, message log preferences, A.1.9
LONG data type, 1.3.31

M

mainframe sources, 4.1
manage J2EE users, 3.3.1
managing data quality, 8.1
managing multiple configurations, 1.3.22
managing OWB locations, 1.3.17
mapping
nested, 6.4
Mapping Connection dialog box, 1.3.26
Mapping Editor
about, 3.6
components, 3.6.1
toolbars, 3.6.1.6
windows, 3.6.1.1
Mapping Generation Languages, 6.3
Mapping Navigator, 3.6.1.2
mapping operator, 6.3
mapping operators
about, 6.2
mappings
about, 6.2
designing, 6.5
pluggable, 6.4
matching, 8.8
Materialized View Editor, B.2
MDL export, 7.3
Menu Bar, 3.6.1
merging, 8.8
message log preferences, A.1.9
Message tab, 3.6.1.9
Messages area, 3.3
messages log
displaying, 3.3.1
metadata
about, 4.1
and database dictionary, 4.1
dependencies, 7.6
security, 7.1
stores, custom SQL or XML, 4.1
metadata dependencies, diagrams of, 7.6
Metadata Dependency Manager, 3.3.1, 7.6, 7.6
Metadata Dependency Manager (MDM), 7.5
Metadata Loader (MDL)
using, 7.3
Metadata Loader utility, 7.2
metadata search and find, 1.3.15
modes
business name mode, A.1.11.1
logical name mode See business name mode
naming mode, default, A.1.11.1
physical name mode, A.1.11.1
modules, 3.2.1, 3.2.1
about, 4.2
Create Module Wizard, 4.2
Transportable, 4.7
MOLAP, 5.2.1
MOLAP implementation, 5.2.1
monitoring data quality, 8.4
monitoring quality, 1.3.14
moving large volumes of data, 4.7
multiple configuration management, 1.3.22
multiple projects, 3.2

N

names
business name mode, A.1.11.1
business object names, syntax for, A.1.11.1, A.1.11.1, A.1.11.1
default naming mode, A.1.11.1
logical name mode See business name mode
physical name mode, A.1.11.1
physical object names, syntax for, A.1.11.1
naming
modes, default naming mode, A.1.11.1
objects, business name mode, A.1.11.1
objects, logical name mode See business name mode
objects, physical name mode, A.1.11.1
setting naming preferences, A.1.11
transformation names, A.1.11.1
Naming Mode, 3.6.1
native ABAP code, 4.3
navigators, 3.5
nested Experts, 10.2.1
Nested Table Editor, B.2
nested user folders, 1.3.25
new feature, 1.1
New Gallery, 3.6.1.4
NFS, 4.4
node, 4.2
SAP, 4.2
non-Oracle database systems
as data sources, 4.5, 4.6
non-Oracle databases, 4.6

O

OBI EE, 5.1
object lookups using synonyms, 4.1.1
Object Type Editor, B.2
objects
syntax for business names, A.1.11.1
syntax for logical names, A.1.11.1, A.1.11.1
syntax for physical names, A.1.11.1
OC4J 10.3.3, 1.3.27
ODBC, 4.3
ODBC Data Source Administrator, 4.3
ODBC for heterogeneous data sources, 4.6
OLAP catalog, 5.2.2.5
OLAP cube storage, 1.3.3
OLAP metadata, 5.2.2.5
OLAP option, 5.2.2.2
OLAP uses, 5.2.1
OLE DB drivers for heterogeneous data sources, 4.6
OMB*Plus, 3.3.3, 10
command window, 3.3.3
OMB*Plus activity type in process flows, 1.3.32
OMB-prefixed commands, 10.1
OMU-prefixed commands, 10.1
opening multiple editors, 1.3.23
operator comments, 1.3.24
operator palette, 3.6.1.5
operators
locating, 3.6.1.5
operators, mapping, 6.2
Optimize Repository, 3.3.1
optimizing the repository, A.1.5
options for Oracle Warehouse Builder, 2.1
Oracle Business Intelligence Suite Enterprise Edition (OBI EE), 1.3.2, 4.3, 5.1
Oracle Database release 8.1, 4.3
Oracle Database XE, 2.1
Oracle Discoverer, 5.1
Oracle Gateways, 4.6
Oracle Heterogeneous Services (Gateways), 4.3
Oracle JDeveloper, 1.3.23
Oracle SQL Developer, 1.3.23
Oracle target module, 3.2.1
Oracle Technology Network, 2.4.1
Oracle Transparent Gateways, 4.6
Oracle Warehouse Builder Utility Exchange, 2.4.1
Oracle Workflow, 4.3
organizing objects, 1.3.25
orphan management, 1.3.12
orphan management policy, 5.2.2.6
OWB locations, 1.3.17
OWB on OTN, 2.4.1
OWB product updates, 2.4.1
OWB Utility Exchange, 2.4.1
OWBSYS and OWBSYS_AUDIT accounts, 2.2

P

Palette, 3.6.1.5
Palette Toolbar, 3.6.1.6
parallelizing large table updates, 1.3.28
parent identifier, 5.3.2.2.3
pattern analysis, 8.6.1
Peoplesoft, 4.3
Peoplesoft application data, 1.3.31
performance
improving, 3.3.1
phases in the data quality lifecycle, 8.1.1
physical names
physical name mode, A.1.11.1
syntax for physical object names, A.1.11.1
plain text files, 4.4, Glossary
platform extensibility, 1.3.11
PL/SQL, 6.2
PL/SQL code, 1.3.24
pluggable mapping, 6.4
pluggable mappings
embedded, 6.4
reusable, 6.4
preferences
displaying welcome pages for wizards, A.1.5
message log preferences, A.1.9
naming preferences, A.1.11
private Experts, 10.2.2
privileged user, 4.2.1
process flows, 1.2.7
profile
displaying, 3.3.1
projects, 3.2
Projects Navigator, 3.5.1
Properties Inspector, 3.6.1.3
Property Inspector, 7.5.1
property inspector, 3.6
public Experts, 10.2.2
public Experts folder, 10.3
Public Transformations node, 6.5.2
public views, 9.3

Q

quality
assessment, 8.1.1.1
design, 8.1.1.2
monitoring, 8.1.1.4
transformation, 8.1.1.3
Quick Mapper, 1.3.26, 1.3.26
quick search field, 3.6.1.5
Quick Start, 2.2

R

RAW, 4.4
Read/Write Mode, 3.6.1
record types, 4.4
Recycle Bin, 3.3.1
referential analysis, 8.6.3
refresh repository, 1.3.29
relational and dimensional data objects, 5.1
relational implementation, 5.2.1
relational ROLAP, 5.2.1
Rename Mode, 3.6.1
rename MY_PROJECT, 2.2.2
Repository
optimizing, A.1.5
Repository Browser, 1.3.27, 3.8
displaying in default Web browser, 3.3.1
opening, 3.8
Repository Browser changes, 1.3.27
Repository Browser or Heterogeneous Repository Browser, 9.3
repository optimization, 3.3.1
Repository upgrades, 1.3.29
requirements
for business names, A.1.11.1
reusable transformations, 6.5.2
ROLAP, 5.2.1
ROLAP implementation, 5.2.1
roles
dimension roles, 5.3.2.5
runtime auditing, 9.3

S

SAP ABAP, 6.2
SAP node, 4.2
SAP R/3 system, 4.2
SCDs
see slowly changing dimensions
scenarios, 2.1.1
schema correction, 8.7.1.1
Script tab, 3.6.1.9
scripting language, 10.1
OMB*Plus, 3.3.3
Security folder, 3.5.3
security interface
about, 7.1.1
security node, 7.1.1
session properties, 2.4.1
setting
locale, 2.2.2
message log preferences, A.1.9
naming preferences, A.1.11
wizard preferences, A.1.5
Siebel, 4.3
Six Sigma
formula, 8.6.5.1
methodology, 8.6.5
metrics, 8.6.5.2
slowly changing dimensions
about, 5.4
type 1, 5.4.1
SMALLINT, 4.4
snapshots, 7.2
uses, 7.4
using, 7.4
SOA, 1.2.2, 1.2.7
SOA integration, 1.3.34
SOA-style architectures, 1.2.2
sources
mainframe, 4.1
sources and targets
supported, 4.3
SQL DML statement, 4.4.1
SQL Server, 4.3
SQL*Loader, 4.4.2, 6.2
SQL*Loader code, 4.4.2
SQL*Plus code, 1.3.31
SQL*Plus window, 3.3.1
staging table, 4.4.2
Start Page, 2.2
starting the Design Center, 2.2.1
STARTUP
folder, 10.3
storage of Experts
public and private, 10.2.2
structure panel
See editors, B.2
subqueries, 1.3.33
supported sources and targets, 4.3
surrogate identifier, 5.3.2.2.1
Sybase, 4.3
syntax
for business object names, A.1.11.1
for logical object names, A.1.11.1, A.1.11.1
for physical object names, A.1.11.1

T

Table Editor, B.2
table functions, 1.3.8
tab-separated format, 4.4, Glossary
Tcl language, 10.1
TCP/IP, 4.4
Teradata, 4.3
time dimensions
about, 5.5
timings
viewing for mappings and process flows, 3.8
Title Bar, 3.6.1
Toolbar, 3.6.1
training, 2.4.1
transformation, 6.1
transformation capabilities, 1.2.6
transformation libraries
global shared library, 6.5.2
Oracle library, 6.5.2
transformation library, 6.5.2
transformations
about, 6.5
names, unique, A.1.11.1
types of, 6.5
Transportable modules, 4.7
troubleshooting OWB-generated code, 1.3.24

U

unique
transformation names, A.1.11.1
unique key analysis, 8.6.1
update external table, 3.3.1
upgrade repository, 1.3.29
use cases, 2.1.1
user ID, 4.2.1
user interface, 3
user interface framework, 1.3.23
user preferences
displaying, 3.3.1
user-defined types
importing, 4.1.1
uses for OLAP, 5.2.1

V

Validation Mode, 3.6.1
validation results
displaying, 3.3.1
VARRAY, 1.3.20
VArray Editor, B.2
version and history management, 7.2
version information, 2.4.1
View Editor, B.2
viewing design details, 3.8
viewing metadata properties, 3.8

W

Web Service, 1.3.34
Web-based access to workspaces, 3.8
wizards, 3.7
welcome pages, displaying, A.1.5
Workspace, 3.1
workspace access, 3.1
workspace session, 2.4.1

X

XPDL, 9.1.1