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-56
- accessibility
- of documentation, 1-xxiii
- accessing
- transformation libraries, 3-3
- ADD_MONTHS, 3-36
- administrative transformations, 3-4
- aggregator operator, 2-26
- ASCII, 3-16
- ASCIISTR, 3-16
- assistants
- Browser Assistant See Oracle9i Warehouse Builder Installation and Configuration Guide
- Repository Assistant See Oracle9i Warehouse Builder Installation and Configuration Guide
- Runtime Assistant See Oracle9i Warehouse Builder Installation and Configuration Guide
- AVG, 2-29
B
- Browser Assistant See Oracle9i Warehouse Builder Installation and Configuration Guide
C
- CEIL, 3-56
- character transformations, 3-15
- CHARTOROWID, 3-17
- CHR, 3-17
- CONCAT, 3-18
- constant operator, 2-37
- conventions
- used in this guide, 1-xxii
- CONVERT, 3-19
- COUNT, 2-30
- CURRVAL, 2-13
- Sequence operator, 2-13
D
- data cleansing operators, 2-39
- data quality
- Match-Merge operator, 2-40
- data transformation, 3-1
- datatypes
- ZONED, 1-xv
- Date Transformations, 3-36
- date transformations, 3-36
- Deduplicator operator, 2-1
- DISTINCT, 2-1
- documentation
- ordering, for Warehouse Builder, 1-xxiii
E
- EXP, 3-57
F
- features
- new in this release, 1-xvi
- new in this release See also Oracle9i Warehouse Builder Release Notes
- Filter operator, 2-2
- FLOOR, 3-57
- FULL OUTER JOIN, 2-5
- functions
- Global Shared Library, 3-2
G
- geocoding, 2-40
- Global Shared Library, 3-2
- GROUP BY, 2-26
- guides
- available for Warehouse Builder, 1-xxii
H
- HAVING, 2-26
- householding, 2-41
- Match-Merge operator, 2-40
I
- importing
- PL/SQL Packages, 3-3
- INITCAP, 3-20
- installing
- Warehouse Builder See Oracle9i Warehouse Builder Installation and Configuration Guide
- INSTR / INSTRB, 3-20
- INTERSECT, 2-15
J
- Joiner operator, 2-5
K
- key
- surrogate, 2-13
- Key Lookup operator, 2-8
L
- LAST_DAY, 3-36
- LENGTH/LENGTHB, 3-22
- LOWER, 3-22
- LPAD, 3-23
- LTRIM, 3-24
M
- manuals
- available for Warehouse Builder, 1-xxii
- mapping operators
- Match-Merge operator, 2-40
- Pivot operator, 2-11
- Unpivot operator, 2-25
- mappings
- transformations See also Oracle9i Warehouse Builder Transformation Guide
- Match-Merge operator, 2-40
- design considerations, 2-41
- example, 2-41
- MAX, 2-30
- Metalink, 1-xxiii
- MIN, 2-31
- MINUS, 2-15
- MOD, 3-58
- MONTHS_BETWEEN, 3-37
N
- Name and Address operator, 2-39
- new features, 1-xvi
- See also Oracle9i Warehouse Builder Release Notes
- NEW_TIME, 3-38
- NEXT_DAY, 3-39
- NEXTVAL, 2-13
- Sequence operator, 2-13
- NONE, 2-31
- Number Transformations, 3-56
- number transformations, 3-56
- NVL, 2-11
O
- operators
- aggregator, 2-26
- constant, 2-37
- data cleansing, 2-39
- Deduplicator operator, 2-1
- Filter, 2-2
- Joiner, 2-5
- Key Lookup operator, 2-8
- Match-Merge operator, 2-40
- Name and Address, 2-39
- Pivot operator, 2-11
- sequence, 2-13
- Sequence operator, 2-13
- Set operator, 2-15
- SQL, 2-1
- transformation operators, 2-1
- Unpivot operator, 2-25
- Oracle Library, 3-3
- Oracle Metalink, 1-xxiii
- Oracle Transformation Libraries, 3-2
- ORDER BY, 2-17
- other (non-SQL) transformations, 3-69
P
- Pivot operator
- about, 2-11
- example, 2-11
- PL/SQL
- importing PL/SQL packages, 3-3
- POWER, 3-58
- procedures
- Global Shared Library, 3-3
R
- repositories
- installing See Oracle9i Warehouse Builder Installation and Configuration Guide
- Repository Assistant See Oracle9i Warehouse Builder Installation and Configuration Guide
- ROUND, 3-39, 3-59
- RPAD, 3-25
- RTRIM, 3-26
- Runtime Assistant See Oracle9i Warehouse Builder Installation and Configuration Guide
S
- sequence, 2-13
- Sequence operator, 2-13
- Set operator, 2-15
- SIGN, 3-59
- Sorter operator
- operators
- Sorter operator, 2-17
- SOUNDEX, 3-26
- Splitter operator
- operators
- Splitter operator, 2-20
- SQL Operators, 2-1
- SQRT, 3-60
- STDDEV, 2-33
- STDDEV_POP, 2-34
- STDDEV_SAMP, 2-34
- SUBSTR, 3-27
- SUM, 2-35
- support web site, 1-xxiii
- surrogate key, 2-13
- SYSDATE, 2-38
- SYSTIMESTAMP, 2-38
T
- Table Function operator, 2-24
- TO_CHAR, 3-40, 3-60
- TO_DATE, 3-29
- TO_MULTI_BYTE, 3-29
- TO_NUMBER, 3-30
- TO_SINGLE_BYTE, 3-31
- transformation libraries
- about, 3-2
- accessing, 3-3
- Global Shared Library, 3-2
- Oracle Library, 3-2
- Transformation Operators, 2-1
- transformations
- about, 3-1
- administrative, 3-4
- character, 3-15
- date, 3-36
- functions, 3-2
- imported package, 3-2
- number, 3-56
- operators, 2-1
- other (non-SQL), 3-69
- overview, 3-1
- predefined, 3-2
- procedures, 3-2
- user transformation package, 3-1
- XML, 3-64
- transformations See also Oracle9i Warehouse Builder Transformation Guide
- TRANSLATE, 3-31
- TRIM, 3-32
- TRUNC, 3-40, 3-61
U
- UID, 3-70
- UNION, 2-15
- UNION ALL, 2-15
- Unpivot operator
- about, 2-25
- example, 2-25
- updates
- to Warehouse Builder documentation, 1-xxiii
- UPPER, 3-33
- USER, 3-70
- User Transformation Package, 3-1
- Transformation Guide
- conventions, 1-xxii
- related documents, 1-xxii
- to order documentation, 1-xxiii
- updates available at, 1-xxiii
V
- VAR_POP, 2-35
- VAR_SAMP, 2-36
- VARIANCE, 2-37
W
- Warehouse Builder
- accessibility, 1-xxiii
- documentation for, 1-xxii
- new features in this release, 1-xvi
- to order documentation, 1-xxiii
- WB_ABORT, 3-4
- WB_ANALYZE_SCHEMA, 3-4
- WB_ANALYZE_TABLE, 3-5
- WB_CAL_MONTH_NAME, 3-41
- WB_CAL_MONTH_OF_YEAR, 3-42
- WB_CAL_MONTH_SHORT_NAME, 3-42
- WB_CAL_QTR, 3-43
- WB_CAL_WEEK_OF_YEAR, 3-44
- WB_CAL_YEAR, 3-44
- WB_CAL_YEAR_NAME, 3-45
- WB_COMPILE_PLSQL, 3-5
- WB_DATE_FROM_JULIAN, 3-46
- WB_DAY_NAME, 3-46
- WB_DAY_OF_MONTH, 3-47
- WB_DAY_OF_WEEK, 3-47
- WB_DAY_OF_YEAR, 3-48
- WB_DAY_SHORT_NAME, 3-49
- WB_DECADE, 3-49
- WB_DISABLE_ALL_CONSTRAINTS, 3-6
- WB_DISABLE_ALL_TRIGGERS, 3-7
- WB_DISABLE_CONSTRAINT, 3-8
- WB_DISABLE_TRIGGER, 3-10
- WB_ENABLE_ALL_CONSTRAINTS, 3-10
- WB_ENABLE_ALL_TRIGGERS, 3-12
- WB_ENABLE_CONSTRAINT, 3-12
- WB_ENABLE_TRIGGER, 3-14
- WB_HOUR12, 3-50
- WB_HOUR12MI_SS, 3-51
- WB_HOUR24, 3-52
- WB_HOUR24MI_SS, 3-52
- WB_IS_DATE, 3-53
- WB_IS_NUMBER, 3-64
- WB_IS_SPACE, 3-35
- WB_JULIAN_FROM_DATE, 3-54
- WB_MI_SS, 3-54
- WB_TRUNCATE_TABLE, 3-15
- WB_WEEK_OF_MONTH, 3-55
- WB_XML_LOAD, 3-65
- WB_XML_LOAD_F, 3-66
- WB.LOOKUP_CHAR, 3-33, 3-34
- WB.LOOKUP_NUM, 3-62, 3-63
- WHERE, 2-2, 2-20
X
- XML Transformations, 3-64
Z
- ZONED, 1-xv
