Skip Headers
Oracle® Warehouse Builder User's Guide
11g Release 1 (11.1)

B31278-06
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  R  S  T  U  V  W  X 

A

accessing
transformation libraries, 15.5.2
activities
AND, 21.2
assign, 21.3
control, 21.1.3
data auditor monitor, 21.4
email, 21.5
file exists, 21.8
For Loop, 21.10
FORK, 21.9
ftp, 21.11
in process flows, 20.4.1
manual, 21.12
mapping, 21.13
OR, 21.15
OWB-specific, 21.1.1
route, 21.16
Set Status, 21.17
sqlplus, 21.18
start, 21.19
user-defined, 21.22
utility, 21.1.2
wait, 21.23
While Loop, 21.24
activity templates, 20.5
adding
groups to mappings, 18.2.2
mapping operators, 16.3
addresses, cleansing, 24.2
administrative transformations, 19.3
advanced attribute set properties, 13.10.1
Aggregate function, 18.4.3
aggregating data, 18.4
Aggregator operator, 18.4
ALL, 18.4.3
DISTINCT, 18.4.3
alternative sort orders
creating, 11.2.11
editing, 11.2.12
analytic workspace, 14.1.2.3.1
AND activity, 21.2
Anydata Cast Operator, 18.5
Anydata Cast operator, 18.5
applying
data rules, 23.8.3
assign activity, 21.3
attribute analysis, 23.2.2.1
attribute properties, setting, 16.8, 17.3.2
attribute sets, 13.10
about, 13.10
advanced properties, 13.10.1
creating, 13.10.1
editing, 13.10.2
tables, 13.7.1.6
attributes
connecting, 16.5.1
defining, 13.7.1.6
dimension attributes, 14.2.3.1
level attributes, 14.2.3.3
setting properties, 16.8
audit details, removing, 27.5.12, 27.5.13
auditing
deployments, 27
executions, 27
auto binding
rules, 14.2.4.2

B

BINARY_DOUBLE data type, 13.1.1
BINARY_FLOAT data type, 13.1.1
binding
about, 14.1.2.1.1
auto binding, 14.1.2.1.1
auto binding, rules, 14.2.4.2
manual binding, 14.1.2.1.1
BLOB data type, 13.1.1
bridges, versions, 10.1.2
building expressions, 18.3
business areas
adding item folders, 11.3.2, 11.3.2
creating, 11.2.5
editing, 11.2.6
business definitions
about, 11.1.2
deploying, 25.2.2
business definitions module, 11.2.1
Business Domain, 6.1.1.1, 6.2.1.1
business domains
SAP, 7.3.2
business identifier, 14.2.3.2.2
Business Intelligence objects
deriving, 11.2.17
business intelligence objects
about, 11.1.1
deploying, 25.2.2
Business Intelligence tools, integration, 10.1
business names
business name mode, 3.2.8.1
maximum length, 3.2.8.1
requirements, 3.2.8.1
syntax for business object names, 3.2.8.1

C

CASS reporting, 24.2.2
changes
rolling out to the target schema, 25.3
CHAR data type, 13.1.1, 18.18, 18.18
character transformations, 19.4
check key constraints, 13.4.1
cleansing
addresses, 24.2
names, 24.2
CLOB data type, 13.1.1
code generation
configuring target directories, 13.13.2.4
options, 22.6.3
coding conventions, Preface
collections
Create Collection Wizard, 3.3.1
creating, 3.3.1
deleting shortcuts in, 3.3
editing, 3.3.2
renaming, 3.3.2.1
commit strategies
committing multiple mappings, 22.1.5
committing to multiple targets, 22.1.3.1
comparing process runs, 27.5.3
configuration options
deployable, 14.8, 14.10
deployment options, 14.10
materialized view index tablespace, 14.10
materialized view tablespace, 14.10
configuration parameters
data profiles, 23.6.12
configuration properties
ABAP extension, 13.13.2.6
ABAP run parameter file, 13.13.2.6
ABAP spool directory, 13.13.2.6
archive directory, 13.13.2.5
base tables, 13.13.4.1
buffer cache, 13.13.3
build, 13.13.4.1
data segment compression, 13.13.3
DDL directory, 13.13.2.6
DDL extension, 13.13.2.6
DDL spool directory, 13.13.2.6
default index tablespace, 13.13.2.2
default object tablespace, 13.13.2.2
default rollback segment, 13.13.4.1
deployable, 13.13.4.1
deployment options, 14.8.1
dimension, 14.8
end of line, 13.13.2.3
error table name, 13.13.3, 13.13.4.1
for update, 13.13.4.1
hash partition tablespace list, 13.13.4.1
input directory, 13.13.2.5
invalid directory, 13.13.2.5
lib directory, 13.13.2.6
lib extension, 13.13.2.6
lib spool directory, 13.13.2.6
loader directory, 13.13.2.6
loader extension, 13.13.2.6
loader run parameter file, 13.13.2.6
local rollback segment, 13.13.4.1
location, 13.13.2.1
log directory, 13.13.2.5
logging mode, 13.13.3, 13.13.4.1
master rollback segment, 13.13.4.1
next date, 13.13.4.1
overflow tablespace list, 13.13.3
parallel access mode, 13.13.3, 13.13.4.1
parallel degree, 13.13.3, 13.13.4.1
partition tablespace list, 13.13.3
PL/SQL directory, 13.13.2.6
PL/SQL extension, 13.13.2.6
PL/SQL Generation Mode, 13.13.2.4
PL/SQL run parameter file, 13.13.2.6
PL/SQL spool directory, 13.13.2.6
query rewrite, 13.13.4.1
receive directory, 13.13.2.5
refresh, 13.13.4.1
refresh on, 13.13.4.1
row movement, 13.13.3
row-level dependency, 13.13.3
sequences, 13.13.6
sort directory, 13.13.2.5
staging file directory, 13.13.2.6
start with, 13.13.4.1
statistics collection, 13.13.3
tablespace, 13.13.3, 13.13.3, 13.13.4.1
using constraints, 13.13.4.1
work directory, 13.13.2.5
configuring
cubes, 14.10
data auditors, 23.9.4
data objects, 12.2
data profiles, 23.6.5.2
dimensions, 14.8
flat file operators, 22.6.5
mapping sources and targets, 18.16.1
master-detail mappings, 22.2.1.2
master-detail mappings, direct path load, 22.2.2
materialized views, 13.13.4
Name and Address server, 24.4.2.1
PL/SQL mappings, 22.1
runtime parameters, 13.13.1
runtime parameters, SAP files, 7.8.1.3
SAP, loading type parameter, 7.8.1.2
sequences, 13.13.6
tables, 13.13.3
target modules, 13.13.2
views, 13.13.5
configuring mappings, 22.6.1
connecting
attributes, 16.5.1
groups, 16.5.2
operators, 16.5
connections, updating, 27.5.16
connectivity
ODBC, 4.2
OLE DB drivers for heterogeneous data sources, 4.2
connectivity agent, 4.2
connectors
about, 4.3.2
creating, database connector, 4.3.2
creating, directory connector, 4.3.2
constants, defining, 17.3.2
constraints
check constraints, creating, 13.4.2.4
check key, about, 13.4.1
creating, 13.4.2
editing, 13.4.3
foreign key, about, 13.4.1
foreign key, creating, 13.4.2.2
primary key, about, 13.4.1
primary key, creating, 13.4.2.1
unique key, about, 13.4.1
unique key, creating, 13.4.2.3
containers
Oracle Designer Repository, 5.1
SAP application, 7.6.3
control activities, 21.1.3
Control Center reports, 27.4
control center transformations, 19.5
conventional path loading
for master-detail relationships, 22.2.1.2
master-detail flat files, 22.2.1.2
conventions
coding, Preface
example, Preface
conversion transformations, 19.6
correlated commit, design considerations, 22.1.3.1
Create External Table Wizard, 8.6.1
Create Flat File Wizard, 8.2
creating
alternative sort orders, 11.2.11
attribute sets, 13.10.1
business areas, 11.2.5
business definition module, 11.2.1
collections, 3.3.1
constraints, check constraints, 13.4.2.4
constraints, foreign key constraints, 13.4.2.2
constraints, unique key constraints, 13.4.2.3
cubes, 14.9, 14.9.1
cubes, using the Cube Editor, 14.9.2
data auditors, 23.9.1
data profiles, 23.6.4
data rules, 23.8.1
dimensional objects, 14.1.1
dimensions, 14.6, 14.6.1, 14.6.2
display sets, 16.4.5.1
drill paths, 11.2.7
drills to detail, 11.2.13
expressions, 18.3
indexes, 13.5.1
item folders, 11.2.4, 11.3.3
list of values, 11.2.9
locations, 4.3.1.1
mappings, 16
Oracle Designer 6i source modules, 5.1.1
physical objects, 13.13.2
PL/SQL types, 19.1.2, 19.1.2.3
pluggable mappings, 16.6.1
primary key constraints, 13.4.2.1
process flows, 20.2.3
registered functions, 11.2.15
time dimensions, using the Time Dimension Wizard, 14.11.1
type 2 SCDs, 14.6.1.6, 14.7.1
type 3 SCDs, 14.6.1.6, 14.7.2
cubes, 14.5
configuring, 14.10
creating, 14.9, 14.9.1, 14.9.2
default aggregation method, 14.5.1.2
dimensionality, 14.5.1.2, 14.9.1.3
editing, 14.9.4
example, 14.5.1.3
measures, 14.5.1.1
measures, creating, 14.9.1.4
MOLAP implementation, 14.5.2.3
relational implementation, 14.5.2.1
ROLAP implementation, 14.5.2.1
solve dependency order, 14.5.3
storing, 14.9.1.2
custom transformations
about, 15.4.1.2
defining, 19.1
editing, 19.2

D

data
aggregating, 18.4
cleansing, 24.2
test, 16.11.3
viewing, 13.2.1
data auditor error tables
viewing, 27.5.14
data auditor monitor activities, 21.4
data auditors
configuring, 23.9.4
creating, 23.9.1
granting privileges on error tables, 23.9.5.1
using, 23.9.3
viewing error tables, 23.9.5, 27.5.14
data definitions, importing, 5
data flow operators, 15.3.1.2, 18.1
Data Object Editor
components, 13.2
creating data objects, 13.2.2
starting, 13.2
using, 13.2.2, 13.3
data objects
about, 13.1
data type for columns, 13.1.1
defining, 13
dimensional objects, creating, 14.1.1
dimensional objects, implementing, 14.1.2
editing, 13.2.2, 13.3
identifying deployment location, 27.5.6
monitoring data quality, 23.9
naming conventions, 13.1.2
used in map run, 27.5.7
validating, 12.3
viewing, 13.2.1
data profile
adding objects, 23.6.11
Data Profile Editor
components, 23.2.3
data profiles
adding data objects, 23.6.11.1
configuration parameters, 23.6.12
configuring, 23.6.5.2
creating, 23.6.4
data profiling
about, 23.2
generating corrections, 23.6.8
performance tuning, 23.7
performing, 23.6
steps, 23.6.2
types, 23.2.2
types, attribute analysis, 23.2.2.1
types, functional dependency, 23.2.2.2
types, referential analysis, 23.2.2.3
viewing corrections, 23.6.8.7
viewing results, 23.6.6
data quality
ensuring, 23
Match-Merge operator, 24.1
data quality operators, 23.3.2
data rules, 13.7.1.7
about, 23.4
applying, 23.8.3
creating, 23.8.1
deriving, 23.6.7
editing, 23.8.2
types, 23.4.1
using, 23.8
data sources, 5
See also sources
defining SAP objects, 7.6.3
E-Business Suite, 6.1
flat files, 8.3
Oracle Designer 6i, 5.1
Oracle Heterogeneous Services, 4.2
Oracle Transparent Gateways, 4.2
PeopleSoft, 6.2
Siebel, 6.3
data types
list of supported, 13.1.1
Data Viewer, 13.2.1
databases
importing definitions from, 4.4.1
reimporting definitions, 4.5
DATE data type, 13.1.1
date transformations, 19.7, 19.7
debugging
map runs, 27.5.4
mappings, 16.11
processes, 27.5.2
starting point, 16.11.6.3
Deduplicator operator, 18.6, 18.6
DISTINCT, 18.6
default deployment-time setting, 27.5.8
default naming mode, 3.2.8.1
defining
constants, 17.3.2
data objects, 13
dimensional objects, 14
ETL process for SAP objects, 7.8
flat files, 8
indexes, 13.7.1.4
mappings, 16
materialized views, 13.9.2
process flows, 20.2
schedules, 26.2
sequences, 13.11.2
tables, 13.7.1
test data, 16.11.3
updating source definitions, 4.5.2
views, 13.8.2, 13.8.3
defining indexes, 13.7.1.4
defining tables, 13.7.1
definitions
importing definitions from a database, 4.4.1
reimporting database definitions, 4.5
deleting
groups from mappings, 18.2.2
deploying
about, 25.1.1
business definitions, 25.2.2
data objects, 25.2.1
deployment actions, 25.1.1.1
deployment errors, 28.1
deployment results, 25.2.3
deployment status, 25.1.1.2
process flows, 20.1.1
reporting on, 27.4, 27.4.1
deployment actions, 25.1.1.1
deployment and execution
steps, 25.2
deployment reports, 27.4, 27.4.1
deployment time settings, 27.5.8
deployments
auditing, 27
identifying, 27.5.5
deriving
business intelligence objects, 11.2.17
data rules, 23.6.7
Design Center
in Repository Browser, 27.3
Designer 6i, 5.1, 5.1
designing
process flows, 20
target schema, 12.1
target schema, dimensional, 12.1.2
target schema, relational, 12.1.1
Dimension operator, 17.3.7
dimensional objects, 14.1
binding, 14.1.2.1.1
creating, 14.1.1
creating, about, 14.1
defining, 14
deployment options, 14.1.3
implementing, 14.1.2
unbinding, 14.1.2.1.1
dimensions
about, 14.2
binding, 14.2.4.2, 14.6.2.8
business identifier, 14.2.3.2.2
configuring, 14.8
control rows, 14.2.3.8
creating, 14.6, 14.6.1, 14.6.2
dimension attributes, 14.2.3.1
creating, 14.6.1.3
dimension roles, 14.2.3.5
editing, 14.7.3
example, 14.2.3.7
hierarchies, 14.2.3.4
hierarchies, creating, 14.6.1.4, 14.6.2.5
implementing, 14.2.4
level attributes, 14.2.3.3
level attributes, creating, 14.6.1.5
level relationships, 14.2.3.6
levels, 14.2.3.2
levels, creating, 14.6.1.4
MOLAP implementation, 14.2.4.3
parent identifier, 14.2.3.2.3
relational implementation, 14.2.4.1
ROLAP dimension limitations, 14.2.2
ROLAP implementation, 14.2.4.1
rules, 14.2.1
snowflake schema implementation, 14.2.4.1.2
star schema implementation, 14.2.4.1.1
storing, 14.6.1.2
surrogate identifier, 14.2.3.2.1
time dimensions, about, 14.4
value-based hierarchies, 14.2.3.9
direct path loading
for master-detail relationships, 22.2.2
master-detail flat files, 22.2.2
display sets
creating, 16.4.5.1
defined, 16.4.5
displaying
welcome pages for wizards, 3.2.5
DISTINCT
in the Aggregator operator, 18.4.3
in the Deduplicator operator, 18.6
DML error logging
about, 28.2
enabling, 28.2.2
in ETL, 28.2.2.1
limitations, 28.2.3
drill paths
creating, 11.2.7
editing, 11.2.8
drills to detail
creating, 11.2.13
editing, 11.2.14

E

E-Business Suite
importing metadata, 6.1
editing
alternative sort orders, 11.2.12
attribute sets, 13.10.2
business areas, 11.2.6
collections, 3.3.2
constraints, 13.4.3
cubes, 14.9.4
data rules, 23.8.2
dimensions, 14.7.3
drill paths, 11.2.8
drills to detail, 11.2.14
invalid objects, 12.3.1
item folders, 11.2.3
list of values, 11.2.10
materialized views, 13.9.3
PL/SQL types, 19.2.2
process flows, 20.3
registered functions, 11.2.16
table definitions, 13.7.2
time dimensions, 14.11.2
transformation properties, 19.2
views, 13.8.3
editing data objects, 13.3
email activity, 21.5
enabling
DML error logging, 28.2.2
ensuring data quality, 23
error logs
interpreting error logs, 28.1
error tables
about, 28.2.1
granting privileges, 23.9.5.1
required privileges, 23.9.5.1
ETL
improving runtime performance, 22
ETL objects, scheduling, 26
example conventions, Preface
Excel files
loading data from, 9
executing
mappings from SQL*Plus, 22.1.5
reports, 27.4, 27.4.2
execution
about, 25.1.2
errors, 28.1
execution reports, 27.4, 27.4.2
executions
auditing, 27
exporting
log file, 10.1.2.3.1
Expression Builder
about, 18.3
opening, 18.3.1
Expression operator, 18.7, 18.7
expressions, creating, 18.3
External Table editor, 8.6.3
external tables
configuring, 8.6.4
creating a new definition, 8.6.1
defined, 8.1.1.3, 8.6
editor, 8.6.3
synchronizing definition, 8.6.2
wizard for creating, 8.6.1
See also flat files
extracting from master-detail flat files, 22.2.1, 22.2.1.2

F

fast refresh, 13.13.4.2
File Exists activity, 21.8
file transfer
in process flows, 20.10
files, defining, 8
Filter operator, 18.8, 18.8, 18.8
filters, with a transform, 19.14
flat file modules, creating, 8.1.3
Flat File Sample Wizard, 8.4
flat files
configuration, 22.6.5
configuring master-detail mappings, 22.2.2
creating new, 8.2
defining, 8
describing, 8.2.1
extracting master and detail records, 22.2.1.2
importing master-detail flat files, 22.2.1.2
mapping, 16.1.1
master-detail mappings, post-update scripts for direct path loads, 22.2.2
master-detail, example, 22.2.1
master-detail, extracting from, 22.2.1
master-detail, operations after initial load, 22.2.1.4
as sources, 8.1.1
as targets, 8.1.2
variable names, in process flows, 20.9
See also external tables
FLOAT data type, 13.1.1
For Loop activity, 21.10
foreign key constraints, 13.4.1
foreign keys, ensuring referential integrity, 22.1.6
FORK activity, 21.9
FTP
using in process flows, 20.10
ftp activity, 21.11
full outer joins, 18.9.2
function module, 7.4
functional dependency, 23.2.2.2
functions
Aggregate, 18.4.3
as transformations, 15.4.1.2
defining, 19.1
editing, 19.2.1

G

generating
about, 12.4
data objects, 12.4
generating corrections, 23.6.8
generation
errors, 28.1
global shared library, 15.5.1
Group By clause, 18.4.1
group properties, 16.8
groups
adding to mappings, 18.2.2
connecting, 16.5.2
removing from mappings, 18.2.2
setting properties, 16.8

H

Having clause, 18.4.2
heterogeneous data sources, 4.2
hiding
welcome pages for wizards, 3.2.5
hierarchies
about, 14.2.3.4
creating, 14.6.1.4, 14.6.2.5
value-based hierarchies, 14.2.3.9
householding, 24.1, 24.1, 24.3.3

I

impact analysis
rolling out changes to target schema, 25.3
implementing
dimensional objects, 14.1.2
MOLAP cubes, 14.5.2.3
MOLAP dimensions, 14.2.4.3
relational cubes, 14.5.2.1
relational dimensions, 14.2.4.1
reporting on, 27.3.2.3
ROLAP cubes, 14.5.2.1
ROLAP dimensions, 14.2.4.1
snowflake schema, 14.2.4.1.2
star schema, 14.2.4.1.1
importing
data definitions, 5
definitions, database systems, 4.4.1
flat files, 8.3
from E-Business Suite, 6.1
from flat files, 8.3
from PeopleSoft, 6.2
from SAP R/3, 7.6
from Siebel, 6.3
Import Metadata Wizard, 4.4.1
master-detail flat files, 22.2.1.2
metadata for flat files, 8.4
Oracle database metadata, 4.4.1
PL/SQL functions, 19.14
reimporting database definitions, 4.5
importing metadata, 10.1.2
improving runtime performance, 22
index partitioning, 13.5.1, 13.6.6
indexes
creating, 13.5.1
defining, 13.7.1.4
types, 13.5.1
input signature, 16.6.1.4
inserting into multiple targets, 18.16.1
installation
errors, 28.1
INTEGER data type, 13.1.1
integration with Business Intelligence, 10.1
INTERVAL DAY TO SECOND data type, 13.1.1
INTERVAL YEAR TO MONTH data type, 13.1.1
item folders
about, 11.2.2
adding items, 11.3.4, 11.3.4
creating, 11.2.4, 11.3.3
creating joins, 11.3.6
editing, 11.2.3
synchronizing, 11.3.5

J

Joiner operator, 18.9, 18.9, 18.9.2
joining multiple row sets, 18.9
joins, full outer, 18.9.1.1, 18.9.2, 18.9.2

K

Key Lookup operator, 18.10, 18.10

L

language, SAP, 7.8.1.3
languages,setting locale preferences, 3.2.1
levels
dimension, 14.2.3.2
list of values
creating, 11.2.9
editing, 11.2.10
loading
conventional path for master-detail targets, 22.2.1.2
data from Excel files, 9
data from materialized view, 17.3.12
direct path for master-detail targets, 22.2.2
flat files, 8.2.4.1
master and detail records, 22.2.1.2
master-detail relationships, 22.2.1.2, 22.2.2
master-detail relationships, direct path, 22.2.2
transaction data, 16.10
loading types, 17.3.1.2
for SAP, 7.8.1.2
locales, setting, 3.2.1
locations
creating, 4.3.1.1
data objects deployed to, 27.5.6
deleting, 4.3.1.4
registering, 4.3.1.3
unregistering, 4.3.1.3, 27.5.15
updating connection details, 27.5.16
log files
export to OMG CWM, 10.1.2.3.1
logical name mode See business name mode
logical names See business names, 3.2.8.1
logs
interpreting error logs, 28.1
message log preferences, 3.2.7
LONG data type, 13.1.1

M

main procedure, 22.1.5
management reports, 27.4, 27.4.3
manual activity, 21.12
map runs, 27.5.4, 27.5.7
mapping activity, 21.13
Mapping Editor
about, 16.2.1
components, 16.2.1
toolbars, 16.2.3
windows, 16.2.2
mapping operators
about, 15.2
adding, 16.3
Aggregator operator, 18.4
connecting, 16.5
Deduplicator operator, 18.6
Dimension operator, 17.3.7
editing, 16.4
Expression operator, 18.7
Filter operator, 18.8
Joiner operator, 18.9
Key Lookup operator, 18.10
Match-Merge operator, 24.1
Name and Address operator, 24.2
Pivot operator, 18.11
Post-Mapping Process operator, 18.12
Pre-Mapping Process operator, 18.13
Set Operation operator, 18.14
setting, 16.8
Sorter operator, 18.15
Splitter operator, 18.16
synchronizing with workspace objects, 16.9
Table Function operator, 18.17
that bind to repository objects, 16.3.1
Transformation operator, 18.18
types of, 15.3.1
Unpivot operator, 18.19
mapping output parameters, 17.3.11
mappings
about, 15.2
adding self joins, 18.8.1
configuring, 22.1, 22.6.1
configuring master-detail, 22.2.1.2
creating, 16
debugging, 16.11
defining, 16
executing from SQL*Plus, 22.1.5
for flat files, 16.1.1
for PEL, 22.3.2
groups, 18.2.2
master-detail mappings, 22.1.6
naming conventions, 16.4.4, 20.5.1
PL/SQL mappings, 22.1
runtime parameters, 22.6.2
setting properties, 16.7
sources and targets, configuring, 18.16.1
master-detail flat files
as sources, about, 22.2.1
configuring mappings, 22.2.1.2
configuring mappings, direct path load, 22.2.2
example of a master-detail flat file, 22.2.1
extracting from, 22.2.1.2
extracting from, using conventional path load, 22.2.1.2
extracting from, using direct path load, 22.2.2
importing and sampling, 22.2.1.2
operations after initial load, 22.2.1.4
performance, 22.2.1.2, 22.2.2
post-update scripts for direct path loads, 22.2.2
RECNUM, 22.2.2
sample mapping, conventional path loading, 22.2.1.2
sample mapping, direct path loading, 22.2.2
Match rules
multiple match rules, 24.1.1.2
transitive match rules, 24.1.1.3
match rules
address match rules, 24.1.9
conditional match rules, 24.1.5
custom match rules, 24.1.10
firm match rules, 24.1.8
person match rules, 24.1.7
weight match rules, 24.1.6
matching
records, 24.1.1
transitive, 24.1.1.3
Match-Merge operator, 24.1
concepts, 24.1.1
custom rules, 24.1.17
design considerations, 24.3.2
example, 24.1.1.1
match rules, 24.1.4
merge rules, 24.1.11
restrictions, 24.1.2
using, 24.3.1
materialized views, 13.9
attribute sets, adding, 13.9.3.4
attribute sets, deleting, 13.9.3.4
attribute sets, editing, 13.9.3.4
columns, adding, 13.9.3.2
columns, deleting, 13.9.3.2
columns, editing, 13.9.3.2
configuring, 13.13.4
constraints, adding, 13.9.3.3
constraints, deleting, 13.9.3.3
constraints, editing, 13.9.3.3
defining, 13.9.2
defining attribute sets, 13.9.2.7
defining columns, 13.9.2.2
defining constraints, 13.9.2.4
defining data rules, 13.9.2.8
defining indexes, 13.9.2.5
defining partitions, 13.9.2.6
defining query, 13.9.2.3
editing, 13.9.3
fast refresh, 13.13.4.2
loading data from, 17.3.12
loading data into, 17.3.12
naming, 13.9.2.1
renaming, 13.9.3.1
update definitions, 13.9.3
MDSYS.SDO_DIM_ARRAY data type, 13.1.1
MDSYS.SDO_DIM_ELEMENT data type, 13.1.1
MDSYS.SDO_ELEM_INFO_ARRAY data type, 13.1.1
MDSYS.SDO_GEOMETRY data type, 13.1.1
MDSYS.SDO_ORDINATE_ARRAY data type, 13.1.1
MDSYS.SDO_POINT_TYPE data type, 13.1.1
MDSYS.SDOAGGRTYPE data type, 13.1.1
Merge rules, 24.1.17
message log preferences, 3.2.7
metadata
import and export errors, 28.1
Import Metadata Wizard, 4.4.1
importing from databases, 4.4.1
importing from flat files, 8.3
integrating with BI products, 10
Microsoft Excel
loading data from, 9
minus, in the Set Operation operator, 18.14
modes
business name mode, 3.2.8.1
logical name mode See business name mode
naming mode, default, 3.2.8.1
physical name mode, 3.2.8.1
modules
configuring target modules, 13.13.2
defining SAP objects, 7.6.3
process flows, 20.1.1, 20.2.1
SAP application, 7.6.3
MOLAP implementation, 14.1
monitoring
data objects, using auditors, 23.9.3
data quality, 23.9
monitoring process runs, 27.5.10
multiple-record-type flat files
master-detail structure, 22.2.1
master-detail structure, example of, 22.2.1
multiple-table insert, 18.16.1

N

Name and Address
country postal certifications, Australia, 24.2.2.3
country postal certifications, Canada, 24.2.2.2
country postal certifications, United States, 24.2.2.1
operator, 24.2
purchasing license, 24.2
Name and Address operator, 24.2
best practices, 24.2.5
CASS reporting, 24.2.2
enabling, 24.2
input roles, 24.2.3
output components, 24.2.4
Name and Address server, 24.4.2
configuring, 24.4.2.1
errors, 28.1
starting, 24.4.2.2
stopping, 24.4.2.2
names
business name mode, 3.2.8.1
business object names, syntax for, 3.2.8.1
cleansing, 24.2
default naming mode, 3.2.8.1
flat files with variable names in process flows, 20.9
logical name mode See business name mode
physical name mode, 3.2.8.1
physical object names, syntax for, 3.2.8.1
names and addresses, processing libraries, 24.4.2
naming
modes, default naming mode, 3.2.8.1
objects, business name mode, 3.2.8.1
objects, logical name mode See business name mode
objects, physical name mode, 3.2.8.1
setting naming preferences, 3.2.8
transformation names, 3.2.8.1
naming conventions, for data objects, 13.1.2
navigating
Repository Browser, 27.3.1
NCHAR data type, 13.1.1
NCLOB data type, 13.1.1
nested tables
creating, 13.12.8
editing, 13.12.9
overview, 13.12.7
non-Oracle database systems
as data sources, 4.2
NUMBER data type, 13.1.1
number transformations, 19.8, 19.8
NVARCHAR2 data type, 13.1.1

O

object properties, report, 27.3.3
object types
creating, 13.12.2
editing, 13.12.3
overview, 13.12.1
objects
invalid objects, editing, 12.3.1
reports, 27.3.2
syntax for business names, 3.2.8.1
syntax for logical names, 3.2.8.1
syntax for physical names, 3.2.8.1
ODBC for heterogeneous data sources, 4.2
OLAP transformations, 19.9
OLE DB drivers for heterogeneous data sources, 4.2
opening
Expression Builder, 18.3.1
Repository Browser, 27.2
operating modes
row based, 22.1.1.2
row based (target only), 22.1.1.3
selecting a default mode, 22.1.1
set based, 22.1.1.1
operator attributes, 16.5.1
Operator Editor
Input tab, 18.2.2
Input/Output tab, 18.2.2
Output tab, 18.2.2
operator properties
setting, 16.8
Operator wizard, 18.2.1
operators
Aggregator, 18.4
Anydata Cast, 18.5
connecting, 16.5
data flow, 15.3.1.2, 18.1
data quality operators, 23.3.2
Deduplicator, 18.6
Deduplicator operator, 18.6
Dimension operator, 17.3.7
editing, 16.4
Expression, 18.7
Expression operator, 18.7
Filter, 18.8
Filter operator, 18.8
flat file, 22.6.5
Joiner, 18.9
Joiner operator, 18.9
Key Lookup operator, 18.10
mapping
binding to repository objects, 16.3.1
Match-Merge operator, 24.1
Name and Address, 24.2
Name and Address operator, 24.2
Pivot operator, 18.11
Post-Mapping Process operator, 18.12
Pre-Mapping Process operator, 18.13
Set Operation operator, 18.14
Sorter operator, 18.15
source, 17.2
Splitter operator, 18.16
synchronizing with workspace objects, 16.9
Table Function operator, 18.17
target, 17.2
Transformation operator, 18.18
Unpivot operator, 18.19
operators, mapping, 15.2
adding, 16.3
connecting, 16.5
editing, 16.4
types of, 15.3.1
optimizing the repository, 3.2.5
OR activity, 21.15
Oracle Designer 6i, 5.1
Application Systems, 5.1
source module, 5.1
workareas, 5.1
Oracle Heterogeneous Services, 4.2
Oracle library, 15.5.1
Oracle Transparent Gateways, 4.2
ORDER BY
in the Sorter operator, 18.15
ordering
multiple targets, 22.1.6
other (non-SQL) transformations, 19.10
output components
Name and Address operator, 24.2.4
output signature, 16.6.1.5

P

packages
as transformations, 15.4.1.2
defining, 19.1
editing, 19.2.1
process flows, 20.1.1, 20.2.2
parameters
mapping output, 17.3.11
parent identifier, 14.2.3.2.3
Partition Exchange Loading (PEL), 22.3
about, 22.3.1
configuring targets for, 22.3.5
mappings for, 22.3.2
performance considerations, 22.3.4
restrictions on, 22.3.5, 22.3.6
partitioning, index, 13.5.1, 13.6.6
partitions
defining, 13.7.1.5
PeopleSoft
importing metadata, 6.2
physical names
physical name mode, 3.2.8.1
syntax for physical object names, 3.2.8.1
Pivot operator
about, 18.11
editing, 18.11.3
example, 18.11.1
expressions for, 18.11.3.6
groups, 18.11.3.2
input attributes, 18.11.3.4
output attributes, 18.11.3.5
row locators, 18.11.2, 18.11.3.5
using, 18.11.3
PL/SQL mappings, 22.1
PL/SQL types
about, 19.1.2.1
as transformations, 15.4.1.2
creating, 19.1.2, 19.1.2.3
editing, 19.2.2
pluggable mappings
about, 16.6
creating, 16.6.1
embedded, 16.6
reusable, 16.6
pooled tables, 7.3.1
Post-Mapping Process operator, 18.12
predefined transformations, 15.4.1.1
preferences
displaying welcome pages for wizards, 3.2.5
locale, 3.2.1
message log preferences, 3.2.7
naming preferences, 3.2.8
Pre-Mapping Process operator, 18.13
primary key constraints, 13.4.1
privileges
for error tables, 23.9.5.1
procedures
as transformations, 15.4.1.2
defining, 19.1
editing, 19.2.1
Process Flow Editor, 20.3
process flows
about, 20.1
activities in, 20.4.1
adding transformations to, 21.21
complex conditions in, 20.8
creating, 20.2.3
debugging, 27.5.2
defining, 20.2
deploying, 20.1.1
designing, 20
editing, 20.3
halting, 21.12
handling flat files with variable names, 20.9
modules, 20.1.1, 20.2.1
packages, 20.1.1, 20.2.2
scripting in, 21.18
starting, 21.20
subprocesses, 21.20
transferring remote files with FTP, 20.10
transitions, 20.6
process runs
aborting, 27.5.11
comparing, 27.5.3
debugging, 27.5.2
identifying recent, 27.5.1
monitoring, 27.5.10
rerunning, 27.5.9
processes
debugging, 27.5.2
identifying recent, 27.5.1
running, 27.5.9
projects
importing PL/SQL into, 19.14
properties
for source operators, 17.3.1
for target operators, 17.3.1
mapping, 16.7
object, 27.3.3
setting, 16.8

R

RAC, managing service nodes, 27.4.3.1
RAW data type, 13.1.1
RECNUM attribute, 22.2.2
RECNUM columns, 22.2.2
records
extracting and loading master and detail records, 22.2.1.2
matching, 24.1.1
relationships between masters and details in flat files, 22.2.1
referential analysis, 23.2.2.3
referential integrity, ensuring in mappings, 22.1.6
registered functions
creating, 11.2.15
editing, 11.2.16
reimporting
database definitions, 4.5
relating master and detail records, 22.2.1
relational implementation, 14.1
REMAINING_ROWS output group
in the Splitter operator, 18.16
remote files
transferring, 20.10
remote function call, 7.6.3
remote function call (RFC)
RFC connection, 7.6.3.1
SAP RFC connection, 7.6.3.1
renaming
collections, 3.3.2.1
materialized views, 13.9.3.1
sequences, 13.11.3.1
tables, 13.7.2.1
views, 13.8.3.1
reordering table columns, 13.7.2.5
repeating schedules, 26.2.1.2, 26.3.2
REPLICATE, 19.12.1
reporting
Control Center, 27.4
execution, 27.4, 27.4.2
implementation, 27.3.2.3
management, 27.4, 27.4.3
object properties, 27.3.3
on deployment, 27.4, 27.4.1
on objects, 27.3.2
reports
Control Center, 27.4
deployment, 27.4, 27.4.1
execution, 27.4, 27.4.2
implementation, 27.3.2.3
management, 27.4, 27.4.3
object, 27.3.2
object properties, 27.3.3
Repository
logging in, 27.2.3
repository
optimizing, 3.2.5
Repository Browser
about, 27.1
Control Center, 27.4
Design Center, 27.3
implementation reports, 27.3.2.3
navigating, 27.3.1
object reports, 27.3.2
opening, 27.2
starting, 27.2.1
stopping, 27.2.1
Repository navigator, 27.3.1
requirements
for business names, 3.2.8.1
reverse engineering, 4.4
RFC, 7.6.3
ROLAP implementation, 14.1
roles
dimension roles, 14.2.3.5
route activity, 21.16
row based, 22.1.1.2
row based (target only), 22.1.1.3
row based versus set based
loading transaction data, 16.10
row locators
in the Pivot operator, 18.11.2, 18.11.3.5
in the Unpivot operator, 18.19.2, 18.19.3.5
rows, filtering out, 18.8
RTRIM function
in the Transformation operator, 18.18
running
processes, 27.5.9
runtime parameters, configuring, 22.6.2
runtime performance, improving, 22
runtime, SAP, 7.8.1.3

S

samples
Flat File Sample Wizard, 8.4
sampling
master-detail flat files, 22.2.1.2
SAP
Business Domain, 6.1.1.1, 6.2.1.1
defining ETL process for SAP objects, 7.8
defining SAP objects, 7.6.3
function module, 7.4
remote function call, 7.6.3
SAP application source module, 7.6.3
SAP business domains, 7.3.2
SAP Connector
creating definitions, 7.6.3
SAP file physical properties
Data File Name, 7.8.1.3
File Delimiter for Staging File, 7.8.1.3
Nested Loop, 7.8.1.3
SAP System Version, 7.8.1.3
SQL Join Collapsing, 7.8.1.3
Staging File Directory, 7.8.1.3
Use Single Select, 7.8.1.3
SAP parameters
language, 7.8.1.3
loading type, 7.8.1.2
runtime, 7.8.1.3
SAP R/3
importing metadata, 7.6
SAP table types
cluster, 7.3.1
importing, 7.3.1
pooled, 7.3.1
transparent, 7.3.1
SAPRFC.INI, 7.6.3
SAPRFC.INI file, 7.6.3.1, 7.6.3.1
SCDs
see slowly changing dimensions
schedules
creating, 26.2
defining, 26.2
duration, 26.2.1.1, 26.3.1
example, 26.2.2
repeating, 26.2.1.2, 26.3.2
using, 26.2
scheduling
about, 26.1
ETL jobs, 25.2.5
ETL objects, 26
scripting
in process flows, 21.18
scripts
for FTP commands, 21.11.1, 21.11.3
self joins, 18.8.1
sequences, 13.11
configuring, 13.13.6
Create Sequence Wizard, 13.11.2
defining, 13.11.2
renaming, 13.11.3.1
service nodes, managing, 27.4.3.1
set based mode, 22.1.1.1
set based update, 22.1.1.1
set based versus row based
loading transaction data, 16.10
set based versus row based modes, 22.1.1
Set Operation operator, 18.14
intersect, 18.14
minus, 18.14
union, 18.14
union all, 18.14
Set Status activity, 21.17
setting
a starting point, 16.11.6.3
attribute properties, 17.3.2
locale preferences, 3.2.1
mapping properties, 16.7
message log preferences, 3.2.7
naming preferences, 3.2.8
wizard preferences, 3.2.5
Setting the Language Parameter, 7.8.1.3
Setting the Runtime Parameter, 7.8.1.3
Siebel
importing metadata, 6.3
signatures
input, 16.6.1.4
output, 16.6.1.5
Six Sigma
metrics, 23.2.4.2
slowly changing dimensions
about, 14.3
hierarchy versioning, 14.3.2.1
type 1, 14.3.1
type 2, 14.6.1.6, 14.7.1
type 2, about, 14.3.2
type 2, updating, 14.3.2.2
type 3, 14.3.3, 14.6.1.6, 14.7.2
types, 14.3
Sorter operator, 18.15, 18.15
source modules, 5
importing definitions, 4.4.1
Oracle Designer 6i, 5.1.1
Oracle Designer Repository, 5.1
SAP application, 7.6.3
source operators, 17.2
sources
data sources, 5
flat files, 8.1.1
master-detail flat file sources, 22.2.1
master-detail flat files, 22.2.1
master-detail flat files, example, 22.2.1
updating source definitions, 4.5.2
Spatial Transformations, 19.11
Splitter operator, 18.16, 18.16
SQL expressions, 18.7
SQL*Loader properties, 8.2.4.1
sqlplus activity, 21.18
Start activity, 21.19
starting
Data Object Editor, 13.2
Name and Address server, 24.4.2.2
Repository Browser, 27.2.1
starting point, setting, 16.11.6.3
stopping
Name and Address server, 24.4.2.2
Repository Browser, 27.2.1
streams transformations, 19.12
subprocesses, to start process flows, 21.20
substitution variables, 21.11.2
summarizing
data with a transformation, 18.4
surrogate identifier, 14.2.3.2.1
surrogate keys
in the Key Lookup operator, 18.10
synchronizing
item folders, 11.3.5
operators and workspace objects, 16.9
syntax
for business object names, 3.2.8.1
for logical object names, 3.2.8.1
for physical object names, 3.2.8.1
SYS.ANYDATA data type, 13.1.1
SYS.LCR$_ROW_RECORD data type, 13.1.1

T

table definitions
creating, 13.7.1
editing, 13.7.2
Table Function operator, 18.17
prerequisites, 18.17.1
using, 18.17
tables, 13.7.1.4, 13.7.1.7
attribute sets, 13.10
attribute sets, adding, 13.7.2.4
attribute sets, defining, 13.7.1.6
attribute sets, deleting, 13.7.2.4
attribute sets, editing, 13.7.2.4
columns, adding, 13.7.2.2
columns, defining, 13.7.1.2
columns, deleting, 13.7.2.2
columns, editing, 13.7.2.2
configuring, 13.13.3
constraints, adding, 13.7.2.3
constraints, defining, 13.7.1.3
constraints, deleting, 13.7.2.3
constraints, editing, 13.7.2.3
data rules, 13.7.1.7
defining, 13.7.1, 13.7.1
defining partitions, 13.7.1.5
naming, 13.7.1.1
renaming, 13.7.2.1
reordering columns, 13.7.2.5
See also external tables
tables (defined), 13.7
target load ordering, 22.1.6
target modules
configuring, 13.13.2
target operators, 17.2
loading types, 17.3.1.2
properties for, 17.3.1
target schema
designing, 12.1
rolling out changes, 25.3
targets
defining load orders, 22.1.6
flat files, 8.1.2
multiple targets in a mapping, 22.1.3.1
multiple targets in mappings, 18.16, 18.16.1
templates
activity, 20.5
test data, defining, 16.11.3
Text String Matching, 6.1.1.1, 6.2.1.1
time dimensions
about, 14.4
creating, using the Time Dimension Wizard, 14.11.1
creation best practices, 14.4.1
data range, 14.11.1.3
dimension attributes, 14.4.2.2
editing, 14.11.2
hierarchies, about, 14.4.2.4
implementing, 14.4.3
level attributes, about, 14.4.2.3
levels, about, 14.4.2.1
levels, creating, 14.11.1.4
populating, 14.4.5
storing, 14.11.1.2
time settings, 27.5.8
TIMESTAMP data type, 13.1.1
TIMESTAMP WITH LOCAL TIMEZONE data type, 13.1.1
TIMESTAMP WITH TIMEZONE data type, 13.1.1
transaction data
loading, 16.10
Transfer Wizard
about, 10.1
log file, export, 10.1.2.3.1
version, 10.1.2
transferring
remote files, 20.10
transformation filter data, 19.14
transformation libraries
about, 15.5
accessing, 15.5.2
global shared library, 15.5.1
Oracle library, 15.5.1
types, 15.5.1
Transformation operator, 18.18
CHAR, 18.18, 18.18
CHAR result RTRIM, 18.18
data type, 18.18
RTRIM function, 18.18
transformation properties, 19.2
transformations
about, 15.4
adding to process flows, 21.21
administrative, 19.3, 19.3
character, 19.4
control center, 19.5
conversion, 19.6
custom, 15.4.1.2
custom example, 19.14
date, 19.7, 19.7
group by operation, 18.4
importing, 19.14
introduction to, 15
names, unique, 3.2.8.1
number, 19.8, 19.8
OLAP, 19.9
other (non-SQL), 19.10
predefined, 15.4.1.1
streams, 19.12
types of, 15.4.1
XML, 19.13
transition conditions, 20.8
Transition Editor, 20.8
transitions
conditions of, 20.8
in process flows, 20.6
transparent tables, 7.3.1
tree walking, 18.8.1
tuning
data profiling performance, 23.7
type 2 SCDs
about, 14.3.2
creating, using the Dimension Wizard, 14.6.1.6
updating, 14.3.2.2
type 3 SCDs
about, 14.3.3
creating, using the Dimension Wizard, 14.6.1.6

U

UK See constraints
unique key
UNION ALL set operation, 18.14
UNION set operation, 18.14
unique
key constraints, 13.4.1
transformation names, 3.2.8.1
Unpivot operator
about, 18.19
editing, 18.19.3
example, 18.19.1
expressions for, 18.19.3.7
groups, 18.19.3.2
input attributes, 18.19.3.4
input connections, 18.19.3.3
output attributes, 18.19.3.6
row locators, 18.19.2, 18.19.3.5
using, 18.19.3
updating
source definitions, 4.5.2
target schema, 25.3
user-defined activities, 21.22
user-defined types
creating, 13.12
overview, 13.12
utilities
activities, 21.1.2

V

validating
about, 12.3
data objects, 12.3
editing invalid objects, 12.3.1
validation
about, 12.3
editing invalid objects, 12.3.1
errors, 28.1
VARCHAR data type, 13.1.1
VARCHAR2 data type, 13.1.1
variables
substitution, 21.11.2
Varray Iterator Operator, 17.3.15
varrays
creating, 13.12.5
editing, 13.12.6
overview, 13.12.4
versions
bridges, 10.1.2
Transfer Wizard, 10.1.2
view definitions, 13.8.3
viewing
data, 13.2.1
data auditor error tables, 27.5.14, 27.5.14
data objects, 13.2.1
views, 13.8
attribute sets, adding, 13.8.3.4
attribute sets, deleting, 13.8.3.4
attribute sets, editing, 13.8.3.4
columns, adding, 13.8.3.2
columns, defining, 13.8.2.2
columns, deleting, 13.8.3.2
columns, editing, 13.8.3.2
configuring, 13.13.5
constraints, adding, 13.8.3.3
constraints, deleting, 13.8.3.3
constraints, editing, 13.8.3.3
defining, 13.8.2
editing, 13.8.3
materialized, 17.3.12
naming, 13.8.2.1
renaming, 13.8.3.1

W

wait activity, 21.23
WB_ABORT function, 19.3.1
WB_CAL_MONTH_NAME function, 19.7.1
WB_CAL_MONTH_OF_YEAR function, 19.7.2
WB_CAL_MONTH_SHORT_NAME function, 19.7.3
WB_CAL_QTR function, 19.7.4
WB_CAL_WEEK_OF_YEAR function, 19.7.5
WB_CAL_YEAR function, 19.7.6
WB_CAL_YEAR_NAME function, 19.7.7
WB_COMPILE_PLSQL transformation, 19.3.2
WB_DATE_FROM_JULIAN function, 19.7.8
WB_DAY_NAME function, 19.7.9
WB_DAY_OF_MONTH function, 19.7.10
WB_DAY_OF_WEEK function, 19.7.11
WB_DAY_OF_YEAR function, 19.7.12
WB_DAY_SHORT_NAME function, 19.7.13
WB_DECADE function, 19.7.14
WB_DISABLE_ALL_CONSTRAINTS, 19.3.3
WB_DISABLE_ALL_TRIGGERS, 19.3.4
WB_DISABLE_CONSTRAINT, 19.3.5
WB_DISABLE_TRIGGER, 19.3.6
WB_ENABLE_ALL_CONSTRAINTS, 19.3.7
WB_ENABLE_ALL_TRIGGERS, 19.3.8
WB_ENABLE_CONSTRAINT, 19.3.9
WB_ENABLE_TRIGGER, 19.3.10
WB_HOUR12 function, 19.7.15
WB_HOUR12MI_SS function, 19.7.16
WB_HOUR24 function, 19.7.17
WB_HOUR24MI_SS function, 19.7.18
WB_IS_DATE function, 19.7.19
WB_IS_NUMBER function, 19.8.3
WB_IS_SPACE function, 19.4.3
WB_JULIAN_FROM_DATE function, 19.7.20
WB_LOOKUP_CHAR function, 19.4.1, 19.4.2
WB_LOOKUP_NUM function, 19.8.1, 19.8.2
WB_MI_SS function, 19.7.21
WB_OLAP_AW_PRECOMPUTE, 19.9.1
WB_OLAP_LOAD_CUBE, 19.9.2
WB_OLAP_LOAD_DIMENSION, 19.9.3
WB_OLAP_LOAD_DIMENSION_GENUK, 19.9.4
WB_RT_GET_ELAPSED_TIME function, 19.5.1
WB_RT_GET_JOB_METRICS function, 19.5.2
WB_RT_GET_LAST_EXECUTION_TIME, 19.5.3
WB_RT_GET_MAP_RUN_AUDIT function, 19.5.4
WB_RT_GET_NUMBER_OF_ERRORS function, 19.5.5
WB_RT_GET_NUMBER_OF_WARNINGS function, 19.5.6
WB_RT_GET_PARENT_AUDIT_ID function, 19.5.7
WB_RT_GET_RETURN_CODE function, 19.5.8
WB_RT_GET_START_TIME function, 19.5.9
WB_TRUNCATE_TABLE, 19.3.11
WB_WEEK_OF_MONTH function, 19.7.22
WB_XML_LOAD, 19.13.1
WB_XML_LOAD_F, 19.13.2
WHERE (in the Filter operator), 18.8
While Loop activity, 21.24
wizards
Create Collection Wizard, 3.3.1
Create Data Auditor Wizard, 23.9.1
Create Data Rule Folder Wizard, 23.8
Create Data Rule Wizard, 23.8.1
Create External Table Wizard, 8.6.1
Create Flat File Wizard, 8.2
Create Sequence Wizard, 13.11.2
Cube Wizard, 14.9.1
Dimension Wizard, 14.6.1
Flat File Sample Wizard, 8.4
Import Metadata Wizard, 4.4.1
Operator, 18.2.1
Pivot Wizard, 18.11.3
Time Dimension Wizard, 14.11.1
Transfer Wizard, 10.1
Unpivot Wizard, 18.19.3
welcome pages, displaying, 3.2.5
workareas, Designer 6i, 5.1
writing SQL expressions, 18.7

X

XML Transformations, 19.13
XMLFORMAT data type, 13.1.1
XMLTYPE data type, 13.1.1