PowerCenter
- PowerCenter 10.5
- All Products
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, Full
| 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, Full
| Source, Full
| Source, Full
| Source, Full
| Source, Full
|
DATE_COMPARE()
| Source, Full
| Source, Full
| Source
| Source, Full
| -
|
DATE_DIFF()
| Source, Full
| -
| -
| 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, Full
| Source, Full
| Source, Full
| Source, Full
| -
|
IIF()
| Source, Full
| Source, Full
| Source, Full
| Source, Full
| Source, Full
|
IN()
| Source, Full
| -
| Source, Full
| -
| Source, Full
|
INITCAP()
| Source, Full
| -
| -
| Source, Full
| Source, Full
|
INSTR()
| -
| -
| Source
| Source, Full
| -
|
ISNULL()
| Source, Full
| 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, Full
| Source, Full
| Source, Full
| Source, Full
| Source, Full
|
MIN()
| Source, Full
| Source, Full
| Source, Full
| Source, Full
| Source, Full
|
MOD()
| Source, Full
| 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, Full
| -
| Source, Full
| Source, Full
| Source, Full
|
SUBSTR()
| Source, Full
| Source, Full
| Source
| Source, Full
| Source, Full
|
SUM()
| Source, Full
| 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, Full
| -
| Source, Full
| Source, Full
| Source, Full
|
*If a function is not listed, the Integration Service cannot push that function to any database.
|