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

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