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

Functions for Cloud Data Warehouse Applications

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


Updated February 21, 2021