Skip Headers
Oracle® Warehouse Builder Data Modeling, ETL, and Data Quality Guide
11g Release 2 (11.2)

E10935-05
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  Z 

A

about
consuming web services, 16.1.2.3
public web services, 16.1.3
publishing web services, 16.1.2.2
accessing
transformation libraries, 4.5.2
ACTIVE_DATE attribute
about, 6.2
in cubes, 6.2
activities
AND, 27.2
assign, 27.3
control, 27.1.3
data auditor monitor, 27.4
email, 27.6
Enterprise Java Beans, 27.5
file exists, 27.9
For Loop, 27.11
FORK, 27.10
ftp, 27.12
in process flows, 8.4.1
Java Class, 27.13
manual, 27.14
mapping, 27.15
OMBPlus, 27.17
OR, 27.18
OWB-specific, 27.1.1
route, 27.19
Set Status, 27.20
sqlplus, 27.21
start, 27.22
user-defined, 27.25
utility, 27.1.2
wait, 27.26
web service, 27.28
While Loop, 27.27
activity templates, 8.5
adding
groups to mappings, 26.2.2
mapping operators, 5.7
adding operators
Add Operator dialog box, 5.7.1
addresses, cleansing, 22.1
administrative transformations, 28.1.1
advanced queues
about, 2.11.3
configuring, 2.12.6
defining, 2.11.3
editing, 2.11.4
advantages
web services, 16.1.1
Aggregate function, 26.4.3
aggregating data, 26.4
Aggregator operator, 26.4
ALL, 26.4.3
DISTINCT, 26.4.3
analytic workspace, 3.2.3.1
AND activity, 27.2
Anydata Cast operator, 26.5, 26.5
applying
data rules, 19.2.5
assign activity, 27.3
attribute properties, setting, 25.2.2
attribute sets, 2.8
about, 2.8
creating, 2.8.1
editing, 2.8.2
tables, 2.2.1.6
attributes
connecting, 5.8.3
defining, 2.2.1.6
audit details, removing, 13.5.12, 13.5.13
auditing
CT mappings, 7.6
CT mappings, prerequisites, 7.6
deployments, 13
executions, 13
auto binding
dimensional objects, 3.2.1.2
rules, 3.3.4.9
steps, 3.2.1.2
auto solving
MOLAP cubes, 3.7.6.3

B

best practices
naming data objects, 2.1.3
BINARY_DOUBLE data type, 2.1.1
BINARY_FLOAT data type, 2.1.1
binding
about, 3.2.1.1
auto binding, 3.2.1.2
auto binding, rules, 3.3.4.9
auto binding, steps, 3.2.1.2
manual binding, 3.2.1.3
manual binding, steps, 3.2.1.3
unbinding, 3.2.1.4
when to perform, 3.2.1.1
BLOB data type, 2.1.1
building expressions, 26.3

C

calculated measures
about, 3.7.1
Calculated Measures Wizard
about, 3.7.5.5
CASS reporting, 22.1.3
CCA
starting, 7.4.7
stopping, 7.4.7
change data capture
commands, 7.7.2
performing using CT mappings, 7.7
changes
rolling out to the target schema, 12.6
CHAR data type, 2.1.1, 26.21, 26.21
character transformations, 28.1.2
check key constraints, 2.5.1
chunking, 25.2.15.2
cleansing
addresses, 22.1
names, 22.1
CLOB data type, 2.1.1
code generation
configuring target directories, 2.12.1.1
options, 24.2.2
code template mappings
See CT mappings
code template substitution methods
not supported in OWB, 29.4
supported in OWB, 29.3
code template tools
not supported in OWB, 29.2
supported in OWB, 29.1
code templates
prebuilt, 7.4.1
coding conventions, Preface
commit strategies
committing multiple mappings, 10.1.5
committing to multiple targets, 10.1.3.1
comparing process runs, 13.5.3
composite partitions about, 2.7.5
configuration parameters
ABAP extension, 2.12.1.3
ABAP run parameter file, 2.12.1.3
ABAP spool directory, 2.12.1.3
advanced queues, 2.12.6
archive directory, 2.12.1.5
base tables, 2.12.3.1
buffer cache, 2.12.2.5, 2.12.3.1
build, 2.12.3.1
data profiles, 18.2.5.1
data segment compression, 2.12.2.5, 2.12.3.1
DDL directory, 2.12.1.3
DDL extension, 2.12.1.3
DDL spool directory, 2.12.1.3
default index tablespace, 2.12.1.6
default object tablespace, 2.12.1.6
default rollback segment, 2.12.3.1
deployable, 2.12.3.1, 3.6, 3.9
deployment options, 3.9
dimension, 3.6
end of line, 2.12.1.2
error table name, 2.12.2.1, 2.12.3.1
error table only, 2.12.2.3, 2.12.3.1
for update, 2.12.3.1
hash partition tablespace list, 2.12.3.1
input directory, 2.12.1.5
invalid directory, 2.12.1.5
lib directory, 2.12.1.3
lib extension, 2.12.1.3
lib spool directory, 2.12.1.3
loader directory, 2.12.1.3
loader extension, 2.12.1.3
loader run parameter file, 2.12.1.3
local rollback segment, 2.12.3.1
location, 2.12.1.4
log directory, 2.12.1.5
logging mode, 2.12.2.5, 2.12.3.1
master rollback segment, 2.12.3.1
materialized view index tablespace, 3.9
materialized view tablespace, 3.9
next date, 2.12.3.1
overflow tablespace list, 2.12.2.6
parallel access mode, 2.12.2.4, 2.12.3.1
parallel degree, 2.12.2.4, 2.12.3.1
partition tablespace list, 2.12.2.6
PL/SQL directory, 2.12.1.3
PL/SQL extension, 2.12.1.3
PL/SQL Generation Mode, 2.12.1.1
PL/SQL run parameter file, 2.12.1.3
PL/SQL spool directory, 2.12.1.3
query rewrite, 2.12.3.1
queue propagations, 2.12.8
queue tables, 2.12.7
receive directory, 2.12.1.5
refresh, 2.12.3.1
refresh on, 2.12.3.1
row movement, 2.12.2.5
row-level dependency, 2.12.2.5
sequences, 2.12.5
sort directory, 2.12.1.5
source file operator, 24.2.6.2
SQLPlus directory, 2.12.1.3
SQLPlus extension, 2.12.1.3
SQLPlus run parameter file, 2.12.1.3
staging file directory, 2.12.1.3
start with, 2.12.3.1
statistics collection, 2.12.2.5
tablespace, 2.12.2.1, 2.12.2.7, 2.12.3.1
Tcl Directory, 2.12.1.3
using constraints, 2.12.3.1
work directory, 2.12.1.5
configuring
advanced queues, 2.12.6
cubes, 3.9
data auditors, 20.2.2
data objects, 1.2
data profiles, 18.2.5
dimensions, 3.6
flat file operators, 24.2.7
mapping sources and targets, 26.18.1
mappings, 5.11
master-detail mappings, 10.2.1.2
master-detail mappings, direct path load, 10.2.2
materialized views, 2.12.3
Name and Address server, 22.3.1
PL/SQL mappings, 10.1
queue propagations, 2.12.8
queue tables, 2.12.7
runtime parameters, 2.12
runtime parameters, SAP files, 7.2.1.3
SAP, loading type parameter, 7.2.1.2
sequences, 2.12.5
tables, 2.12.2
target modules, 2.12.1
transportable modules, 17.3.4
views, 2.12.4
configuring CT mappings
source file operator, 7.5.2
connecting
attributes, 5.8.3
groups, 5.8.2
operators, 5.8
connecting groups
connection options, 5.8.4.2
Mapping Connection Dialog box, 5.8.4
connecting operators
connection options, 5.8.4.2
Mapping Connection Dialog box, 5.8.4
connections, updating, 13.5.16
Constant operator, 25.2.3
constants, defining, 25.2.2
constraints
about, 2.5.1
check constraints, creating, 2.5.2.4
check key, about, 2.5.1
editing, 2.5.3
foreign key, about, 2.5.1
foreign key, creating, 2.5.2.2
primary key, about, 2.5.1
primary key, creating, 2.5.2.1
types, 2.5.1
unique key, about, 2.5.1
unique key, creating, 2.5.2.3
Construct Object operator, 25.2.4
control activities, 27.1.3
Control Center Agent
starting, 7.4.7
stopping, 7.4.7
Control Center reports, 13.4
control center transformations, 28.1.3
Control CTs
in CT mappings, 7.8
control rows
about, 3.3.6
conventional path loading
for master-detail relationships, 10.2.1.2
master-detail flat files, 10.2.1.2
conventions
coding, Preface
example, Preface
conversion transformations, 28.1.4
correlated commit, design considerations, 10.1.3.1
Create Cube Wizard
default values, 3.7.4
Create Dimension wizard
defaults used, 3.3.3
creating
attribute sets, 2.8.1
constraints, check constraints, 2.5.2.4
constraints, foreign key constraints, 2.5.2.2
constraints, unique key constraints, 2.5.2.3
CT mapping modules, 7.4.4
CT mappings, 7.4
cubes, using Cube Editor, 3.7.5
cubes, using wizard, 3.7.3
data auditors, 20.2.1
data profiles, 18.2.4
data rules, 19.2.3
dimensions, using Dimension Editor, 3.3.4
dimensions, using wizard, 3.3.2
display sets, 5.9.4.1
expressions, 26.3
indexes, 2.6.1
mappings, 5
physical objects, 2.12.1
PL/SQL types, 9.2.3, 9.2.3.3
pluggable mapping folders, 5.15.1.5
pluggable mappings, 5.15.1
primary key constraints, 2.5.2.1
process flows, 8.3.4
time dimensions, using the Time Dimension Wizard, 3.10.1
type 2 SCDs, 3.3.2.6
type 3 SCDs, 3.3.2.6
web service packages, 16.2.1
web services, based on URL, 16.3
web services, based on Warehouse Builder objects, 16.2.2
CT mapping modules
creating, 7.4.4
CT mappings, 5.1.1.4
about, 7.4
auditing, 7.6
auditing, prerequisites, 7.6
creating, 7.4
deploying, 7.4.10
executing, 7.4.11
generated scripts, 7.4.9
generating, 7.4.9
moving data from heterogeneous databases, 7.10
performing change data capture, 7.7
performing ETL, 7.4.3
sample generated code, 7.4.9.1
types, 7.4
usage, 5.1.1.4, 7.4
using Control CTs, 7.8
using Oracle Target CTs, 7.9
validating, 7.4.8
viewing execution results, 7.4.12
Cube operator, 25.2.5
cubes
about, 3.1.3
ACTIVE_DATE attribute, 6.2
auto solving, MOLAP cubes, 3.7.6.3
calculated measures, 3.7.1
Calculated Measures Wizard, 3.7.5.5
calculated measures, types, 3.7.1
compression, defining, 3.7.5.3.1
configuring, 3.9
creating, using Cube Editor, 3.7.5
creating, using wizard, 3.7.3
deployment options, 3.2.4
deployment options, Deploy Data Object Only, 3.2.4
deployment options, Deploy to Catalog Only, 3.2.4, 3.2.4
dimensionality, 3.7.3.3
editing, 3.8
example, 3.7.2
loading data into, 6.2.1
loading, using type 2 slowly changing dimensions, 6.2
measures, creating, 3.7.3.4
orphan management policy, 3.7.5.7
parallel solving, 3.7.6.6
partitioning, along dimension, 3.7.5.3.1
performing ETL, 6.2
physical bindings, 3.7.5.8
ragged data, 3.7.6.1
solving cube measures, 3.7.6.4
solving, independent of loading, 3.7.6.5
sparsity, defining, 3.7.5.3.1
sparsity, guidelines, 3.7.5.3.1
storing, 3.7.3.2
custom transformations
about, 4.4.1.2
defining, 9.2
editing, 9.3

D

data
aggregating, 26.4
cleansing, 22.1
test, 5.19.4
viewing, 2.1.4
data auditor monitor activities, 27.4
data auditors
configuring, 20.2.2
creating, 20.2.1
granting privileges on error tables, 20.2.4.1
using, 20.2.3
viewing error tables, 13.5.14, 20.2.4
data flow operators, 26.1
Data Generator operator, 25.2.6
data objects
about, 2.1
advanced queues, 2.11
best practices for naming, 2.1.3
data type for columns, 2.1.1
defining, 2
dimensional objects, implementing, 3.2
generating, 1.4
identifying deployment location, 13.5.6
list, 2.1
monitoring data quality, 20.2
naming conventions, 2.1.3
overview, 2.1
sequences, 2.9
SQL Server and IBM DB2, 2.13
used in map run, 13.5.7
validating, 1.3
viewing, 2.1.4
viewing data, 2.1.4
data objects, generating, saving scripts, 1.4.2
data profile
adding objects, 18.2.9
Data Profile Editor
components, 18.1.4
data profiles
adding data objects, 18.2.9.1
configuration parameters, 18.2.5.1
configuring, 18.2.5
creating, 18.2.4
data profiling
generating corrections, 21.2
performance tuning, 18.3
performing, 18.2
steps, 18.2.3
viewing corrections, 21.2.6
viewing results, 18.2.7
data quality
Match Merge operator, 23.1
data rules, 2.2.1.7
about, 19.1
applying, 19.2.5
applying to ETL mappings, 19.2.6
creating, 19.2.3
deriving, 19.2.2
editing, 19.2.4
types, 19.1.1
using, 19.2
data transformation
about, 4.1
data types
list of supported, 2.1.1
Data Viewer, 2.1.4, 2.1.4
Data Watch and Repair for MDM, performing, 18.4
DATE data type, 2.1.1
date transformations, 28.1.5, 28.1.5
DB2
extracting data using CT mappings, 7.10.1
debugging
map runs, 13.5.4
mappings, 5.19
processes, 13.5.2
starting point, 5.19.7.3
Deduplicator operator, 26.6, 26.6
DISTINCT, 26.6
default deployment time setting, 13.5.8
defining
advanced queues, 2.11.3
constants, 25.2.2
cube sparsity, 3.7.5.3.1
data objects, 2
dimensional objects, 3
error tables, 2.1.5.1
ETL process for SAP objects, 7.2
execution units, 7.4.6
hash by quantity partitions, 2.7.3
hash partitions, 2.7.2
indexes, 2.2.1.4
list partitions, 2.7.4
mappings, 5
materialized views, 2.4.1
process flows, 8.3
queue propagations, 2.11.5
queue tables, 2.11.1
range partitions, 2.7.1
schedules, 11.2
sequences, 2.9.2
SQL Server and IBM DB2 data objects, 2.13
tables, 2.2.1
test data, 5.19.4
type 2 SCDs, 3.4.1
type 3 SCDs, 3.4.3
views, 2.3.1, 2.3.2
defining indexes, 2.2.1.4
defining tables, 2.2.1
definitions
transportable modules, 17.3.3.6
deleting
groups from mappings, 26.2.2
Deploy All, 3.2.4
deploying
about, 12.1.1
CT mappings, 7.4.10
data objects, 12.3
deployment actions, 12.1.1.1
deployment errors, 15.1
deployment results, 12.3.4
deployment status, 12.1.1.2
process flows, 8.1.1
reporting on, 13.4, 13.4.1
tables in transportable modules, 17.3.4.1
transportable module, 17.3.5
web services, 16.2.5
web services, prerequisites, 16.2.5
deployment actions, 12.1.1.1
deployment and execution
steps, 12.2
deployment options
Deploy All, 3.2.4
Deploy to Catalog Only, 3.2.4
deployment reports, 13.4, 13.4.1
deployment time settings, 13.5.8
deployments
auditing, 13
identifying, 13.5.5
deriving
data rules, 19.2.2
Design Center
in Repository Browser, 13.3
designing
process flows, 8
target schemas, 1.1
target schemas, dimensional, 1.1.3
target schemas, relational, 1.1.2
diagrams
impact analysis, 14.1.2
lineage, 14.1.2
Dimension operator, 25.2.7
dimensional object
deployment options, Deploy All, 3.2.4
dimensional objects
about, 3.1
binding, 3.2.1.1
creating, about, 3.1
defining, 3
deployment options, Data Objects Only, 3.2.4
deployment options, Deploy to Catalog Only, 3.2.4
implementing, about, 3.2
orphan management policy, 3.1.4
unbinding, 3.2.1.4
dimensions
about, 3.1.1
binding, 3.3.4.9
configuring, 3.6
control rows, 3.3.6
creating, using Dimension Editor, 3.3.4
creating, using wizard, 3.3.2
default settings, using wizard, 3.3.3
deployment options, 3.2.4
deployment options, Deploy Data Object Only, 3.2.4
deployment options, Deploy to Catalog Only, 3.2.4
determining number of rows, 3.3.6.1
dimension attributes
creating, 3.3.2.3
editing, 3.5
error tables, 3.1.4.3
example, 3.3.1
extracting data from, 6.1.3.1
hierarchies, creating, 3.3.2.4, 3.3.4.5
level attributes, creating, 3.3.2.5
levels, creating, 3.3.2.4
linking to fact data, 3.3.6
loading data, 6.1.1.1
orphan row management, 3.1.4.1
loading, example, 6.1.1.1
orphan management policy, specifying, 3.3.4.7
performing ETL, 6.1
removing data, 6.1.4
orphan row management, 3.1.4.2
removing data, example, 6.1.5
ROLAP dimension limitations, 3.3.5
specifying default parent, 3.3.4.8
storing, 3.3.2.2
surrogate identifiers, 3.1.1.1
direct path loading
for master-detail relationships, 10.2.2
master-detail flat files, 10.2.2
display sets
creating, 5.9.4.1
defined, 5.9.4
DISTINCT
in the Aggregator operator, 26.4.3
in the Deduplicator operator, 26.6
DML error logging
about, 15.2
enabling, 15.2.2
in ETL, 15.2.2.1
limitations, 15.2.3
dynamic population
time dimensions, 3.11.1
dynamically populating, 3.11.1

E

editing
advanced queues, 2.11.4
attribute sets, 2.8.2
constraints, 2.5.3
cubes, 3.8
data rules, 19.2.4
dimensions, 3.5
invalid objects, 1.3.2
materialized views, 2.4.2
PL/SQL types, 9.3.2
queue propagations, 2.11.6
queue tables, 2.11.2
schedules, 11.2.1
sequences, 2.9.3
table definitions, 2.2.2
time dimensions, 3.10.3
transformation properties, 9.3
transportable modules, 17.4
views, 2.3.2
effective date
about, 3.1.2
mapping source attributes, 6.1.1.2
email activity, 27.6
enabling
DML error logging, 15.2.2
hierarchy versioning, 3.1.2.2
Enterprise Java Beans activity, 27.5
error logs
interpreting error logs, 15.1
error tables, 3.1.4.3
about, 2.1.5, 15.2.1
columns, 2.1.5.2
defining, 2.1.5.1
granting privileges, 20.2.4.1
ETL
improving runtime performance, 10
ETL objects
scheduling, 11
example
cubes, 3.7.2
dimensions, 3.3.1
type 2 slowly changing dimension, 3.1.2.1
type 3 slowly changing dimension, 3.1.2.3
example conventions, Preface
examples
checking data constraints using CT mappings, 7.8.1
consuming web services in process flows, 16.8.2
extracting data from IBM DB2 using CT mappings, 7.10.1
integrating web services with Oracle BPEL Process Manager, 16.8.3
loading data into Type 2 SCDs, 6.1.2
loading data into Type 3 SCDs, 6.1.1.3
loading dimensions, 6.1.1.1
loading transaction data, 5.13
performing change data capture using CT mappings, 7.7
publishing mappings as web services, 16.8.1
removing data from dimensions, 6.1.5
using Oracle Target CTs, 7.9.1
executing
CT mappings, 7.4.11
mappings from SQL*Plus, 10.1.5
reports, 13.4, 13.4.2
web services, using browser, 16.4.2
web services, using Control Center Manager, 16.4.1
execution
about, 12.1.2
auditing, 13
errors, 15.1
execution reports, 13.4, 13.4.2
execution units
adding operators, 7.4.6.3
creating default execution units, 7.4.6.7
default code templates, 7.4.6.8
defining, 7.4.6
removing, 7.4.6.6
removing operators, 7.4.6.5
execution view
mapping editor, 5.3.3
menu, 7.4.6.1
toolbar, 7.4.6.1
Expand Object operator, 25.2.8
expiration date
about, 3.1.2
Expression Builder
about, 26.3
opening, 26.3.1
Expression operator, 26.7, 26.7
expressions, creating, 26.3
External Table operator, 25.2.9
extracting
data from DB2 into Oracle Database, 7.10.1
dimension data, 6.1.3.1
type 2 slowly changing dimension data, 6.1.3.2
type 3 slowly changing dimension data, 6.1.3.3
extracting from master-detail flat files, 10.2.1, 10.2.1.2

F

fast refresh, 2.12.3.3
File Exists activity, 27.9
file transfer
in process flows, 8.10
Filter operator, 26.8, 26.8, 26.8
filters, with a transform, 9.4
first class objects
about, 2.1.2.1
Flat File operator, 25.4.1
flat files
configuration, 24.2.7
configuring master-detail mappings, 10.2.2
extracting master and detail records, 10.2.1.2
importing master-detail flat files, 10.2.1.2
mapping, 7.1
master-detail mappings, post-update scripts for direct path loads, 10.2.2
master-detail, example, 10.2.1
master-detail, extracting from, 10.2.1
master-detail, operations after initial load, 10.2.1.4
variable names, in process flows, 8.9
FLOAT data type, 2.1.1
For Loop activity, 27.11
foreign key constraints, 2.5.1
foreign keys, ensuring referential integrity, 10.1.6
FORK activity, 27.10
FTP
using in process flows, 8.10
ftp activity, 27.12
full outer joins, 26.9.1.4, 26.9.2
functions
Aggregate, 26.4.3
as transformations, 4.4.1.2
defining, 9.2
editing, 9.3.1

G

generating
data objects, 1.4
transportable module, 17.3.5
web services, 16.2.4
generating corrections, 21.2
generation
errors, 15.1
saving scripts, 1.4.2
viewing results, 1.4.1
viewing scripts, 1.4.1
Group By clause, 26.4.1
groups
adding to mappings, 26.2.2
connecting, 5.8.2
in LIA diagrams, 14.3.3
removing from mappings, 26.2.2

H

hash by quantity partitions
about, 2.7.3
defining, 2.7.3
hash partitions
about, 2.7.2
defining, 2.7.2
Having clause, 26.4.2
hierarchies
creating, 3.3.2.4, 3.3.4.5
hierarchy versioning
about, 3.1.2.2
enabling, 3.1.2.2
householding, 23.1, 23.1, 23.2.3

I

IBM DB2 data objects
naming rules, 2.13.1
impact analysis
rolling out changes to target schema, 12.6
impact analysis diagrams, 14.1.2
implementation
dimensional objects, MOLAP, 3.2.3
dimensional objects, relational, 3.2.1
dimensional objects, ROLAP, 3.2.2
dimensional objects, ROLAP with MVs, 3.2.2
implementing
dimensional objects, 3.2
reporting on, 13.3.3.3
importing
master-detail flat files, 10.2.1.2
transformations, 9.4
improving runtime performance, 10
index partitioning, 2.6.1, 2.7.6
local index, 2.7.6
index partitions
about, 2.7.6
indexes
about, 2.6
creating, 2.6.1
defining, 2.2.1.4
types, 2.6.1
input signature, 5.15.1.3
installation
errors, 15.1
INTEGER data type, 2.1.1
INTERVAL DAY TO SECOND data type, 2.1.1
INTERVAL YEAR TO MONTH data type, 2.1.1

J

Java Class activity, 27.13
join conditions
default, 26.9.1.2
foreign keys, 26.9.1.2
join input roles, 26.9.2, 26.9.2.1
Joiner operator, 26.9, 26.9, 26.9.1.2, 26.9.1.3, 26.9.1.4, 26.9.2
join conditions, 26.9.1.1
with SAP Sources, 26.9.1.8
joining multiple row sets, 26.9
joins, full outer, 26.9.1.3, 26.9.1.4, 26.9.1.4, 26.9.2, 26.9.2.1
joins, left outer, 26.9.2.1
joins, outer, 26.9.1.3
joins, right outer, 26.9.2.1

K

Key Lookup operator, 26.12

L

Language parameter
SAP, 7.2.1.3
LCR Cast operator, 26.10
LCR Splitter operator, 26.11
limitations
prebuilt code templates, 7.4.1.1
lineage diagrams, 14.1.2
list partitions
about, 2.7.4
defining, 2.7.4
example, 2.7.4
loading
conventional path for master-detail targets, 10.2.1.2
cubes, 6.2.1
cubes, using type 2 slowly changing dimensions, 6.2
data from materialized view, 25.2.12
dimension data, 6.1.1.1
dimension data, example, 6.1.1.1
direct path for master-detail targets, 10.2.2
master and detail records, 10.2.1.2
master-detail relationships, 10.2.1.2, 10.2.2
master-detail relationships, direct path, 10.2.2
transaction data, 5.13
type 2 slowly changing dimensions, 6.1.1.2
type 2 slowly changing dimensions, example, 6.1.2
type 3 slowly changing dimensions, 6.1.1.3
type 3 slowly changing dimensions, example, 6.1.1.3
loading types, 25.2.1.6
for SAP, 7.2.1.2
locations
data objects deployed to, 13.5.6
of transportable modules, 17.3.2
unregistering, 13.5.15
updating connection details, 13.5.16
logs
interpreting error logs, 15.1
LONG data type, 2.1.1
LONG RAW data type, 2.1.1
Lookup operator, 26.12

M

main procedure, 10.1.5
management reports, 13.4, 13.4.3
manual activity, 27.14
manual binding
dimensional objects, 3.2.1.3
steps, 3.2.1.3
map runs, 13.5.4, 13.5.7
mapping activity, 27.15
mapping debugger
restrictions, 5.19.1
mapping editor
execution view, 5.3.3
logical view, 5.3.2
mapping operators
about, 4.3
adding, 5.7
Aggregator operator, 26.4
Anydata Cast, 26.5
connecting, 5.8
Constant, 25.2.3
Construct Object, 25.2.4
Cube, 25.2.5
Data Generator, 25.2.6
Deduplicator, 26.6
Dimension, 25.2.7
editing, 5.9
Expand Object, 25.2.8
Expression, 26.7
External Table, 25.2.9
Filter, 26.8
Flat File, 25.4.1
Joiner, 26.9
LCR Cast, 26.10
LCR Splitter, 26.11
Lookup, 26.12
Mapping Output Parameter, 25.2.11
Match Merge, 23.1
Materialized View, 25.2.12
Name and Address, 22.1
Pivot, 26.13
Post-Mapping Process, 26.14
Pre-Mapping Process, 26.15
Queue, 25.2.13
Sequence, 25.2.14
Set Operation, 26.16
Sorter, 26.17
Splitter operator, 26.18
Subquery Filter, 26.19
Table, 25.2.15
Table Function, 26.20
Transformation, 26.21
types of, 4.3.1
Unpivot, 26.22
Varray Iterator, 25.2.16
View, 25.2.17
Mapping Output Parameter operator, 25.2.11
mapping output parameters, 25.2.11
mappings
about, 4.2, 5.1
accessing data via transportable modules, 17.3.6
adding self joins, 26.8.1
applying data rules, 19.2.6
configuring, 5.11, 10.1
configuring master-detail, 10.2.1.2
creating, 5
debugging, 5.19
defining, 5
executing from SQL*Plus, 10.1.5
for flat files, 7.1
for PEL, 10.3.2
groups, 26.2.2
loading targets, order in which, 5.10.1
master-detail mappings, 10.1.6
naming conventions, 5.6.1, 8.5.1
operators, 4.3
performing ETL, 5.5
PL/SQL mappings, 10.1
PL/SQL mappings, example, 5.4
runtime parameters, 24.2.1
searching, attributes, 5.18
searching, groups, 5.18
searching, operators, 5.18
sources and targets, configuring, 26.18.1
spotlighting operators, 5.17.3
target load order, 5.10.1
types, 5.1.1
types. SAP ABAP mappings, 5.1.1.3
types, CT mappings, 5.1.1.4
types, PL/SQL mappings, 5.1.1.1
types, SQL*Loader, 5.1.1.2
ungrouping operators, 5.17.2
using web services, 16.6
master-detail flat files
as sources, about, 10.2.1
configuring mappings, 10.2.1.2
configuring mappings, direct path load, 10.2.2
example of a master-detail flat file, 10.2.1
extracting from, 10.2.1.2
extracting from, using conventional path load, 10.2.1.2
extracting from, using direct path load, 10.2.2
importing and sampling, 10.2.1.2
operations after initial load, 10.2.1.4
performance, 10.2.1.2, 10.2.2
post-update scripts for direct path loads, 10.2.2
RECNUM, 10.2.2
sample mapping, conventional path loading, 10.2.1.2
sample mapping, direct path loading, 10.2.2
Match Merge operator, 23.1
Match rules
multiple match rules, 23.1.5.2
transitive match rules, 23.1.5.3
match rules
address match rules, 23.1.9
conditional match rules, 23.1.4
custom match rules, 23.1.10
firm match rules, 23.1.8
person match rules, 23.1.7
weight match rules, 23.1.6
matching
transitive, 23.1.5.3
Match-Merge operator
custom rules, 23.1.17
design considerations, 23.2.2, 23.2.2
example, 23.1.5
match rules, 23.1.3
merge rules, 23.1.11
restrictions, 23.2.2.1
using, 23.2.1
Materialized View operator, 25.2.12
materialized views
about, 2.4
attribute sets, adding, 2.4.2.4
attribute sets, deleting, 2.4.2.4
attribute sets, editing, 2.4.2.4
columns, adding, 2.4.2.2
columns, deleting, 2.4.2.2
columns, editing, 2.4.2.2
configuring, 2.12.3
constraints, adding, 2.4.2.3
constraints, deleting, 2.4.2.3
constraints, editing, 2.4.2.3
defining, 2.4.1
defining attribute sets, 2.4.1.6
defining columns, 2.4.1.1
defining constraints, 2.4.1.3
defining data rules, 2.4.1.7
defining indexes, 2.4.1.4
defining partitions, 2.4.1.5
defining query, 2.4.1.2
editing, 2.4.2
fast refresh, 2.12.3.3
loading data from, 25.2.12
loading data into, 25.2.12
renaming, 2.4.2.1
update definitions, 2.4.2
MDSYS.SDO_DIM_ARRAY data type, 2.1.1
MDSYS.SDO_DIM_ELEMENT data type, 2.1.1
MDSYS.SDO_ELEM_INFO_ARRAY data type, 2.1.1
MDSYS.SDO_GEOMETRY data type, 2.1.1
MDSYS.SDO_ORDINATE_ARRAY data type, 2.1.1
MDSYS.SDO_POINT_TYPE data type, 2.1.1
MDSYS.SDOAGGRTYPE data type, 2.1.1
Merge rules, 23.1.17
metadata
dependencies, 14
import and export errors, 15.1
metadata dependencies, diagrams of, 14.1
Metadata Dependency Manager, 14.1
minus, in the Set Operation operator, 26.16
modules
configuring target modules, 2.12.1
process flows, 8.1.1, 8.3.2
MOLAP implementation
about, 3.2.3
dimensional objects, 3.2.3
monitoring
data objects, using auditors, 20.2.3
data quality, 20.2
monitoring process runs, 13.5.10
moving data from heterogeneous databases
using CT mappings, 7.10
multiple-record-type flat files
master-detail structure, 10.2.1
master-detail structure, example of, 10.2.1
multitable INSERT, 26.18.1

N

Name and Address
country postal certifications, Australia, 22.1.3.3
country postal certifications, Canada, 22.1.3.2
country postal certifications, United States, 22.1.3.1
operator, 22.1
purchasing license, 22.1
Name and Address operator, 22.1
best practices, 22.1.6
CASS reporting, 22.1.3
enabling, 22.1
input roles, 22.1.4
output components, 22.1.5
Name and Address server, 22.3
configuring, 22.3.1
errors, 15.1
starting, 22.3.2
stopping, 22.3.2
names
cleansing, 22.1
flat files with variable names in process flows, 8.9
names and addresses, processing libraries, 22.3
naming conventions
data objects, 2.1.3
naming rules
IBM DB2 data objects, 2.13.1
SQL Server data objects, 2.13.2
navigating
Repository Browser, 13.3.1
NCHAR data type, 2.1.1
NCLOB data type, 2.1.1
nested tables
creating, 2.10.8
editing, 2.10.9
overview, 2.10.7
NUMBER data type, 2.1.1
number transformations, 28.1.6, 28.1.6
NVARCHAR2 data type, 2.1.1

O

object class definition
about, 2.1.2
object properties, report, 13.3.2
object types
creating, 2.10.2
editing, 2.10.3
overview, 2.10.1
objects
invalid objects, editing, 1.3.2
reports, 13.3.3
OLAP transformations, 28.1.7
OMBPlus activity, 27.17
opening
Expression Builder, 26.3.1
Repository Browser, 13.2
operating modes
row-based, 10.1.1.2
row-based (target only), 10.1.1.3
selecting a default mode, 10.1.1
set-based, 10.1.1.1
operator attributes, 5.8.3
operator editor
Input tab, 26.2.2
Input/Output tab, 26.2.2
Output tab, 26.2.2
Operator wizard, 26.2.1
operators
about, 4.1, 4.3
Aggregator, 26.4
Anydata Cast, 26.5, 26.5
connecting, 5.8
Constant, 25.2.3
Construct Object, 25.2.4
Cube, 25.2.5
data flow, 26.1
Data Generator, 25.2.6
Deduplicator, 26.6, 26.6
Dimension, 25.2.7
editing, 5.9
Expand Object, 25.2.8
Expression, 26.7, 26.7
External Table, 25.2.9
Filter, 26.8, 26.8
Flat File, 25.4.1
flat file, 24.2.7
Joiner, 26.9, 26.9
LCR Cast, 26.10
LCR Splitter, 26.11
Lookup, 26.12
Mapping Output Parameter, 25.2.11
Match Merge, 23.1
Materialized View, 25.2.12
Name and Address, 22.1, 22.1
Pivot, 26.13
pluggable mapping, 4.3.1.4
Post-Mapping Process, 26.14
Pre-Mapping Process, 26.15
pre/post processing, 4.3.1.3
Queue, 25.2.13
Sequence, 25.2.14
Set Operation, 26.16
Sorter, 26.17
source, 25.1
Splitter operator, 26.18
Subquery Filter, 26.19
Table, 25.2.15
Table Function, 26.20
target, 25.1
Transformation, 26.21
transformation, 4.3.1.2
Unpivot, 26.22
Varray Iterator, 25.2.16
View, 25.2.17
operators, mapping
adding, 5.7
connecting, 5.8
editing, 5.9
types of, 4.3.1
OR activity, 27.18
Oracle RAC, managing service nodes, 13.4.3.1
Oracle Target CTs
using in CT mappings, 7.9
ORDER BY
in the Sorter operator, 26.17
ordering
multiple targets, 10.1.6
orphan management policy, 3.1.4
cubes, 3.7.5.7
dimensions, 3.3.4.7
other (non-SQL) transformations, 28.1.8
outer joins, 26.9.1.3
output components
Name and Address operator, 22.1.5
output signature, 5.15.1.4

P

packages
as transformations, 4.4.1.2
defining, 9.2
editing, 9.3.1
process flows, 8.1.1, 8.3.3
parallel solving
cubes, 3.7.6.6
parameters
mapping output, 25.2.11
Partition Exchange Loading (PEL), 10.3
about, 10.3.1
configuring targets for, 10.3.5
mappings for, 10.3.2
performance considerations, 10.3.4
restrictions on, 10.3.5, 10.3.6
partitioning, index, 2.6.1, 2.7.6
partitions
about, 2.7
composite, 2.7.5
defining, 2.2.1.5
defining, hash by quantity partitions, 2.7.3
defining, list partitions, 2.7.4
defining, range partitions, 2.7.1
hash by quantity, 2.7.3
hash partitions, 2.7.2
index, 2.7.6
list, 2.7.4
subpartitions, creating, 2.7.5.2
types, 2.7
performing
Data Watch and Repair for MDM, 18.4
performing ETL
steps, 5.5
using cubes, 6.2
using dimensions, 6.1
using mappings, 5.5
Pivot operator, 26.13
editing, 26.13.3
example, 26.13.1
expressions for, 26.13.3.6
groups, 26.13.3.2
input attributes, 26.13.3.4
output attributes, 26.13.3.5
row locators, 26.13.2, 26.13.3.5
using, 26.13.3
PL/SQL mappings, 5.1.1.1, 10.1
example, 5.4
PL/SQL types
about, 9.2.3.1
as transformations, 4.4.1.2
creating, 9.2.3, 9.2.3.3
editing, 9.3.2
pluggable mapping folders
creating, 5.15.1.5
pluggable mapping operators, 4.3.1.4
pluggable mappings
about, 5.15
creating, 5.15.1
embedded, 5.15
reusable, 5.15
spotlighting operators, 5.17.3
ungrouping operators, 5.17.2
Post-Mapping Process operator, 26.14
prebuilt code templates, 7.4.1
limitations, 7.4.1.1
predefined transformations, 4.4.1.1
Pre-Mapping Process operator, 26.15
pre/post processing operators, 4.3.1.3
primary key constraints, 2.5.1
procedures
as transformations, 4.4.1.2
defining, 9.2
editing, 9.3.1
process flows
about, 8.1
activities in, 8.4.1
adding transformations to, 27.24
complex conditions in, 8.8
creating, 8.3.4
debugging, 13.5.2
defining, 8.3
deploying, 8.1.1
designing, 8
halting, 27.14
handling flat files with variable names, 8.9
modules, 8.1.1, 8.3.2
packages, 8.1.1, 8.3.3
scripting in, 27.21
starting, 27.23
subprocesses, 27.23
transferring remote files with FTP, 8.10
transitions, 8.6
using Enterprise Java Beans, 27.5
using Java classes, 27.13
using OMB*Plus, 27.17
using web services, 16.5
process runs
comparing, 13.5.3
debugging, 13.5.2
identifying recent, 13.5.1
monitoring, 13.5.10
rerunning, 13.5.9
terminating, 13.5.11
processes
debugging, 13.5.2
identifying recent, 13.5.1
running, 13.5.9
properties
for source operators, 25.2.1
for target operators, 25.2.1
object, 13.3.2
proxy settings
creating web services based on external URL, 16.3
public Oracle Custom library, 4.5.1
public Oracle Predefined library, 4.5.1
publishing objects
as web services, 16.2

Q

Queue operator, 25.2.13
queue propagations
about, 2.11.5
configuring, 2.12.8
defining, 2.11.5
editing, 2.11.6
queue tables
about, 2.11.1
configuring, 2.12.7
defining, 2.11.1
editing, 2.11.2
payload type, 2.11.1.1

R

range partitions
defining, 2.7.1
example, 2.7.1.1
RAW data type, 2.1.1
RECNUM attribute, 10.2.2
RECNUM columns, 10.2.2
records
extracting and loading master and detail records, 10.2.1.2
relationships between masters and details in flat files, 10.2.1
referential integrity, ensuring in mappings, 10.1.6
relating master and detail records, 10.2.1
relational implementation
about, 3.2.1
dimensional objects, 3.2.1
REMAINING_ROWS output group
in the Splitter operator, 26.18
remote files
transferring, 8.10
removing data
from dimensions, 6.1.4
from dimensions, example, 6.1.5
from slowly changing dimensions, 6.1.4
renaming
materialized views, 2.4.2.1
sequences, 2.9.3.1
tables, 2.2.2.1
views, 2.3.2.1
reordering table columns, 2.2.2.5
repeating schedules, 11.2.1.2
REPLICATE, 28.1.10.1
reporting
Control Center, 13.4
execution, 13.4, 13.4.2
implementation, 13.3.3.3
management, 13.4, 13.4.3
object properties, 13.3.2
on deployment, 13.4, 13.4.1
on objects, 13.3.3
reports
Control Center, 13.4
deployment, 13.4, 13.4.1
execution, 13.4, 13.4.2
implementation, 13.3.3.3
management, 13.4, 13.4.3
object, 13.3.3
object properties, 13.3.2
Repository Browser
about, 13.1.1
Control Center, 13.4
Design Center, 13.3
implementation reports, 13.3.3.3
logging in, 13.2.3
navigating, 13.3.1
object reports, 13.3.3
opening, 13.2
starting, 13.2.1
stopping, 13.2.1
Repository navigator, 13.3.1
restrictions
mapping debugger, 5.19.1
ROLAP implementation
about, 3.2.2
dimensional objects, 3.2.2
ROLAP with MVs implementation
about, 3.2.2
route activity, 27.19
row locators
in the Pivot operator, 26.13.2, 26.13.3.5
in the Unpivot operator, 26.22.2, 26.22.3.5
row-based, 10.1.1.2
row-based (target only), 10.1.1.3
row-based versus set-based
loading transaction data, 5.13
rows, filtering out, 26.8
RTRIM function
in the Transformation operator, 26.21
running
processes, 13.5.9
runtime parameters
SAP, 7.2.1.3
runtime parameters, configuring, 24.2.1
runtime performance, improving, 10

S

sampling
master-detail flat files, 10.2.1.2
SAP
and joins, 26.9.1.8
defining ETL process for SAP objects, 7.2
Language parameter, setting, 7.2.1.3
runtime parameters, setting, 7.2.1.3
SAP ABAP mappings, 5.1.1.3
SAP file physical properties
Data File Name, 7.2.1.3
File Delimiter for Staging File, 7.2.1.3
Nested Loop, 7.2.1.3
SAP System Version, 7.2.1.3
SQL Join Collapsing, 7.2.1.3
Staging File Directory, 7.2.1.3
Use Single Select, 7.2.1.3
SAP parameters
Language, 7.2.1.3
loading type, 7.2.1.2
runtime, 7.2.1.3
schedules
creating, 11.2
defining, 11.2
duration, 11.2.1.1
editing, 11.2.1
example, 11.2.2
repeating, 11.2.1.2
using, 11.2
scheduling
about, 11.1
ETL jobs, 12.4.3
ETL objects, 11
scripting
in process flows, 27.21
scripts
for FTP commands, 27.12.1, 27.12.3
searching
groups, in mappings, 5.18
operators, in mappings, 5.18
second class objects
about, 2.1.2.2
self joins, 26.8.1
Sequence operator, 25.2.14
sequences
configuring, 2.12.5
Create Sequence Wizard, 2.9.2
defining, 2.9.2
editing, 2.9.3
renaming, 2.9.3.1
service nodes, managing, 13.4.3.1
set based update, 10.1.1.1
Set Operation operator, 26.16
intersect, 26.16
minus, 26.16
union, 26.16
union all, 26.16
Set Status activity, 27.20
set-based mode, 10.1.1.1
set-based versus row-based
loading transaction data, 5.13
set-based versus row-based modes, 10.1.1
setting
a starting point, 5.19.7.3
attribute properties, 25.2.2
signatures
input, 5.15.1.3
output, 5.15.1.4
slowly changing dimensions
about, 3.1.2
additional attributes, 3.1.2
effective date, 3.1.2
expiration date, 3.1.2
hierarchy versioning, about, 3.1.2.2
hierarchy versioning, enabling, 3.1.2.2
previous attribute, about, 3.1.2
removing data, 6.1.4
triggering attributes, 3.1.2
type 2, 3.3.2.6
type 2, defining, 3.4.1
type 2, example, 3.1.2.1
type 2, requirements, 3.1.2.1
type 2, updating, 3.4.2
type 3, 3.3.2.6
type 3, defining, 3.4.3
type 3, example, 3.1.2.3
type 3, requirements, 3.1.2.3
solving
cube measures, 3.7.6.4
solving cubes
independent of loading, 3.7.6.5
Sorter operator, 26.17, 26.17
source file operator, 7.5.2
source operators, 25.1
sources
master-detail flat file sources, 10.2.1
master-detail flat files, 10.2.1
master-detail flat files, example, 10.2.1
Spatial Transformations, 28.1.9
specifying
orphan management policy, dimensions, 3.3.4.7
Splitter operator, 26.18, 26.18
spotlighting operators
mappings, 5.17.3
pluggable mappings, 5.17.3
SQL expressions, 26.7
SQL Server data objects
naming rules, 2.13.2
SQL*Loader mappings, 5.1.1.2
sqlplus activity, 27.21
Start activity, 27.22
starting
CCA, 7.4.7
Control Center Agent, 7.4.7
Name and Address server, 22.3.2
Repository Browser, 13.2.1
starting point, setting, 5.19.7.3
stopping
CCA, 7.4.7
Control Center Agent, 7.4.7
Name and Address server, 22.3.2
Repository Browser, 13.2.1
streams transformations, 28.1.10
subpartitions
creating, 2.7.5.2
subprocesses, to start process flows, 27.23
Subquery Filter operator, 26.19
substitution variables, 27.12.2
summarizing
data with a transformation, 26.4
surrogate identifiers
about, 3.1.1.1
usage, 3.1.1.1
surrogate keys
in the Key Lookup operator, 26.12
synchronization
mapping objects, advanced options, 5.12.3
synchronizing
operators, 5.12
operators, matching strategies, 5.12.3.1
web services, 16.5.3
workspace objects, 5.12
SYS.ANYDATA data type, 2.1.1
SYS.LCR$_ROW_RECORD data type, 2.1.1

T

table definitions
creating, 2.2.1
editing, 2.2.2
Table Function operator, 26.20
prerequisites, 26.20.1
using, 26.20
table functions
as transformations, 4.4.1.2
Table operator, 25.2.15
tables, 2.2.1.4, 2.2.1.7
attribute sets, 2.8
attribute sets, adding, 2.2.2.4
attribute sets, defining, 2.2.1.6
attribute sets, deleting, 2.2.2.4
attribute sets, editing, 2.2.2.4
chunking, 25.2.15.2
columns, adding, 2.2.2.2
columns, defining, 2.2.1.2
columns, deleting, 2.2.2.2
columns, editing, 2.2.2.2
configuring, 2.12.2
constraints, adding, 2.2.2.3
constraints, defining, 2.2.1.3
constraints, deleting, 2.2.2.3
constraints, editing, 2.2.2.3
data rules, 2.2.1.7
defining, 2.2.1, 2.2.1
defining partitions, 2.2.1.5
naming, 2.2.1.1
renaming, 2.2.2.1
reordering columns, 2.2.2.5
tables (defined), 2.2
target load ordering, 10.1.6
target modules
configuring, 2.12.1
target operators, 25.1
loading types, 25.2.1.6
properties for, 25.2.1
target schemas
designing, 1.1
designing, dimensional, 1.1.3
designing, relational, 1.1.2
rolling out changes, 12.6
targets
defining load orders, 10.1.6
multiple targets in a mapping, 10.1.3.1
multiple targets in mappings, 26.18, 26.18.1
templates
activity, 8.5
test data, defining, 5.19.4
Time Dimension Wizard
defaults, 3.10.2
time dimensions, 3.11.1
creating, using the Time Dimension Wizard, 3.10.1
data range, 3.10.1.3
editing, 3.10.3
levels, creating, 3.10.1.4
overlapping data population, 3.11.2
populating, 3.11
storing, 3.10.1.2
time settings, 13.5.8
TIMESTAMP data type, 2.1.1
TIMESTAMP WITH LOCAL TIMEZONE data type, 2.1.1
TIMESTAMP WITH TIMEZONE data type, 2.1.1
transaction data
loading, 5.13
transferring
remote files, 8.10
transformation filter data, 9.4
transformation libraries
about, 4.5
accessing, 4.5.2
public Oracle Custom library, 4.5.1
public Oracle Predefined library, 4.5.1
types, 4.5.1
Transformation operator, 26.21
CHAR, 26.21, 26.21
CHAR result RTRIM, 26.21
data type, 26.21
RTRIM function, 26.21
transformation operators, 4.3.1.2
about, 4.1
transformation properties, 9.3
transformations
about, 4.4
adding to process flows, 27.24
administrative, 28.1.1, 28.1.1
character, 28.1.2
control center, 28.1.3
conversion, 28.1.4
custom, 4.4.1.2
custom example, 9.4
date, 28.1.5, 28.1.5
group by operation, 26.4
importing, 9.4
introduction to, 9
number, 28.1.6, 28.1.6
OLAP, 28.1.7
other (non-SQL), 28.1.8
predefined, 4.4.1.1
streams, 28.1.10
types, 4.4.1
XML, 28.1.11
transforming data
about, 4.1
transition conditions, 8.8
Transition Editor, 8.8
transitions
conditions of, 8.8
in process flows, 8.6
transportable modules
about, 17.1.1
configuring, 17.3.4
definitions, 17.3.3.6
deploying, 17.3.5
editing, 17.4
generating, 17.3.5
locations for, 17.3.2
mapping, 17.3.6
using, 17.3
tree walking, 26.8.1
triggering attributes
about, 3.1.2
tuning
data profiling performance, 18.3
type 2 slowly changing dimensions
creating, using the Dimension Wizard, 3.3.2.6
effective date, mapping source attributes, 6.1.1.2
extracting data from, 6.1.3.2
loading data, 6.1.1.2
loading data, example, 6.1.2
updating, 3.4.2
type 3 slowly changing dimensions
creating, using the Dimension Wizard, 3.3.2.6
extracting data from, 6.1.3.3
loading data, 6.1.1.3
loading data, example, 6.1.1.3
types
calculated measures, 3.7.1
mappings, 5.1.1
transformations, 4.4.1
types of
transformation libraries, 4.5.1

U

UK See constraints
unique key
unbinding
dimensional objects, 3.2.1.4
ungrouping operators
mappings, 5.17.2
pluggable mappings, 5.17.2
UNION ALL set operation, 26.16
UNION set operation, 26.16
unique
key constraints, 2.5.1
Unpivot operator, 26.22
editing, 26.22.3
example, 26.22.1
expressions for, 26.22.3.7
groups, 26.22.3.2
input attributes, 26.22.3.4
input connections, 26.22.3.3
output attributes, 26.22.3.6
row locators, 26.22.2, 26.22.3.5
using, 26.22.3
updating
target schema, 12.6
UROWID data type, 2.1.1
user-defined activities, 27.25
user-defined types
overview, 2.10
using
transportable modules, 17.3
utilities
activities, 27.1.2

V

validating
about, 1.3
data objects, 1.3
editing invalid objects, 1.3.2
web services, 16.2.3
validation
about, 1.3
editing invalid objects, 1.3.2
errors, 15.1
viewing results, 1.3.1
VARCHAR data type, 2.1.1
VARCHAR2 data type, 2.1.1
variables
substitution, 27.12.2
Varray Iterator operator, 25.2.16
Varrays
creating, 2.10.5
editing, 2.10.6
overview, 2.10.4
View operator, 25.2.17
viewing
data, 2.1.4
data auditor error tables, 13.5.14
data objects, 2.1.4
data stored in data objects, 2.1.4
generation results, 1.4.1
generation scripts, 1.4.1
validation results, 1.3.1
views
about, 2.3
attribute sets, adding, 2.3.2.4
attribute sets, deleting, 2.3.2.4
attribute sets, editing, 2.3.2.4
columns, adding, 2.3.2.2
columns, defining, 2.3.1.2
columns, deleting, 2.3.2.2
columns, editing, 2.3.2.2
configuring, 2.12.4
constraints, adding, 2.3.2.3
constraints, deleting, 2.3.2.3
constraints, editing, 2.3.2.3
defining, 2.3.1
editing, 2.3.2
materialized, 25.2.12
renaming, 2.3.2.1

W

wait activity, 27.26
WB_ABORT function, 28.1.1.1
WB_CAL_MONTH_NAME function, 28.1.5.1
WB_CAL_MONTH_OF_YEAR function, 28.1.5.2
WB_CAL_MONTH_SHORT_NAME function, 28.1.5.3
WB_CAL_QTR function, 28.1.5.4
WB_CAL_WEEK_OF_YEAR function, 28.1.5.5
WB_CAL_YEAR function, 28.1.5.6
WB_CAL_YEAR_NAME function, 28.1.5.7
WB_COMPILE_PLSQL transformation, 28.1.1.2
WB_DATE_FROM_JULIAN function, 28.1.5.8
WB_DAY_NAME function, 28.1.5.9
WB_DAY_OF_MONTH function, 28.1.5.10
WB_DAY_OF_WEEK function, 28.1.5.11
WB_DAY_OF_YEAR function, 28.1.5.12
WB_DAY_SHORT_NAME function, 28.1.5.13
WB_DECADE function, 28.1.5.14
WB_DISABLE_ALL_CONSTRAINTS, 28.1.1.3
WB_DISABLE_ALL_TRIGGERS, 28.1.1.4
WB_DISABLE_CONSTRAINT, 28.1.1.5
WB_DISABLE_TRIGGER, 28.1.1.6
WB_ENABLE_ALL_CONSTRAINTS, 28.1.1.7
WB_ENABLE_ALL_TRIGGERS, 28.1.1.8
WB_ENABLE_CONSTRAINT, 28.1.1.9
WB_ENABLE_TRIGGER, 28.1.1.10
WB_HOUR12 function, 28.1.5.15
WB_HOUR12MI_SS function, 28.1.5.16
WB_HOUR24 function, 28.1.5.17
WB_HOUR24MI_SS function, 28.1.5.18
WB_IS_DATE function, 28.1.5.19
WB_IS_NUMBER function, 28.1.6.3
WB_IS_SPACE function, 28.1.2.3
WB_JULIAN_FROM_DATE function, 28.1.5.20
WB_LOOKUP_CHAR function, 28.1.2.1, 28.1.2.2
WB_LOOKUP_NUM function, 28.1.6.1, 28.1.6.2
WB_MI_SS function, 28.1.5.21
WB_OLAP_AW_PRECOMPUTE, 28.1.7.1
WB_OLAP_LOAD_CUBE, 28.1.7.2
WB_OLAP_LOAD_DIMENSION, 28.1.7.3
WB_OLAP_LOAD_DIMENSION_GENUK, 28.1.7.4
WB_RT_GET_ELAPSED_TIME function, 28.1.3.1
WB_RT_GET_JOB_METRICS function, 28.1.3.2
WB_RT_GET_LAST_EXECUTION_TIME, 28.1.3.3
WB_RT_GET_MAP_RUN_AUDIT function, 28.1.3.4
WB_RT_GET_NUMBER_OF_ERRORS function, 28.1.3.5
WB_RT_GET_NUMBER_OF_WARNINGS function, 28.1.3.6
WB_RT_GET_PARENT_AUDIT_ID function, 28.1.3.7
WB_RT_GET_RETURN_CODE function, 28.1.3.8
WB_RT_GET_START_TIME function, 28.1.3.9
WB_TRUNCATE_TABLE, 28.1.1.11
WB_WEEK_OF_MONTH function, 28.1.5.22
WB_XML_LOAD, 28.1.11.1
WB_XML_LOAD_F, 28.1.11.2
web service packages
creating, 16.2.1
web services
about, 16.1
accessing securely, 16.7
advantages, 16.1.1
consuming, about, 16.1.2.3
creating, based on URL, 16.3
creating, based on Warehouse Builder objects, 16.2.2
deploying, 16.2.5
deployment locations, 16.2.5
executing, using browser, 16.4.2
executing, using Control Center Manager, 16.4.1
generating, 16.2.4
prerequisites for deploying, 16.2.5
public web services, about, 16.1.3
publishing, about, 16.1.2.2
setting up secure access to external servers, 16.7.2
synchronizing, 16.5.3
using in mappings, 16.6
using in process flows, 16.5
validating, 16.2.3
web services based on external URL
proxy settings, 16.3
WHERE (in the Filter operator), 26.8
While Loop activity, 27.27
wizards
Create Cube Wizard, 3.7.3
Create Data Auditor Wizard, 20.2.1
Create Data Rule Folder Wizard, 19.2.1
Create Data Rule Wizard, 19.2.3
Create Dimension Wizard, 3.3.2
Create Sequence Wizard, 2.9.2
Operator, 26.2.1
Pivot Wizard, 26.13.3
Time Dimension Wizard, 3.10.1
Unpivot Wizard, 26.22.3
writing SQL expressions, 26.7

X

XML Transformations, 28.1.11
XMLFORMAT data type, 2.1.1
XMLTYPE data type, 2.1.1

Z

LIA See lineage and impact analysis