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