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 Data Warehouse Applications

Functions for Data Warehouse Applications

The following table summarizes the availability of PowerCenter functions in data warehouse applications:
Function*
Greenplum
Netezza
Teradata
Vertica
PostgreSQL
ABS()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
ADD_TO_DATE()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
ASCII()
Source, Full
Source, Full
-
Source, Full
Source, Full
AVG()
Source
Source, Full
Source, Full
Source, Full
Source, Full
CEIL()
Source, Full
Source, Full
Source
Source
Source, Full
CHR()
Source, Full
Source, Full
-
Source, Full
Source, Full
CONCAT()
Source, Full
-
Source
Source, Full
Source, Full
COS()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
COSH()
Source, Full
Source, Full
Source, Full
Source, Full
-
COUNT()
Source
Source, Full
Source, Full
Source, Full
Source, Full
DATE_COMPARE()
Source
Source, Full
Source
Source, Full
-
DATE_DIFF()
Source
-
-
Source, Full
Source, Full
DECODE()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
EXP()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
FLOOR()
Source, Full
Source, Full
Source
Source, Full
Source, Full
GET_DATE_PART()
Source
Source, Full
Source, Full
Source, Full
-
IIF()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
IN()
Source
-
Source, Full
-
Source, Full
INITCAP()
Source, Full
-
-
Source, Full
Source, Full
INSTR()
-
-
Source
Source, Full
-
ISNULL()
Source
Source, Full
Source, Full
Source, Full
Source, Full
LAST_DAY()
-
-
-
Source, Full
Source, Full
LENGTH()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
LN()
Source, Full
Source, Full
-
Source, Full
Source, Full
LOG()
Source, Full
Source, Full
Source
Source
Source, Full
LOOKUP
-
Source, Full
Source, Full
Source, Full
Source, Full
LOWER()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
LPAD()
Source, Full
Source, Full
-
Source, Full
Source, Full
LTRIM()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
MAX()
Source
Source, Full
Source, Full
Source, Full
Source, Full
MIN()
Source
Source, Full
Source, Full
Source, Full
Source, Full
MOD()
Source
Source, Full
Source, Full
Source, Full
Source, Full
POWER()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
ROUND(NUMBER)
Source, Full
Source, Full
Source
Source
Source, Full
RPAD()
Source, Full
Source, Full
-
Source, Full
Source, Full
RTRIM()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
SIGN()
Source, Full
Source, Full
Source
Source
Source, Full
SIN()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
SINH()
Source, Full
Source, Full
Source, Full
Source, Full
-
SQRT()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
STDDEV()
Source
-
Source, Full
Source, Full
Source, Full
SUBSTR()
Source, Full
Source, Full
Source
Source, Full
Source, Full
SUM()
Source
Source, Full
Source, Full
Source, Full
Source, Full
SYSDATE()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
SYSTIMESTAMP()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
TAN()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
TANH()
Source, Full
Source, Full
Source, Full
Source, Full
-
TO_BIGINT
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
TO_CHAR(DATE)
Source, Full
Source, Full
Source
Source, Full
Source, Full
TO_CHAR(NUMBER)
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
TO_DATE()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
TO_DECIMAL()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
TO_FLOAT()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
TO_INTEGER()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
TRUNC(DATE)
Source, Full
Source, Full
-
Source
-
TRUNC(NUMBER)
Source, Full
Source, Full
Source
Source
Source, Full
UPPER()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
VARIANCE()
Source
-
Source, Full
Source, Full
Source, Full
*If a function is not listed, the Integration Service cannot push that function to any database.


Updated February 21, 2021