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, 3.5.1

accessibility in Oracle documentation, Preface

accessing

transformation libraries, 3.1.2.3

ACOS function, 3.5.2

ADD_MONTHS, 3.4.1

administrative transformations, 3.2

aggregator operator, 2.1.12

Americans with Disabilities Act (ADA) compliance, Preface

ASCII, 3.3.1

ASCIISTR, 3.3.2

ASIN function, 3.5.3

ATAN function, 3.5.4

ATAN2 function, 3.5.5

AVG, 2.1.12.1

B

books

accessibility, Preface

C

CEIL, 3.5.8

character transformations, 3.3

CHARTOROWID, 3.3.3

CHR, 3.3.4

CONCAT, 3.3.5

constant operator, 2.1.13

contacting Oracle

conventions

used in this guide, Preface

CONVERT, 3.3.6

COS function, 3.5.6

COSH function, 3.5.7

COUNT, 2.1.12.2

CURRVAL, 2.1.6

Sequence operator, 2.1.6

D

data cleansing operators, 2.2

data quality

Match-Merge operator, 2.2.2

data transformation, 3.1.1

datatypes

ZONED, Preface

Date Transformations, 3.4

date transformations, 3.4

Deduplicator operator, 2.1.1

disabilities, documentation accessibility, Preface

DISTINCT, 2.1.1

documentation

ordering, for Warehouse Builder

E

EXP, 3.5.9

F

features

new in this release

new in this release See also Oracle Warehouse Builder Release Notes

Filter operator, 2.1.2

FLOOR, 3.5.10, 3.5.10

FULL OUTER JOIN, 2.1.3

functions

Global Shared Library, 3.1.2.1

G

geocoding, 2.2.1

Global Shared Library, 3.1.2.1

GROUP BY, 2.1.12

guides

accessibility, Preface

available for Warehouse Builder, Preface

H

HAVING, 2.1.12

householding, 2.2.2

Match-Merge operator, 2.2.2

I

importing

PL/SQL Packages, 3.1.2.4

INITCAP, 3.3.7

installing Warehouse Builder See Oracle Warehouse Builder Installation and Configuration Guide

INSTR /INSTRB, 3.3.8

INTERSECT, 2.1.7

J

Joiner operator, 2.1.3

K

key

surrogate, 2.1.6

Key Lookup operator, 2.1.4

L

LAST_DAY, 3.4.2

LENGTH/LENGTHB, 3.3.9

LN function, 3.5.11

LOG function, 3.5.12

LOWER, 3.3.10

LPAD, 3.3.11

LTRIM, 3.3.12

M

manuals

accessibility, Preface

available for Warehouse Builder, Preface

mapping operators

Match-Merge operator, 2.2.2

Pivot operator, 2.1.5

Unpivot operator, 2.1.11

Match-Merge operator, 2.2.2

design considerations, 2.2.2.2

example, 2.2.2.1

MAX, 2.1.12.3

MetaLink

MIN, 2.1.12.4

MINUS, 2.1.7

MOD, 3.5.13

MONTHS_BETWEEN, 3.4.3

N

Name and Address operator, 2.2.1

new features

See also Oracle9i Warehouse Builder Release Notes

NEW_TIME, 3.4.4

NEXT_DAY, 3.4.5

NEXTVAL, 2.1.6

Sequence operator, 2.1.6

NLS_CHARSET_DECL_LEN function, 3.9.1

NLS_CHARSET_ID function, 3.9.2

NLS_CHARSET_NAME function, 3.9.3

NLS_INITCAP function, 3.3.14

NLS_LOWER function, 3.3.15

NLS_UPPER function, 3.3.16

NLSSORT function, 3.3.13

NONE, 2.1.12.4

Number Transformations, 3.5

number transformations, 3.5

NVL, 2.1.4

O

OLAP transformations, 3.6

operators

aggregator, 2.1.12

constant, 2.1.13

data cleansing, 2.2

Deduplicator operator, 2.1.1

Filter, 2.1.2

Joiner, 2.1.3

Key Lookup operator, 2.1.4

Match-Merge operator, 2.2.2

Name and Address, 2.2.1

Pivot operator, 2.1.5

sequence, 2.1.6

Sequence operator, 2.1.6

Set operator, 2.1.7

SQL, 2.1

transformation operators, 2

Unpivot operator, 2.1.11

Oracle

accessibility

Oracle Library, 3.1.2.2

Oracle Transformation Libraries, 3.1.2

Oracle, contacting

OracleMetaLink

ORDER BY, 2.1.8

other (non-SQL) transformations, 3.9

P

Pivot operator

about, 2.1.5

example, 2.1.5.1

PL/SQL

importing PL/SQL packages, 3.1.2.4

POWER, 3.5.14

procedures

Global Shared Library, 3.1.2.1

R

ROUND, 3.4.6, 3.5.15

RPAD, 3.3.18

RTRIM, 3.3.19

S

Section 508 compliance, Preface

sequence, 2.1.6

Sequence operator, 2.1.6

Set operator, 2.1.7

SIGN, 3.5.16

SIN function, 3.5.17

SINH function, 3.5.18

Sorter operator

operators

Sorter operator, 2.1.8

SOUNDEX, 3.3.20

Splitter operator

operators

Splitter operator, 2.1.9

SQL Operators, 2.1

SQRT, 3.5.19

STDDEV, 2.1.12.5

STDDEV_POP, 2.1.12.6

STDDEV_SAMP, 2.1.12.7

SUBSTR, 3.3.21

SUM, 2.1.12.8

surrogate key, 2.1.6

SYSDATE, 2.1.13.1

SYSDATE function, 3.4.7

SYSTIMESTAMP, 2.1.13.2

T

Table Function operator, 2.1.10

TAN function, 3.5.20

TANH function, 3.5.21

TO_CHAR, 3.4.8, 3.5.22

TO_DATE, 3.3.22

TO_MULTI_BYTE, 3.3.23

TO_NUMBER, 3.3.24

TO_SINGLE_BYTE, 3.3.25

transformation libraries

about, 3.1.2

accessing, 3.1.2.3

Global Shared Library, 3.1.2

Oracle Library, 3.1.2

Transformation Operators, 2

transformations

about, 3.1.1, 3.1.1

administrative, 3.2

character, 3.3

date, 3.4, 3.4

functions, 3.1.1

imported package, 3.1.1

number, 3.5, 3.5

OLAP, 3.6

operators, 2

other (non-SQL), 3.9

overview, 3.1.1

predefined, 3.1.1

procedures, 3.1.1

user transformation package, 3.1.1

XML, 3.7

transformations See also Oracle Warehouse Builder Transformation Guide

TRANSLATE, 3.3.26

TRIM, 3.3.27

TRUNC, 3.4.9, 3.5.23

U

UID, 3.9.4

UNION, 2.1.7

UNION ALL, 2.1.7

Unpivot operator

about, 2.1.11

example, 2.1.11.1

updates

to Warehouse Builder documentation

UPPER, 3.3.28

USER, 3.9.5

user manuals

accessibility, Preface

User Transformation Package, 3.1.1

User's Guide

conventions, Preface

V

VAR_POP, 2.1.12.9

VAR_SAMP, 2.1.12.10

VARIANCE, 2.1.12.11

W

Warehouse Builder

documentation for, Preface

new features in this release

to order documentation

WB_ABORT, 3.2.1

WB_ANALYZE_SCHEMA, 3.2.2

WB_ANALYZE_TABLE, 3.2.3

WB_CAL_MONTH_NAME, 3.4.10

WB_CAL_MONTH_OF_YEAR, 3.4.11

WB_CAL_MONTH_SHORT_NAME, 3.4.12

WB_CAL_QTR, 3.4.13

WB_CAL_WEEK_OF_YEAR, 3.4.14

WB_CAL_YEAR, 3.4.15

WB_CAL_YEAR_NAME, 3.4.16

WB_COMPILE_PLSQL, 3.2.4

WB_DATE_FROM_JULIAN, 3.4.17

WB_DAY_NAME, 3.4.18

WB_DAY_OF_MONTH, 3.4.19

WB_DAY_OF_WEEK, 3.4.20

WB_DAY_OF_YEAR, 3.4.21

WB_DAY_SHORT_NAME, 3.4.22

WB_DECADE, 3.4.23

WB_DISABLE_ALL_CONSTRAINTS, 3.2.5

WB_DISABLE_ALL_TRIGGERS, 3.2.6

WB_DISABLE_CONSTRAINT, 3.2.7

WB_DISABLE_TRIGGER, 3.2.8

WB_ENABLE_ALL_CONSTRAINTS, 3.2.9

WB_ENABLE_ALL_TRIGGERS, 3.2.10

WB_ENABLE_CONSTRAINT, 3.2.11

WB_ENABLE_TRIGGER, 3.2.12

WB_HOUR12, 3.4.24

WB_HOUR12MI_SS, 3.4.25

WB_HOUR24, 3.4.26

WB_HOUR24MI_SS, 3.4.27

WB_IS_DATE, 3.4.28

WB_IS_NUMBER, 3.5.26

WB_IS_SPACE, 3.3.31

WB_JULIAN_FROM_DATE, 3.4.29

WB_MI_SS, 3.4.30

WB_OLAP_LOAD_CUBE, 3.6.1

WB_OLAP_LOAD_DIMENSION, 3.6.2

WB_OLAP_LOAD_DIMENSION_GENUK, 3.6.3

WB_TRUNCATE_TABLE, 3.2.13

WB_WEEK_OF_MONTH, 3.4.31

WB_XML_LOAD, 3.7.1

WB_XML_LOAD_F, 3.7.2

WB.LOOKUP_CHAR, 3.3.29, 3.3.30

WB.LOOKUP_NUM, 3.5.24, 3.5.25

WHERE, 2.1.2, 2.1.9

X

XML Transformations, 3.7

Z

ZONED, Preface