Index

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

A

ABS function, 27.6.1

accessing

Metadata Loader, 33.1.3

transformation libraries, 9.2.2

ACOS function, 27.6.2

activities

AND, 22.1.4

assign, 22.1.5

control, 22.1.3

data auditor monitor, 22.1.6

email, 22.1.7

file exists, 22.1.10

For Loop, 22.1.12

FORK, 22.1.11

ftp, 22.1.13

in process flows, 7.3.6

manual, 22.1.14

mapping, 22.1.15

OR, 22.1.17

OWB-specific, 22.1.1

route, 22.1.18

Set Status, 22.1.19

sqlplus, 22.1.20

start, 22.1.21

user-defined, 22.1.24

utility, 22.1.2

wait, 22.1.25

While Loop, 22.1.26

activity templates, 7.3.5

ADD_MONTHS function, 27.5.1

adding

groups to mappings, 26.2.2

mapping operators, 6.4

addresses, cleansing, 10.3.2

administrative transformations, 27.1

advanced attribute set properties, 12.7.1

Aggregate function, 26.4.3

aggregating data, 26.4

Aggregator operator, 26.4

ALL, 26.4.3

DISTINCT, 26.4.3

alternative sort orders

creating, 15.1.11

editing, 15.1.12

analytic workspace, 4.11.2.3.1

AND activity, 22.1.4

Anydata Cast Operator, 26.5

Anydata Cast operator, 26.5

ASCII function, 27.2.1

ASCIISTR function, 27.4.1

ASIN function, 27.6.3

assign activity, 22.1.5

assigning

icons to objects, 34.5.2

associating objects, 34.3.3

ATAN function, 27.6.4

ATAN2 function, 27.6.5

attribute analysis, 10.2.2.1

attribute properties, setting, 6.9, 25.3.2

attribute sets, 4.7, 12.7

about, 4.7, 12.7

advanced properties, 12.7.1

creating, 12.7.1

defined, 4.7

editing, 12.7.2

tables, 12.4.1.6

attributes

connecting, 6.6.1

defining, 12.4.1.6

dimension attributes, 4.12.2.1

level attributes, 4.12.2.3

setting properties, 6.9

audit details, removing, 30.5.12, 30.5.13

auditing

deployments, 30

executions, 30

auto binding rules, 4.12.3.2

B

backup with the Metadata Loader (MDL), 33

batch files for running experts, 35.11

best practices, Warehouse Builder, 35

BINARY_DOUBLE data type, 4.1.3

BINARY_FLOAT data type, 4.1.3

binding

and pluggable mapping usage, 6.7.4.2

auto binding, rules, 4.12.3.2

BITAND function, 27.6.6

black-box pluggable mapping, 6.7.3

BLOB data type, 4.1.3

bridges, versions, 17.1.2

building expressions, 26.3

business areas

adding item folders, 15.2.2, 15.2.2

creating, 15.1.5

editing, 15.1.6

upgrading to collections, 33.2.3.2

business definitions

about, 5.4.2

deploying, 15.1.18

business definitions module, 15.1.1

Business Domain, 18.1.2.1, 18.2.2.1

business domains

SAP, 18.3.3.2

business identifier, 4.12.2.2.2

Business Intelligence objects

about, 5.4.1

defining, 15

deriving, 15.1.17

Business Intelligence tools, integration, 17.1

business names

business name mode, 3.3.8.1

maximum length, 3.3.8.1

requirements, 3.3.8.1

syntax for business object names, 3.3.8.1, 3.3.8.1

business presentation modules

creating, 15.3.1

editing, 15.3.2

business presentations, about, 5.4.4, 15.3

C

calling scripts, 22.1.13.3

CASS reporting, 10.3.5, 21.2.11

CEIL function, 27.6.7

changing

metadata, 32, 32.10

CHAR data type, 4.1.3, 26.18, 26.18

character transformations, 27.2

check key constraints, 4.8

CHR function, 27.2.2

cleansing

addresses, 10.3.2

names, 10.3.2

CLOB data type, 4.1.3

code generation

configuring target directories, 12.10.2.4

options, 24.1.3

coding conventions, Preface

collections

creating, 3.2.1

deleting shortcuts in, 3.2

editing, 3.2.2

New Collection Wizard, 3.2.1

renaming, 3.2.2.1

upgrading from business areas, 33.2.3.2

commit strategies

committing multiple mappings, 8.1.5

committing to multiple targets, 8.1.3.1

comparing process runs, 30.5.3

COMPOSE function, 27.4.2

CONCAT function, 27.2.3

configuration options

deployable, 13.3, 13.5

deployment options, 13.5

materialized view index tablespace, 13.5

materialized view tablespace, 13.5

configuration parameters

data profiles, 20.2.5.1

configuration properties

ABAP extension, 12.10.2.6

ABAP run parameter file, 12.10.2.6

ABAP spool directory, 12.10.2.6

archive directory, 12.10.2.5

base tables, 12.10.4.1

buffer cache, 12.10.3

build, 12.10.4.1

data segment compression, 12.10.3

DDL directory, 12.10.2.6

DDL extension, 12.10.2.6

DDL spool directory, 12.10.2.6

default index tablespace, 12.10.2.2

default object tablespace, 12.10.2.2

default rollback segment, 12.10.4.1

deployable, 12.10.4.1

deployment options, 13.3.1

dimension, 13.3

end of line, 12.10.2.3

for update, 12.10.4.1

hash partition tablespace list, 12.10.4.1

input directory, 12.10.2.5

invalid directory, 12.10.2.5

lib directory, 12.10.2.6

lib extension, 12.10.2.6

lib spool directory, 12.10.2.6

loader directory, 12.10.2.6

loader extension, 12.10.2.6

loader run parameter file, 12.10.2.6

local rollback segment, 12.10.4.1

location, 12.10.2.1

log directory, 12.10.2.5

logging mode, 12.10.3, 12.10.4.1

master rollback segment, 12.10.4.1

next date, 12.10.4.1

overflow tablespace list, 12.10.3

parallel access mode, 12.10.3, 12.10.4.1

parallel degree, 12.10.3, 12.10.4.1

partition tablespace list, 12.10.3

PL/SQL directory, 12.10.2.6

PL/SQL extension, 12.10.2.6

PL/SQL Generation Mode, 12.10.2.4

PL/SQL run parameter file, 12.10.2.6

PL/SQL spool directory, 12.10.2.6

query rewrite, 12.10.4.1

receive directory, 12.10.2.5

refresh, 12.10.4.1

refresh on, 12.10.4.1

row movement, 12.10.3

row-level dependency, 12.10.3

sequences, 12.10.6

shadow table name, 12.10.3, 12.10.4.1

sort directory, 12.10.2.5

staging file directory, 12.10.2.6

start with, 12.10.4.1

statistics collection, 12.10.3

tablespace, 12.10.3, 12.10.3, 12.10.4.1

using constraints, 12.10.4.1

work directory, 12.10.2.5

configuring

cubes, 13.5

data auditors, 20.9.4

data profiles, 20.2.5

dimensions, 13.3

flat file operators, 24.1.5

mapping sources and targets, 26.16.1

master-detail mappings, 8.2.1.2

master-detail mappings, direct path load, 8.2.2

materialized views, 12.10.4

Name and Address server, 21.2.12.1

PL/SQL mappings, 8.1

runtime parameters, 12.10.1

runtime parameters, SAP files, 18.3.8.1.3

SAP, loading type parameter, 18.3.8.1.2

sequences, 12.10.6

tables, 12.10.3

target modules, 12.10.2

transportable modules, 23.3.4

validating objects, 19.1

views, 12.10.5

configuring mappings, 24.1.1

connecting

attributes, 6.6.1

groups, 6.6.2

operators, 6.6

connection information

SAP application, 18.1.1, 18.2.1

connections, updating, 30.5.15

connectivity

ODBC, 5.3

OLE DB drivers for heterogeneous data sources, 5.3

connectivity agent, 5.3

constants, defining, 25.3.2

constraints, 4.8

about, 4.8

check constraints, creating, 12.2.1.4

check key, about, 4.8

creating, 12.2.1

editing, 12.2.2

foreign key, about, 4.8

foreign key, creating, 12.2.1.2

primary key, about, 4.8

primary key, creating, 12.2.1.1

unique key, about, 4.8

unique key, creating, 12.2.1.3

containers

Oracle Designer Repository, 16.2

SAP application, 18.3.6.3

control activities, 22.1.3

Control Center reports, 30.4

control center transformations, 27.3

conventional path loading

for master-detail relationships, 8.2.1.2

master-detail flat files, 8.2.1.2

conventions

coding, Preface

example, Preface

conversion transformations, 27.4

CONVERT function, 27.4.3

correlated commit, design considerations, 8.1.3.1

COS function, 27.6.8

COSH function, 27.6.9

Create External Table Wizard, 14.6.1

Create Flat File Wizard, 14.2

creating, 20.2.1

alternative sort orders, 15.1.11

attribute sets, 12.7.1

business areas, 15.1.5

business definition module, 15.1.1

business presentation modules, 15.3.1

collections, 3.2.1

constraints, check constraints, 12.2.1.4

constraints, foreign key constraints, 12.2.1.2

constraints, unique key constraints, 12.2.1.3

cubes, 13.4, 13.4.1

cubes, using the Cube Editor, 13.4.2

data auditors, 20.9.1

data objects, 4.5, 4.5

data rule folders, 20.7.2

data rules, 20.7.3

development environment, 35.9

dimensional objects, 4.11, 4.11.1

dimensions, 13.1, 13.1.1, 13.1.2

drill paths, 15.1.7

drills to detail, 15.1.13

experts, 35.2, 35.2

expressions, 26.3

icon sets, 34.5.1, 34.5.1

icons for objects, 34.5

indexes, 4.9.1

item folders, 15.1.4, 15.2.3

list of values, 15.1.9

mappings, 6

Oracle Designer 6i source modules, 16.2.1

physical objects, 12.10.2

PL/SQL types, 9.3.2

pluggable mapping, 6.7.2

presentation templates, 15.3.3

primary key constraints, 12.2.1.1

process flows, 7.2.3

registered functions, 15.1.15

time dimensions, using the Time Dimension Wizard, 13.6.1

transportable modules, 23.3.3

type 2 SCDs, 13.1.1.6, 13.2.1

type 3 SCDs, 13.1.1.6, 13.2.2

user-defined objects, 34.3.2

user-defined properties, 34.2.1

creating correction mappings, 20.6.1

cubes, 4.14

configuring, 13.5

creating, 13.4, 13.4.1, 13.4.2

default aggregation method, 4.14.1.2

dimensionality, 4.14.1.2, 13.4.1.3

editing, 13.4.4

example, 4.14.1.3

measures, 4.14.1.1

measures, creating, 13.4.1.4

MOLAP implementation, 4.14.2.3

relational implementation, 4.14.2.1

ROLAP implementation, 4.14.2.1

solve dependency order, 4.14.3

storing, 13.4.1.2

CURRENT_DATE function, 27.5.2

custom transformations

about, 9.1.1.2

defining, 9.3

editing, 9.4

D

data

aggregating, 26.4

cleansing, 10.3.2

importing, 18

test, 6.11.3

viewing, 4.4

data auditor monitor activities, 22.1.6

data auditors

configuring, 20.9.4

creating, 20.9.1

editing, 20.9.2

data definitions, importing, 16

data flow operators, 6.3.5.2, 26.1

Data Generator operator, 8.2.2

Data Object Editor

components, 4.2

creating data objects, 4.5

launching, 4.2

standard components, 4.3

using, 12.1

data objects

about, 4.1.1

creating, 4.5

data type for columns, 4.1.3

defining, 12

dimensional objects, creating, 4.11.1

dimensional objects, implementing, 4.11.2

editing, 4.5, 12.1

identifying deployment location, 30.5.6

naming conventions, 4.1.2

used in map run, 30.5.7

validating, 19

viewing, 4.4

data profile

adding objects, 20.2.2

editing, 20.2.2

Data Profile Editor

about, 20.2.4

components, 20.2.4

data profiles, 20.2.1

adding data objects, 20.2.3

configuration parameters, 20.2.5.1

configuring, 20.2.5

creating, 20.2.1

data profiling

about, 10.2

cleansing data, 20.6

correcting schemas, 20.6

creating corrections, 20.6.1

performance tuning, 20.8

performing, 10.2.3

profile results canvas, 20.2.4.6

profiling data, 20.3

steps, 10.2.3

types of, 10.2.2

types, attribute analysis, 10.2.2.1

types, functional dependency, 10.2.2.2

types, referential analysis, 10.2.2.3

viewing corrections, 20.6.9

viewing results, 20.4

data quality

ensuring, 10

Match-Merge operator, 10.3.1, 21.1

data quality operators, 10.3.1

data rule folders, creating, 20.7.2

data rules, 12.4.1.7

about, 10.4

applying, 20.7.5

creating, 20.7.3

deriving, 20.5

editing, 20.7.4

types, 20.7.1

uses, 20.7

data sources, 16

defining SAP objects, 18.3.6.3

Oracle Designer 6i, 16.2

Oracle Heterogeneous Services, 5.3

Oracle Transparent Gateways, 5.3

E

editing

alternative sort orders, 15.1.12

attribute sets, 12.7.2

business areas, 15.1.6

business presentation modules, 15.3.2

collections, 3.2.2

constraints, 12.2.2

cubes, 13.4.4

data auditors, 20.9.2

data profile, 20.2.2

data rules, 20.7.4

dimensions, 13.2.3

drill paths, 15.1.8

drills to detail, 15.1.14

invalid objects, 19.3

item folders, 15.1.3

list of values, 15.1.10

materialized views, 12.6.3

PL/SQL types, 9.4.2

presentation templates, 15.3.4

process flows, 7.3

registered functions, 15.1.16

schedules, 28.1

table definitions, 12.4.2

time dimensions, 13.6.2

transformation properties, 9.4

transportable modules, 23.4

user-defined objects, 34.4

user-defined properties, 34.4

views, 12.5.3

editing data objects, 12.1

email activity, 22.1.7

embedded pluggable mapping usage, 6.7.4.2

EMPTY_BLOB, EMPTY_CLOB function, 27.8.3

ensuring data quality, 10

ETL

improving runtime performance, 8

ETL objects, scheduling, 28

example conventions, Preface

executing

deployed objects, 29.7

mappings from SQL Plus, 8.1.5

reports, 30.4, 30.4.2

execution reports, 30.4, 30.4.2

executions

auditing, 30

EXISTSNODE function, 27.11.1

EXP function, 27.6.10

expert editor, icon set, 34.5.2.3

expert objects, 35.3

experts

adding tasks, 35.4

creating, 35.2, 35.2

defined, 35.1

developer view, 35.1.2

generating, 35.8

nested, 35.5

publishing, 35.10

running from batch file, 35.11

starting, 35.8

tasks, 35.7

transitions, 35.6, 35.6

user view, 35.1.1

validating, 35.8

variables, 35.7.3

exporting

log file, 17.1.2.3.1

metadata, for user grants, 33.2.1.2

metadata, for user-defined definitions, 33.2.1.2

metadata, in additional languages, 33.2.1.2

metadata, results, 33.1.6

metadata, using Warehouse Builder client, 33.2.1

snapshots, 32.9

user-defined objects, 34.4.1

user-defined properties, 34.4.1

Expression Builder

about, 26.3

opening, 26.3.1

Expression operator, 26.7, 26.7

expressions, creating, 26.3

external processes, upgrading to user-defined processes, 33.2.3.2

External Table editor, 14.6.3

external tables

configuring, 14.6.4

creating a new definition, 14.6.1

defined, 14.1.1.3, 14.6

editor, 14.6.3

synchronizing definition, 14.6.2

wizard for creating, 14.6.1

F

fast refresh, 12.10.4.2

File Exists activity, 22.1.10

files, defining, 14

Filter operator, 26.8, 26.8, 26.8

filters, with a transform, 9.5

flat file modules, creating, 14.1.3

Flat File Sample Wizard, 14.4

flat files

configuration, 24.1.5

configuring master-detail mappings, 8.2.2

creating new, 14.2

defining, 14

describing, 14.2.1

extracting master and detail records, 8.2.1.2

importing master-detail flat files, 8.2.1.2

mapping, 6.2.1

master-detail mappings, post-update scripts for direct path loads, 8.2.2

master-detail, example, 8.2.1

master-detail, extracting from, 8.2.1

master-detail, operations after initial load, 8.2.1.4

as sources, 14.1.1

as targets, 14.1.2

G

generating

experts, 35.8

transportable module, 23.3.5

generating scripts, 19.4

global shared library, 9.2.1

Group By clause, 26.4.1

group properties, 6.9

groups

adding to mappings, 26.2.2

connecting, 6.6.2

in LIA diagrams, 31.5.1

Name and Address operator, 21.2.3

removing from mappings, 26.2.2

setting properite, 6.9

H

Having clause, 26.4.2

heterogeneous data sources, 5.3

HEXTORAW function, 27.4.4

hiding welcome pages for wizards, 3.3.5

hierarchies

about, 4.12.2.4

creating, 13.1.1.4, 13.1.2.5

householding, 10.3.1, 21.1, 21.1, 21.1.4

I

icon set

expert editor, 34.5.2.3

process flow, 34.5.2.2

icon sets

assigning to objects, 34.5.2, 34.5.2

creating, 34.5.1, 34.5.1

icons, creating, 34.5

impact analysis, 30.3.2.4

implementing

dimensional objects, 4.11.2

MOLAP cubes, 4.14.2.3

MOLAP dimensions, 4.12.3.3

relational cubes, 4.14.2.1

relational dimensions, 4.12.3.1

reporting on, 30.3.2.3

ROLAP cubes, 4.14.2.1

ROLAP dimensions, 4.12.3.1

snowflake schema, 4.12.3.1.2

star schema, 4.12.3.1.1

import language options, 33.2.2.5

import modes, 33.2.2.1

import searching, 33.2.2.1

importing

data, 18

data definitions, 16

definitions, database systems, 16.1.1

flat files, 14.3

from SAP R/3, 18.3.6

Import Metadata Wizard, 16.1.1

master-detail flat files, 8.2.1.2

metadata for flat files, 14.3

metadata, combining import modes and matching criteria, 33.2.2.4

metadata, for security grants, 33.2.2.2

metadata, for user-defined definitions, 33.2.2.2

metadata, import modes, 33.2.2.1

metadata, in additional languages, 33.2.2.2

metadata, language options, 33.2.2.5

metadata, matching criteria, 33.2.2.1

metadata, results, 33.1.6

metadata, using Warehouse Builder client, 33.2.2

metadata, validation rules, 33.2.2.6

Oracle database metadata, 16.1.1

PL/SQL functions, 9.5

reimporting database definitions, 16.1.2

snapshots, 32.9

user-defined objects, 34.4.1

user-defined properties, 34.4.1

importing metadata, 17.1.2

improving runtime performance, 8

index partitioning, 4.9.1, 12.3.6

indexes

about, 4.9

creating, 4.9.1

defining, 12.4.1.4

types, 4.9.1

INITCAP function, 27.2.4

input signature, 6.7.2.4

inserting into multiple targets, 26.16.1

INSTR function, 27.2.5

INSTR2 function, 27.2.5, 27.2.5

INSTR4 function, 27.2.5, 27.2.5

INSTRB function, 27.2.5, 27.2.5

INSTRC function, 27.2.5, 27.2.5

INTEGER data type, 4.1.3

integration with Business Intelligence, 17.1

INTERVAL DAY TO SECOND data type, 4.1.3

INTERVAL YEAR TO MONTH data type, 4.1.3

item folders

about, 15.1.2

adding items, 15.2.4, 15.2.4

creating, 15.1.4, 15.2.3

creating joins, 15.2.6

editing, 15.1.3

synchronizing, 15.2.5

J

Joiner operator, 26.9, 26.9, 26.9.2

joining multiple row sets, 26.9

joins, full outer, 26.9.1.1, 26.9.2, 26.9.2

K

Key Lookup operator, 26.10, 26.10

L

language, SAP, 18.3.8.1.3

languages, setting locale preferences, 3.3.1

LAST_DAY function, 27.5.5

launching

Data Object Editor, 4.2

Deployment Manager, 29.3

LENGTH function, 27.2.6

LENGTH2 function, 27.2.6, 27.2.6

LENGTH4 function, 27.2.6, 27.2.6

LENGTHB function, 27.2.6, 27.2.6

LENGTHC function, 27.2.6, 27.2.6

levels

dimension, 4.12.2.2

lineage, 30.3.2.4

lineage diagrams, 31.3

lineage reports, 30.3.2.4

list of values

creating, 15.1.9

editing, 15.1.10

LN function, 27.6.12

conventional path for master-detail targets, 8.2.1.2

data from materialized view, 25.3.12

direct path for master-detail targets, 8.2.2

flat files, 14.2.4.1

master and detail records, 8.2.1.2

master-detail relationships, 8.2.1.2, 8.2.2

master-detail relationships, direct path, 8.2.2

loading types, 25.3.1.2

for SAP, 18.3.8.1.2

locales, setting, 3.3.1

locations

data objects deployed to, 30.5.6

of transportable modules, 23.3.2

unregistering, 30.5.14

updating connection details, 30.5.15

log files

export to OMG CWM, 17.1.2.3.1

Metadata Loader logs, 33.1.5

LOG function, 27.6.13

logical name mode See business name mode

logical names See business names, 3.3.8.1

logs, message log preferences, 3.3.7

LONG data type, 4.1.3

LOWER function, 27.2.7

LPAD function, 27.2.8

LTRIM function, 27.2.9

M

main procedure, 8.1.5

management reports, 30.4, 30.4.3

manual activity, 22.1.14

map runs, 30.5.4, 30.5.7

mapping activity, 22.1.15

Mapping Editor

about, 6.3.1

components, 6.3.1

keyboard operations, 36.5

toolbars, 6.3.3

windows, 6.3.2

mapping operators

about, 6.1

adding, 6.4

Aggregator operator, 26.4

connecting, 6.6

Deduplicator operator, 26.6

Dimension operator, 25.3.7

editing, 6.5

Expression operator, 26.7

Filter operator, 26.8

Joiner operator, 26.9

Key Lookup operator, 26.10

Match-Merge operator, 10.3.1, 21.1

Name and Address operator, 10.3.2

Pivot operator, 26.11

Post-Mapping Process operator, 26.12

Pre-Mapping Process operator, 26.13

Set Operation operator, 26.14

Sorter operator, 26.15

Splitter operator, 26.16

synchronizing with Repository objects, 6.10

Table Function operator, 26.17

that bind to Repository objects, 6.4.1

Transformation operator, 26.18

types of, 6.3.5

Unpivot operator, 26.19

mapping operators, setting, 6.9

mapping output parameters, 25.3.11

Mapping Sequence operator, 8.2.1, 8.2.1

mappings

about, 6.1

accessing data via transportable modules, 23.3.6

black-box, 6.7.3

configuring, 8.1, 24.1.1

configuring master-detail, 8.2.1.2

creating, 6

debugging, 6.11

defiining, 6

executing from SQL Plus, 8.1.5

for flat files, 6.2.1

for PEL, 8.3.2

groups, 26.2.2

master-detail mappings, 8.1.6

naming conventions, 6.5.4, 7.3.5.1

PL/SQL mappings, 8.1

runtime parameters, 24.1.2

setting properties, 6.8

sources and targets, configuring, 26.16.1

upgrading, 33.2.3.2

master-detail flat files

as sources, about, 8.2.1

configuring mappings, 8.2.1.2

configuring mappings, direct path load, 8.2.2

Data Generator operator, 8.2.2

example of a master-detail flat file, 8.2.1

extracting from, 8.2.1.2

extracting from, using conventional path load, 8.2.1.2

extracting from, using direct path load, 8.2.2

importing and sampling, 8.2.1.2

operations after initial load, 8.2.1.4

performance, 8.2.1.2, 8.2.2

post-update scripts for direct path loads, 8.2.2

RECNUM, 8.2.2

sample mapping, conventional path loading, 8.2.1.2

sample mapping, direct path loading, 8.2.2

sequences in target tables, 8.2.1.2

Match bins, 21.1.11

Match rules

active, 21.1.12

Address rule, 21.1.23

Conditional rule, 21.1.14

custom rules, 21.1.25

Firm rule, 21.1.21

multiple match rules, 21.1.2.1

passive, 21.1.12

Person rule, 21.1.19

transitive match rules, 21.1.2.2

Weight rule, 21.1.17

matching

records, 21.1.2

rules, 21.1.12, 21.1.13

transitive, 21.1.2.2

Match-Merge operator, 10.3.1, 10.3.1, 21.1

concepts, 21.1.2

custom rules, 21.1.25, 21.1.35

design considerations, 21.1.3

example, 21.1.1

groups, 21.1.6

Match-Merge wizard, 21.1.5

materialized views, 12.6

attribute sets, adding, 12.6.3.4

attribute sets, deleting, 12.6.3.4

attribute sets, editing, 12.6.3.4

columns, adding, 12.6.3.2

columns, deleting, 12.6.3.2

columns, editing, 12.6.3.2

configuring, 12.10.4

constraints, adding, 12.6.3.3

constraints, deleting, 12.6.3.3

constraints, editing, 12.6.3.3

defining, 12.6.2

defining attribute sets, 12.6.2.7

defining columns, 12.6.2.2

defining constraints, 12.6.2.4

defining data rules, 12.6.2.8

defining indexes, 12.6.2.5

defining partitions, 12.6.2.6

defining query, 12.6.2.3

editing, 12.6.3

fast refresh, 12.10.4.2

loading data from, 25.3.12

loading data into, 25.3.12

naming, 12.6.2.1

renaming, 12.6.3.1

update definitions, 12.6.3

MDL

see Metadata Loader

MDSYS.SDO_DIM_ARRAY data type, 4.1.3

MDSYS.SDO_DIM_ELEMENT data type, 4.1.3

MDSYS.SDO_ELEM_INFO_ARRAY data type, 4.1.3

MDSYS.SDO_GEOMETRY data type, 4.1.3

MDSYS.SDO_ORDINATE_ARRAY data type, 4.1.3

MDSYS.SDO_POINT_TYPE data type, 4.1.3

MDSYS.SDOAGGRTYPE data type, 4.1.3

Merge rules, 21.1.28, 21.1.35

message log preferences, 3.3.7

metadata

access tool, 34.1.1

backup with the Metadata Loader (MDL), 33

changing, 32, 32.10

dependencies, 31

import and export overview, 33.1

Import Metadata Wizard, 16.1.1

import modes, 33.2.2.1

importing from databases, 16.1.1

importing, matching criteria, 33.2.2.1

integrating with BI products, 17

matching criteria for import, 33.2.2.1

upgrading, 33.2.3

metadata dependencies, diagrams of, 31.1

Metadata Dependency Manager, 31.1

metadata export

required access privileges, 33.2.1, 33.2.1

Metadata Export Utility, 33.1.1.1

metadata for flat files

importing, 14.3

metadata import

required access privileges, 33.2.2

Metadata Import Utility, 33.1.1.2

Metadata Loader

about, 33

accessing, 33.1.3

log files, 33.1.5

metadata matching criteria, 33.2.2.1

multiple user access, 33.1.4

overview of import and export, 33.1

results, 33.1.6

uses, 33.1.2

using with OMB Plus, 33.3

using with Warehouse Builder client, 33.2

utilities, 33.1.1

metadata management, 33.1

metadata snapshots, 32

minus, in the Set Operation operator, 26.14

MOD function, 27.6.14

modes

business name mode, 3.3.8.1

logical name mode See business name mode

naming mode, default, 3.3.8.1

physical name mode, 3.3.8.1

modules

configuring target modules, 12.10.2

defining SAP objects, 18.3.6.3

process flows, 7.1.1, 7.2.1

SAP application, 18.3.6.3

MOLAP implementation, 4.11

monitoring process runs, 30.5.10

MONTHS_BETWEEN function, 27.5.6

mpact analysis diagrams, 31.3

multiple user access with MDL, 33.1.4

multiple-record-type flat files

master-detail structure, 8.2.1

master-detail structure, example of, 8.2.1

multiple-table insert, 26.16.1

N

Name Address

primary country, 21.2.2

Name and Address

country postal certifications, Australia, 10.3.5.3, 21.2.11.3

country postal certifications, Canada, 10.3.5.2, 21.2.11.2

country postal certifications, United States, 10.3.5.1, 21.2.11.1

operator, 10.3.2

Name and Address operator, 10.3.2, 21.2.1

best practices, 10.3.4

CASS reporting, 10.3.5, 21.2.11

definitions, 21.2.2

dual address assignment, 21.2.2

enabling, 10.3.2

groups, 21.2.3

input roles, 21.2.6

output attributes, 21.2.7

output components, 21.2.7, 21.2.8, 21.2.9

properties, Parsing Type, 21.2.2

Name and Address operator operator

parsing type, 21.2.2

Name and Address server, 21.2.12

configuring, 21.2.12.1

starting, 21.2.12.2

stopping, 21.2.12.2

Name-Address operator

Input Attributes, 21.2.5

Output Attributes, 21.2.7

names

business name mode, 3.3.8.1

business object names, syntax for, 3.3.8.1, 3.3.8.1

cleansing, 10.3.2

default naming mode, 3.3.8.1

logical name mode See business name mode

physical name mode, 3.3.8.1

physical object names, syntax for, 3.3.8.1

names and addresses, processing libraries, 21.2.12

naming

modes, default naming mode, 3.3.8.1

objects, business name mode, 3.3.8.1

objects, logical name mode See business name mode

objects, physical name mode, 3.3.8.1

setting naming preferences, 3.3.8

transformation names, 3.3.8.1

naming conventions, for data objects, 4.1.2

NANVL function, 27.6.15

naviatin

Repository Browser, 30.3.1

navigation tree

deploying objects from, 29.2

NCHAR data type, 4.1.3

NCLOB data type, 4.1.3

nested experts, 35.5

nested tables

creating, 12.9.8

editing, 12.9.9

overview, 12.9.7

NEW_TIME function, 27.5.7

NEXT_DAY function, 27.5.8

NLS_CHARSET_DECL_LEN function, 27.8.4

NLS_CHARSET_ID function, 27.8.5

NLS_CHARSET_NAME function, 27.8.6

NLS_INITCAP function, 27.2.11

NLS_LOWER function, 27.2.12

NLS_UPPER function, 27.2.13

NLSSORT function, 27.2.10

non-Oracle database systems

as data sources, 5.3

NULLIF function, 27.8.7

NUMBER data type, 4.1.3

number transformations, 27.6, 27.6

NUMTODSINTERVAL function, 27.4.5

NUMTOYMINTERVAL function, 27.4.6

NVARCHAR2 data type, 4.1.3

NVL2 function, 27.8.9

O

object properties, report, 30.3.3

object types

creating, 12.9.2

editing, 12.9.3

overview, 12.9.1

objects

assiging icon sets to, 34.5.2

associating, 34.3.3

associating with user-defined objects, 34.3.3

creating icons for, 34.5

deploying from the navigation tree, 29.2

executing deployed objects, 29.7

expert, 35.3

exporting, 34.4.1

importing, 34.4.1

invalid objects, editing, 19.3

restoring from snapshots, 32.8

selecting for deployment, 29.4

syntax for business names, 3.3.8.1

syntax for logical names, 3.3.8.1

syntax for physical names, 3.3.8.1

user-defined, 34

validating, 19.1

ODBC for heterogeneous data sources, 5.3

ojbects

reports, 30.3.2

OLAP catalog, 4.11.2.3.2

OLAP transformations, 27.7

OLE DB drivers for heterogeneous data sources, 5.3

OMB, 34.1.1

OMB Plus, 34.1.1

about, 34.1.1

scripts, 34.1.1.1

OMBDEFINE, 34.1.1.1

OMBDESCRIBE, 34.1.1.1

OMBDISPLAYCURRENTMODE, 34.2.1

OMBREDEFINE, 34.1.1.1

OMBSWITCHMODE, 34.2

opening

Deployment Manager, 29.3

Expression Builder, 26.3.1

Repository Browser, 30.2

operating modes

row based, 8.1.1.2

row based (target only), 8.1.1.3

selecting a default mode, 8.1.1

set based, 8.1.1.1

operator attributes, 6.6.1

Operator Editor

Input tab, 26.2.2

Input/Output tab, 26.2.2

Output tab, 26.2.2

operator properties

setting, 6.9

Operator wizard, 26.2.1

operators

Aggregator, 26.4

Aggregator operator, 26.4

Anydata Cast, 26.5

connecting, 6.6

data flow, 6.3.5.2, 26.1

data quality operators, 10.3.1

Deduplicator, 26.6

Deduplicator operator, 26.6

Dimension operator, 25.3.7

editing, 6.5

Expression, 26.7

Expression operator, 26.7

Filter, 26.8

Filter operator, 26.8

flat file, 24.1.5

Joiner, 26.9

Joiner operator, 26.9

Key Lookup operator, 26.10

mapping

binding to Repository objects, 6.4.1

Match-Merge, 10.3.1

Match-Merge operator, 10.3.1, 21.1

Name and Address, 10.3.2

Name and Address operator, 10.3.2

Pivot operator, 26.11

Post-Mapping Process operator, 26.12

Pre-Mapping Process operator, 26.13

Set Operation operator, 26.14

Sorter operator, 26.15

source, 25.2

Splitter operator, 26.16

synchronizing with Repository objects, 6.10

Table Function operator, 26.17

target, 25.2

Transformation operator, 26.18

Unpivot operator, 26.19

operators, mapping, 6.1

adding, 6.4

connecting, 6.6

editing, 6.5

types of, 6.3.5

optimizing the repository, 3.3.5

OR activity, 22.1.17

ORA_HASH function, 27.8.10

Oracle Designer 6i, 16.2

Application Systems, 16.2

source module, 16.2

workareas, 16.2

Oracle Heterogeneous Services, 5.3

Oracle library, 9.2.1

Oracle Metabase Plus, 34.1.1, 34.1.1

Oracle Transparent Gateways, 5.3

Oracle Warehouse Builder Name and Address

purchasing license, 10.3.2

ORDER BY

in the Sorter operator, 26.15

ordering

multiple targets, 8.1.6

other (non-SQL) transformations, 27.8

Output Attributes

Name-Address operator, 21.2.7

output attributes

Name and Address operator, 21.2.7

output components

Name and Address operator, 21.2.7, 21.2.8, 21.2.9

output signature, 6.7.2.5

P

packages

as transformations, 9.1.1.2

defining, 9.3

editing, 9.4

process flows, 7.1.1, 7.2.2

parameters

mapping output, 25.3.11

parent identifier, 4.12.2.2.3

parsing type

Name and Address operator, 21.2.2

Partition Exchange Loading (PEL), 8.3

about, 8.3.1

configuring targets for, 8.3.5

mappings for, 8.3.2

performance considerations, 8.3.4

restrictions on, 8.3.5, 8.3.6

partitioning, index, 4.9.1, 12.3.6

partitions

defining, 12.4.1.5

PATH function, 27.8.11

physical names

physical name mode, 3.3.8.1

syntax for physical object names, 3.3.8.1

Pivot operator

about, 26.11

editing, 26.11.3

example, 26.11.1

expressions for, 26.11.3.6

groups, 26.11.3.2

input attributes, 26.11.3.4

output attributes, 26.11.3.5

row locators, 26.11.2, 26.11.3.5

using, 26.11.3

PL/SQL mappings, 8.1

PL/SQL types

about, 9.3.2.1

creating, 9.3.2

editing, 9.4.2

pluggable mapping usages

embedded, 6.7.4.2

reusable, 6.7.4.2

types of, 6.7.4.2

pluggable mappings

about, 6.7

creating, 6.7.2

embedded, 6.7

reusable, 6.7

system-managed, 6.7.3

usage, 6.7.4, 6.7.4.2

utilizing context, 6.7.4

white-box, 6.7.3

pooled tables, 18.3.3.1

Post-Mapping Process operator, 26.12

POWER function, 27.6.16

predefined transformations, 9.1.1.1

preferences

displaying welcome pages for wizards, 3.3.5

locale, 3.3.1

message log preferences, 3.3.7

naming preferences, 3.3.8

Pre-Mapping Process operator, 26.13

presentation templates

creating, 15.3.3

editing, 15.3.4

primary country, Name-Address operator, 21.2.2

primary key constraints, 4.8

procedures

as transformations, 9.1.1.2

defining, 9.3

editing, 9.4

Process Flow Editor, 7.3

process flows

about, 7.1

activities in, 7.3.6

adding transformations to, 22.1.23

complex conditions in, 7.3.8

creating, 7.2.3

debugging, 30.5.2

defining, 7.2

deploying, 7.1.1

designing, 7

editing, 7.3

halting, 22.1.14

icon set, 34.5.2.2

launching, 22.1.22

modules, 7.1.1, 7.2.1

packages, 7.1.1, 7.2.2

scripting in, 22.1.20

subprocesses, 22.1.22

transitions, 7.3.6

process runs

aborting, 30.5.11

comparing, 30.5.3

debugging, 30.5.2

identifying recent, 30.5.1

monitoring, 30.5.10

rerunning, 30.5.9

processes

debuging, 30.5.2

identifying recent, 30.5.1

running, 30.5.9

projects

backup with the Metadata Loader (MDL), 33

importing PL/SQL into, 9.5

propagating

user-defined objects, 34.4.1

user-defined properties, 34.4.1

properties

for source operators, 25.3.1

for target operators, 25.3.1

mapping, 6.8

object, 30.3.3

setting, 6.9

user-defined, 34.2

publishing experts, 35.10

R

RAC, managing serevice nodes, 30.4.3.1

RAW data type, 4.1.3

RAWTOHEX function, 27.4.7

RAWTONHEX function, 27.4.8

RECNUM attribute, 8.2.2

RECNUM colums, 8.2.2

records

extracting and loading master and detail records, 8.2.1.2

matching, 21.1.2

relationships between masters and details in flat files, 8.2.1

referential analysis, 10.2.2.3

referential integrity, ensuring in mappings, 8.1.6

REGEXP_INSTR function, 27.2.15

REGEXP_REPLACE function, 27.2.16

REGEXP_SUBSTR function, 27.2.17

registered functions

creating, 15.1.15

editing, 15.1.16

reimporting

database definitions, 16.1.2

relating master and detail records, 8.2.1

relational implementation, 4.11

relational objects, defining, 4.1.1

REMAINDER function, 27.6.17

REMAINING_ROWS output group

in the Splitter operator, 26.16

remote function call, 18.3.6.3

remote function call (RFC)

RFC connection, 18.3.6.3.1

SAP RFC connection, 18.3.6.3.1

renaming

collections, 3.2.2.1

materialized views, 12.6.3.1

sequences, 12.8.3.1

tables, 12.4.2.1

views, 12.5.3.1

reordering table columns, 12.4.2.5

repeating schedules, 28.1.2

REPLACE function, 27.2.14

REPLICATE, 27.10.1

reporting

Control Center, 30.4

execution, 30.4, 30.4.2

impact analysis, 30.3.2.4

implementation, 30.3.2.3

lineage, 30.3.2.4

management, 30.4, 30.4.3

object properties, 30.3.3

on deployment, 30.4, 30.4.1

on objects, 30.3.2

reports, 30.3.2.4

Control Center, 30.4

deplolyment, 30.4, 30.4.1

execution, 30.4, 30.4.2

impact analysis, 30.3.2.4

implemention, 30.3.2.3

management, 30.4, 30.4.3

object, 30.3.2

object properties, 30.3.3

repositories

backup with the Metadata Loader (MDL), 33

propagating from one to another, 34.4.1

Repository

logging in, 30.2.3

optimizing, 3.3.5

Repository Browser

about, 30.1

Control Center, 30.4

Design Center, 30.3

implementation reports, 30.3.2.3

navigating, 30.3.1

object reports, 30.3.2

opening, 30.2

starting, 30.2.1

stopping, 30.2.1

Repository navigator, 30.3.1

required access privileges

metadata export, 33.2.1, 33.2.1

metadata import, 33.2.2

requirements

for business names, 3.3.8.1

reserved words, 37

reusable pluggable mapping usage, 6.7.4.2

Reverse Engineering, 16.1

RFC, 18.3.6.3

ROLAP implementation, 4.11

roles

dimension roles, 4.12.2.5

ROUND function, 27.5.9, 27.6.18

route activity, 22.1.18

row based, 8.1.1.2

row based (target only), 8.1.1.3

row locators

in the Pivot operator, 26.11.2, 26.11.3.5

in the Unpivot operator, 26.19.2, 26.19.3.5

rows, filtering out, 26.8

RPAD function, 27.2.18

RTRIM function, 27.2.19

in the Transformation operator, 26.18

running

processes, 30.5.9

runtime parameters, configuring, 24.1.2

runtime performance, improving, 8

runtime, SAP, 18.3.8.1.3

S

samples

Flat File Sample Wizard, 14.4

sampling

master-detail flat files, 8.2.1.2

SAP

Business Domain, 18.1.2.1, 18.2.2.1

defining ETL process for SAP objects, 18.3.8

defining SAP objects, 18.3.6.3

remote function call, 18.3.6.3

SAP application source module, 18.3.6.3

SAP business domains, 18.3.3.2

SAP Connector

creating definitions, 18.3.6.3

SAP file physical properties

Data File Name, 18.3.8.1.3

File Delimiter for Staging File, 18.3.8.1.3

Nested Loop, 18.3.8.1.3

SAP System Version, 18.3.8.1.3

SQL Join Collapsing, 18.3.8.1.3

Staging File Directory, 18.3.8.1.3

Use Single Select, 18.3.8.1.3

SAP parameters

language, 18.3.8.1.3

loading type, 18.3.8.1.2

runtime, 18.3.8.1.3

SAP R/3

importing metadata, 18.3.6

SAP source, 18.1.1, 18.2.1

SAP table types

cluster, 18.3.3.1

importing, 18.3.3.1

pooled, 18.3.3.1

transparent, 18.3.3.1

SAPRFC.INI, 18.3.6.3

SAPRFC.INI file, 18.3.6.3.1, 18.3.6.3.1

SCDs

see slowly changing dimensions

schedules

creating, 11.3

defining, 11.3

duration, 28.1.1

editing, 28.1

repeating, 28.1.2

using, 11.3

scheduling

about, 11.2

ETL objects, 28

SCN_TO_TIMESTAMP function, 27.4.9

scripting

in process flows, 22.1.20

OMB Plus, 34.1.1.1

outside of Warehouse Builder, 22.1.13.3

to define user-defined objects, 34.3.1

within Warehouse Builder, 22.1.13.1

scripts

calling, 22.1.13.3

generating, 19.4

OMB Plus, 34.1.1.1

viewing, 19.4

SDO_AGGR_CENTROID function, 27.9.1

SDO_AGGR_CONVEXHULL function, 27.9.2

SDO_AGGR_MBR function, 27.9.3

SDO_AGGR_UNION function, 27.9.4

Select Icon button, 34.5.2.2

sequences, 12.8

configuring, 12.10.6

Create Sequence Wizard, 12.8.2

defining, 12.8.2

for master-detail targets, 8.2.1.2

renaming, 12.8.3.1

service nodes, managing, 30.4.3.1

SESSIONTIMEZONE function, 27.5.10

set based mode, 8.1.1.1

set based update, 8.1.1.1

set based vs. row based modes, 8.1.1

Set Operation operator, 26.14

intersect, 26.14

minus, 26.14

union, 26.14

union all, 26.14

Set Status activity, 22.1.19

setting

a starting point, 6.11.6.3

attribute properties, 25.3.2

locale preferences, 3.3.1

mapping properties, 6.8

message log preferences, 3.3.7

naming preferences, 3.3.8

wizard preferences, 3.3.5

Setting the Language Parameter, 18.3.8.1.3

Setting the Runtime Parameter, 18.3.8.1.3

SIGN function, 27.6.19

signatures

input, 6.7.2.4

output, 6.7.2.5

SIN function, 27.6.20

SINH function, 27.6.21

six sigma

metrics, 10.2.4.2

slowly changing dimensions

about, 4.13

type 1, 4.13.1

type 2, 4.13.2, 13.1.1.6, 13.2.1

type 3, 4.13.3, 13.1.1.6, 13.2.2

types, 4.13

snapshots

access privileges, 32.5

adding components, 32.3

comparing, 32.6

converting type, 32.7

creating, 32.2

deleting, 32.10

exporting, importing, 32.9

metadata, 32

restoring, 32.8

uses, 32.1

Sorter operator, 26.15, 26.15

SOUNDEX function, 27.2.20

source modules, 16

connection information, 18.1.1, 18.2.1

importing definitions, 16.1.1

Oracle Designer 6i, 16.2.1

Oracle Designer Repository, 16.2

SAP application, 18.3.6.3

source operators, 25.2

sources

data sources, 16

flat files, 14.1.1

master-detail flat file sources, 8.2.1

master-detail flat files, 8.2.1

master-detail flat files, example, 8.2.1

updating source definitions, 16.1.3

Spatial Transformations, 27.9

Splitter operator, 26.16, 26.16

SQL expressions, 26.7

SQL*Loader properties, 14.2.4.1

sqlplus activity, 22.1.20

SQRT function, 27.6.22

Start activitity, 22.1.21

starting

experts, 35.8

Name and Address server, 21.2.12.2

Repository Browser, 30.2.1

starting point, setting, 6.11.6.3

stopping

Name and Address server, 21.2.12.2

Repository Browser, 30.2.1

streams transformations, 27.10

subprocesses, to launch process flows, 22.1.22

substitution variables, 22.1.13.2

SUBSTR function, 27.2.21

SUBSTR2 function, 27.2.21, 27.2.21

SUBSTR4 function, 27.2.21, 27.2.21

SUBSTRB function, 27.2.21, 27.2.21

SUBSTRC function, 27.2.21, 27.2.21

summarizing

data with a transformation, 26.4

surrogate identifier, 4.12.2.2.1

surrogate keys

in the Key Lookup operator, 26.10

synchronizing

item folders, 15.2.5

operators and Repository objects, 6.10

syntax

for business object names, 3.3.8.1

for logical object names, 3.3.8.1

for physical object names, 3.3.8.1

SYS_CONTEXT function, 27.8.12

SYS_EXTRACT_UTC function, 27.5.13

SYS_GUID function, 27.8.13

SYS_TYPEID function, 27.8.14

SYS_XMLAGG, 27.11.4

SYS_XMLGEN function, 27.11.5

SYS.ANYDATA data type, 4.1.3

SYSDATE function, 27.5.11

SYS.LCR$_ROW_RECORD data type, 4.1.3

system-managed pluggable mapping, 6.7.3

systems, deploying, 29

SYSTIMESTAMP function, 27.5.12

T

table definitions

creating, 12.4.1

editing, 12.4.2

Table Function operator, 26.17

prerequisites, 26.17.1

using, 26.17

tables, 12.4.1.4, 12.4.1.7

attribute sets, 4.7, 12.7

attribute sets, adding, 12.4.2.4

attribute sets, defining, 12.4.1.6

attribute sets, deleting, 12.4.2.4

attribute sets, editing, 12.4.2.4

columns, adding, 12.4.2.2

columns, defining, 12.4.1.2

columns, deleting, 12.4.2.2

columns, editing, 12.4.2.2

configuring, 12.10.3

constraints, adding, 12.4.2.3

constraints, defining, 12.4.1.3

constraints, deleting, 12.4.2.3

constraints, editing, 12.4.2.3

data rules, 12.4.1.7

defining, 12.4.1, 12.4.1

defining partitions, 12.4.1.5

naming, 12.4.1.1

renaming, 12.4.2.1

reordering columns, 12.4.2.5

U

UDP, 34.1

UID function, 27.8.15

UKSee constraints

unique key

UNION ALL set operation, 26.14

UNION set operation, 26.14

unique

key constraints, 4.8

transformation names, 3.3.8.1

UNISTR function, 27.4.25

Unpivot operator

about, 26.19

editing, 26.19.3

example, 26.19.1

expressions for, 26.19.3.7

groups, 26.19.3.2

input attributes, 26.19.3.4

input connections, 26.19.3.3

output attributes, 26.19.3.6

row locators, 26.19.2, 26.19.3.5

using, 26.19.3

updating

source definitions, 16.1.3

upgrading

business areas, 33.2.3.2

external processes, 33.2.3.2

local variables, 33.2.3.2

mappings, 33.2.3.2

UPPER function, 27.2.24

user defined properties, 34.1

USER function, 27.8.16

user-defined activities, 22.1.24

user-defined objects, 34

adding to repository, 34.3

associating with objects, 34.3.3

associating with other objects, 34.3.3

creating, 34.3.2

defining using scripts, 34.3.1

editing, 34.4

exporting, 34.4.1

importing, 34.4.1

propagating, 34.4.1

viewing, 34.4

user-defined processes, upgrading from external processes, 33.2.3.2

user-defined properties, 34.2

creating, 34.2.1, 34.2.1

deleting, 34.2.1

editing, 34.4

exporting, 34.4.1, 34.4.1

importing, 34.4.1, 34.4.1

propagating, 34.4.1

viewing, 34.4

user-defined types

creating, 12.9

overview, 12.9

USERENV function, 27.8.17

utilities

activities, 22.1.2

Metadata Loader, 33.1.1

utilizing context of pluggable mapping, 6.7.4

V

validating

about, 3.6

data objects, 19

editing invalid objects, 19.3

experts, 35.8

objects, 19.1

validation

about, 3.6

editing invalid objects, 19.3

results, 19.1

results, evaluating, 19.2

viewing details, 19.2.2

validation rules for metadata import, 33.2.2.6

VARCHAR data type, 4.1.3

VARCHAR2 data type, 4.1.3

variables

custom, 35.7.3

substitution, 22.1.13.2

upgrading, 33.2.3.2

Varray Iterator Operator, 25.3.15

varrays

creating, 12.9.5

editing, 12.9.6

overview, 12.9.4

versions

bridges, 17.1.2

Transfer Wizard, 17.1.2

view definitions, 12.5.3

viewing

data, 4.4

data objects, 4.4

user-defined objects, 34.4

user-defined properties, 34.4

viewing scripts, 19.4

views, 12.5

attribute sets, adding, 12.5.3.4

attribute sets, deleting, 12.5.3.4

attribute sets, editing, 12.5.3.4

columns, adding, 12.5.3.2

columns, defining, 12.5.2.2

columns, deleting, 12.5.3.2

columns, editing, 12.5.3.2

configuring, 12.10.5

constraints, adding, 12.5.3.3

constraints, deleting, 12.5.3.3

constraints, editing, 12.5.3.3

defining, 12.5.2

editing, 12.5.3

materialized, 25.3.12

naming, 12.5.2.1

renaming, 12.5.3.1

VSIZE function, 27.8.18

W

wait activity, 22.1.25

Warehouse Builder

best practices, 35

reserved words, 37

WB_ABORT function, 27.1.1

WB_CAL_MONTH_NAME function, 27.5.15

WB_CAL_MONTH_OF_YEAR function, 27.5.16

WB_CAL_MONTH_SHORT_NAME function, 27.5.17

WB_CAL_QTR function, 27.5.18

WB_CAL_WEEK_OF_YEAR function, 27.5.19

WB_CAL_YEAR function, 27.5.20

WB_CAL_YEAR_NAME function, 27.5.21

WB_COMPILE_PLSQL transformation, 27.1.2

WB_DATE_FROM_JULIAN function, 27.5.22

WB_DAY_NAME function, 27.5.23

WB_DAY_OF_MONTH function, 27.5.24

WB_DAY_OF_WEEK function, 27.5.25

WB_DAY_OF_YEAR function, 27.5.26

WB_DAY_SHORT_NAME function, 27.5.27

WB_DECADE function, 27.5.28

WB_DISABLE_ALL_CONSTRAINTS, 27.1.3

WB_DISABLE_ALL_TRIGGERS, 27.1.4

WB_DISABLE_CONSTRAINT, 27.1.5

WB_DISABLE_TRIGGER, 27.1.6

WB_ENABLE_ALL_CONSTRAINTS, 27.1.7

WB_ENABLE_ALL_TRIGGERS, 27.1.8

WB_ENABLE_CONSTRAINT, 27.1.9

WB_ENABLE_TRIGGER, 27.1.10

WB_HOUR12 function, 27.5.29

WB_HOUR12MI_SS function, 27.5.30

WB_HOUR24 function, 27.5.31

WB_HOUR24MI_SS function, 27.5.32

WB_IS_DATE function, 27.5.33

WB_IS_NUMBER function, 27.6.28

WB_IS_SPACE function, 27.2.27

WB_JULIAN_FROM_DATE function, 27.5.34

WB_LOOKUP_CHAR function, 27.2.25, 27.2.26

WB_LOOKUP_NUM function, 27.6.26, 27.6.27

WB_MI_SS function, 27.5.35

WB_OLAP_AW_PRECOMPUTE, 27.7.1

WB_OLAP_LOAD_CUBE, 27.7.2

WB_OLAP_LOAD_DIMENSION, 27.7.3

WB_OLAP_LOAD_DIMENSION_GENUK, 27.7.4

WB_RT_GET_ELAPSED_TIME function, 27.3.1

WB_RT_GET_JOB_METRICS function, 27.3.2

WB_RT_GET_LAST_EXECUTION_TIME, 27.3.3

WB_RT_GET_MAP_RUN_AUDIT function, 27.3.4

WB_RT_GET_NUMBER_OF_ERRORS function, 27.3.5

WB_RT_GET_NUMBER_OF_WARNINGS function, 27.3.6

WB_RT_GET_PARENT_AUDIT_ID function, 27.3.7

WB_RT_GET_RETURN_CODE function, 27.3.8

WB_RT_GET_START_TIME function, 27.3.9

WB_TRUNCATE_TABLE, 27.1.11

WB_WEEK_OF_MONTH function, 27.5.36

WB_XML_LOAD, 27.11.6

WB_XML_LOAD_F, 27.11.7

WHERE (in the Filter operator), 26.8

While Loop activity, 22.1.26

white-box pluggable mapping, 6.7.3

WIDTH_BUCKET function, 27.6.29

wizards

Apply Data Rule Wizard, 20.7.5

Create Correction Wizard, 20.6.1

Create Data Auditor Wizard, 20.9.1

Create Data Rule Folder Wizard, 20.7.2

Create Data Rule Wizard, 20.7.3

Create External Table Wizard, 14.6.1

Create Flat File Wizard, 14.2

Create Sequence Wizard, 12.8.2

Cube Wizard, 13.4.1

Dimension Wizard, 13.1.1

Flat File Sample Wizard, 14.4

Import Metadata Wizard, 14.3, 16.1.1

New Collection Wizard, 3.2.1

Operator, 26.2.1

Pivot Wizard, 26.11.3

Time Dimension Wizard, 13.6.1

Transfer Wizard, 17.1

Unpivot Wizard, 26.19.3

welcome pages, displaying, 3.3.5

words, reserved, 37

workareas, Designer 6i, 16.2

writing SQL expressions, 26.7

X

XML Transformations, 27.11

XMLCONCAT function, 27.11.8

XMLFORMAT data type, 4.1.3

XMLSEQUENCE function, 27.11.9

XMLTRANSFORM function, 27.11.10

XMLTYPE data type, 4.1.3

Z

process flowsSee also process runs