PowerCenter
- PowerCenter 10.4.1
- All Products
Amazon Redshift*
| Amazon Redshift
| Google BigQuery
| Snowflake
|
---|---|---|---|
ABS()
| Source, Full
| Source, Full
| Source, Full
|
ADD_TO_DATE()
| Source, Full
| Source, Full
Supports Date data type.
| -
|
ASCII()
| -
| -
| Source, Full
|
AVG()
| Source
| Source, Full
| Source, Full
|
CEIL()
| Source, Full
| 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
Supports Date data type.
| 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
| Source, Full
|
IS_DATE()
| -
| Source, Full
| -
|
ISNULL()
| Source
| Source, Full
| Source, Full
|
LAST_DAY()
| Source, Full
| Source, Full
Supports Date data type.
| 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)
| -
| Source, Full
Supports Timestamp data type.
| -
|
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
| Source, Full
|
SYSTIMESTAMP()
| Source
| Source, Full
Supports no format.
| 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
Supports Timestamp data type.
| -
|
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.
|