Table of Contents

Search

  1. Preface
  2. Understanding Pipeline Partitioning
  3. Partition Points
  4. Partition Types
  5. Pushdown Optimization
  6. Pushdown Optimization and Transformations
  7. Real-time Processing
  8. Commit Points
  9. Row Error Logging
  10. Workflow Recovery
  11. Stopping and Aborting
  12. Concurrent Workflows
  13. Grid Processing
  14. Load Balancer
  15. Workflow Variables
  16. Parameters and Variables in Sessions
  17. Parameter Files
  18. FastExport
  19. External Loading
  20. FTP
  21. Session Caches
  22. Incremental Aggregation
  23. Session Log Interface
  24. Understanding Buffer Memory
  25. High Precision Data

Advanced Workflow Guide

Advanced Workflow Guide

Functions for Relational Databases

Functions for Relational Databases

The following table summarizes the availability of PowerCenter functions in relational databases. Columns marked with All indicate that the function can be pushed to the database by using source-side, target-side, or full pushdown optimization. If a function is not listed, the Integration Service cannot push that function to any database.
Function*
DB2
Microsoft SQL
Server
Oracle
Sybase ASE
ABS()
All
All
All
All
ADD_TO_DATE()
All
Source
All
Source
ASCII()
All
All
All
All
AVG()
All
All
All
All
CEIL()
All
All
All
All
CHR()
All
All
All
All
CONCAT()
Source
Source
All
Source
COS()
All
All
All
All
COSH()
All
Source
All
Source
COUNT()
All
All
All
All
DATE_COMPARE()
Source
Source
Source
Source
DECODE()
All
All
All
All
EXP()
All
All
All
All
FLOOR()
All
All
All
All
GET_DATE_PART()
All
All
All
All
GREATEST()
-
-
All
-
IIF()
All
All
All
All
IN()
All
All
All
All
INITCAP()
-
-
All
-
INSTR()
Source
All
All
Source
ISNULL()
All
All
All
All
LAST_DAY()
-
-
All
-
LEAST()
-
-
All
-
LENGTH()
All
All
All
All
LOG()
All
Source
All
Source
LOOKUP
All
All
All
All
LOWER()
All
All
All
All
LPAD()
-
-
All
-
LTRIM()
All
All
All
All
MAX()
All
All
All
All
MIN()
All
All
All
All
MOD()
All
All
All
All
POWER()
All
All
All
All
ROUND(DATE)
-
-
All
-
ROUND(NUMBER)
All
All
All
All
RPAD()
-
-
All
-
RTRIM()
All
All
All
All
SIGN()
All
All
All
All
SIN()
All
All
All
All
SINH()
All
Source
All
Source
SOUNDEX()
All
All
All
All
SQRT()
All
All
All
All
STDDEV()
All
All
All
-
SUBSTR()
Source
Source
All
Source
SUM()
All
All
All
All
SYSDATE()
All
All
All
All
SYSTIMESTAMP()
All
All
All
All
TAN()
All
All
All
All
TANH()
All
Source
All
Source
TO_BIGINT
All
All
All
All
TO_CHAR(DATE)
All
All
All
All
TO_CHAR(NUMBER)
All
All
All
All
TO_DATE()
All
All
All
All
TO_DECIMAL()
All
All
All
All
TO_FLOAT()
All
All
All
All
TO_INTEGER()
All
Source
All
All
TRUNC(DATE)
-
-
All
-
TRUNC(NUMBER)
All
All
All
Source
UPPER()
All
All
All
All
VARIANCE()
All
All
All
-