Skip Headers
Oracle® Warehouse Builder Transformation Guide
10
g
Release 2 (10.2)
Part Number B28227-01
Home
Book List
Index
Contact Us
Next
View PDF
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Conventions
Related Publications
1
Introducing Oracle Warehouse Builder Transformations
About Transformations
Types of Transformations
Predefined Transformations
Custom Transformations
Transforming Data Using Warehouse Builder
Benefits of Using Warehouse Builder for Transforming Data
About Transformation Libraries
Types of Transformation Libraries
Accessing Transformation Libraries
Defining Custom Transformations
Defining Functions and Procedures
Name and Description Page
Parameters Page
Implementation Page
Summary Page
Defining PL/SQL Types
Name and Description Page
Attributes Page
Return Type Page
Summary Page
Editing Transformation Properties
Editing Function or Procedure Definitions
Name Tab
Parameters Tab
Implementation Tab
Editing PL/SQL Types
Name Tab
Attributes Tab
Return Type Tab
Importing PL/SQL
2
Transformations
Administrative Transformations
WB_ABORT
WB_COMPILE_PLSQL
WB_DISABLE_ALL_CONSTRAINTS
WB_DISABLE_ALL_TRIGGERS
WB_DISABLE_CONSTRAINT
WB_DISABLE_TRIGGER
WB_ENABLE_ALL_CONSTRAINTS
WB_ENABLE_ALL_TRIGGERS
WB_ENABLE_CONSTRAINT
WB_ENABLE_TRIGGER
WB_TRUNCATE_TABLE
Character Transformations
ASCII
CHR
CONCAT
INITCAP
INSTR, INSTR2, INSTR4, INSTRB, INSTRC
LENGTH, LENGTH2, LENGTH4, LENGTHB, LENGTHC
LOWER
LPAD
LTRIM
NLSSORT
NLS_INITCAP
NLS_LOWER
NLS_UPPER
REPLACE
REGEXP_INSTR
REGEXP_REPLACE
REGEXP_SUBSTR
RPAD
RTRIM
SOUNDEX
SUBSTR, SUBSTR2, SUBSTR4, SUBSTRB, SUBSTRC
TRANSLATE
TRIM
UPPER
WB_LOOKUP_CHAR (number)
WB_LOOKUP_CHAR (varchar2)
WB_IS_SPACE
Control Center Transformations
WB_RT_GET_ELAPSED_TIME
WB_RT_GET_JOB_METRICS
WB_RT_GET_LAST_EXECUTION_TIME
WB_RT_GET_MAP_RUN_AUDIT
WB_RT_GET_NUMBER_OF_ERRORS
WB_RT_GET_NUMBER_OF_WARNINGS
WB_RT_GET_PARENT_AUDIT_ID
WB_RT_GET_RETURN_CODE
WB_RT_GET_START_TIME
Conversion Transformations
ASCIISTR
COMPOSE
CONVERT
HEXTORAW
NUMTODSINTERVAL
NUMTOYMINTERVAL
RAWTOHEX
RAWTONHEX
SCN_TO_TIMESTAMP
TIMESTAMP_TO_SCN
TO_BINARY_DOUBLE
TO_BINARY_FLOAT
TO_CHAR
TO_CLOB
TO_DATE
TO_DSINTERVAL
TO_MULTI_BYTE
TO_NCHAR
TO_NCLOB
TO_NUMBER
TO_SINGLE_BYTE
TO_TIMESTAMP
TO_TIMESTAMP_TZ
TO_YMINTERVAL
UNISTR
Date Transformations
ADD_MONTHS
CURRENT_DATE
DBTIMEZONE
FROM_TZ
LAST_DAY
MONTHS_BETWEEN
NEW_TIME
NEXT_DAY
ROUND (date)
SESSIONTIMEZONE
SYSDATE
SYSTIMESTAMP
SYS_EXTRACT_UTC
TRUNC (date)
WB_CAL_MONTH_NAME
WB_CAL_MONTH_OF_YEAR
WB_CAL_MONTH_SHORT_NAME
WB_CAL_QTR
WB_CAL_WEEK_OF_YEAR
WB_CAL_YEAR
WB_CAL_YEAR_NAME
WB_DATE_FROM_JULIAN
WB_DAY_NAME
WB_DAY_OF_MONTH
WB_DAY_OF_WEEK
WB_DAY_OF_YEAR
WB_DAY_SHORT_NAME
WB_DECADE
WB_HOUR12
WB_HOUR12MI_SS
WB_HOUR24
WB_HOUR24MI_SS
WB_IS_DATE
WB_JULIAN_FROM_DATE
WB_MI_SS
WB_WEEK_OF_MONTH
Number Transformations
ABS
ACOS
ASIN
ATAN
ATAN2
BITAND
CEIL
COS
COSH
EXP
FLOOR
LN
LOG
MOD
NANVL
POWER
REMAINDER
ROUND (number)
SIGN
SIN
SINH
SQRT
TAN
TANH
TRUNC (number)
WB_LOOKUP_NUM (on a number)
WB_LOOKUP_NUM (on a varchar2)
WB_IS_NUMBER
WIDTH_BUCKET
OLAP Transformations
WB_OLAP_AW_PRECOMPUTE
WB_OLAP_LOAD_CUBE
WB_OLAP_LOAD_DIMENSION
WB_OLAP_LOAD_DIMENSION_GENUK
Other Transformations
DEPTH
DUMP
EMPTY_BLOB, EMPTY_CLOB
NLS_CHARSET_DECL_LEN
NLS_CHARSET_ID
NLS_CHARSET_NAME
NULLIF
NVL
NVL2
ORA_HASH
PATH
SYS_CONTEXT
SYS_GUID
SYS_TYPEID
UID
USER
USERENV
VSIZE
Spatial Transformations
SDO_AGGR_CENTROID
SDO_AGGR_CONVEXHULL
SDO_AGGR_MBR
SDO_AGGR_UNION
Streams Transformations
REPLICATE
XML Transformations
EXISTSNODE
EXTRACT
EXTRACTVALUE
SYS_XMLAGG
SYS_XMLGEN
WB_XML_LOAD
WB_XML_LOAD_F
XMLCONCAT
XMLSEQUENCE
XMLTRANSFORM
Index
Scripting on this page enhances content navigation, but does not change the content in any way.