Developer Mapping Guide

10.4.0
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5
- 10.4.1
- 10.2.2
- 10.2.1

Back Next

Functions for Relational Databases

The following table summarizes the availability of Informatica functions in relational databases. Columns marked with Yes indicate that the function can be pushed to the database by using source-side or full pushdown optimization. If a function is not listed, the Integration Service cannot push that function to any database.

Function	DB2 for LUW	Microsoft SQL Server	ODBC	Oracle	Sybase ASE
ABS()	Yes	Yes	Yes	Yes	Yes
ADD_TO_DATE()	Yes	Yes	No	Yes	Yes
ASCII()	Yes	Yes	No	Yes	Yes
CEIL()	Yes	Yes	No	Yes	Yes
CHR()	Yes	Yes	No	Yes	Yes
CONCAT()	Yes	Yes	No	Yes	Yes
COS()	Yes	Yes	Yes	Yes	Yes
COSH()	Yes	Yes	No	Yes	Yes
DATE_COMPARE()	Yes	Yes	Yes	Yes	Yes
DECODE()	Yes	Yes	Yes	Yes	Yes
EXP()	Yes	Yes	Yes	n/a	Yes
FLOOR()	No	Yes	No	Yes	Yes
GET_DATE_PART()	Yes	Yes	No	Yes	Yes
IIF()	Yes	Yes	Yes	No	Yes
IN()	No	Yes	Yes	No	Yes
INITCAP()	No	No	No	Yes	No
INSTR()	Yes	Yes	No	Yes	Yes
ISNULL()	Yes	Yes	Yes	Yes	Yes
LAST_DAY()	No	No	No	Yes	n/a
LENGTH()	Yes	Yes	No	Yes	Yes
LN()	Yes	No	No	Yes	Yes
LOG()	Yes	Yes	No	Yes	Yes
LOOKUP()	No	No	Yes	No	No
LOWER()	Yes	Yes	Yes	Yes	Yes
LPAD()	No	No	No	Yes	n/a
LTRIM()	X	Yes	No	Yes	Yes
MOD()	X	Yes	No	Yes	Yes
POWER()	X	Yes	No	Yes	Yes
ROUND(DATE)	No	No	No	Yes	n/a
ROUND(NUMBER)	Yes	Yes	No	Yes	Yes
RPAD()	No	No	No	Yes	No
RTRIM()	Yes	Yes	No	Yes	Yes
SIGN()	Yes	Yes	No	Yes	Yes
SIN()	Yes	Yes	Yes	Yes	Yes
SINH()	Yes	Yes	No	Yes	Yes
SOUNDEX()	Yes¹	Yes	No	Yes	Yes
SQRT()	Yes	Yes	Yes	Yes	Yes
SUBSTR()	Yes	Yes	No	Yes	Yes
SYSDATE()	Yes	Yes	No	Yes	Yes
SYSTIMESTAMP()	Yes	Yes	No	Yes	Yes
TAN()	Yes	Yes	Yes	Yes	Yes
TANH()	Yes	Yes	No	Yes	Yes
TO_BIGINT	Yes	Yes	No	Yes	Yes
TO_CHAR(DATE)	Yes	Yes	No	Yes	Yes
TO_CHAR(NUMBER)	Yes²	Yes	No	Yes	Yes
TO_DATE()	Yes	Yes	No	Yes	Yes
TO_DECIMAL()	Yes³	Yes	No	Yes	Yes
TO_FLOAT()	Yes	Yes	No	Yes	Yes
TO_INTEGER()	Yes	Yes	No	Yes	Yes
TRUNC(DATE)	No	No	No	Yes	No
TRUNC(NUMBER)	Yes	Yes	No	Yes	Yes
UPPER()	Yes	Yes	Yes	Yes	Yes