Developer Mapping Guide

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

Back Next

Operators

The following table summarizes the availability of Informatica operators by source type. Each column displays whether the Data Integration Service can push the operator to the source.

Nonrelational sources are IMS, VSAM, and sequential data sets on

z/OS

Operator	DB2 for LUW	DB2 for i5/OS or z/OS ^*	Greenplum	Hive	Microsoft SQL Server	Nonrelational^*	Oracle	SAP^*	SAP HANA	Sybase ASE	Teradata
+ - *	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	Yes	Yes	Yes
/	Yes	Yes	Yes	Yes	Yes	No	Yes	No	Yes	Yes	Yes
%	Yes	Yes	Yes	Yes	Yes	No	Yes	No	Yes	Yes	Yes
\|\|	Yes	Yes	Yes	Yes	Yes	No	Yes	No	Yes	Yes	Yes
= > < >= <=	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
<>	Yes	Yes	Yes	Yes	Yes	No	Yes	Yes	Yes	Yes	Yes
!=	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
^=	Yes	Yes	Yes	Yes	Yes	No	Yes	Yes	Yes	Yes	Yes
AND OR	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
NOT	Yes	Yes	Yes	Yes	Yes	No	Yes	No	Yes	Yes	Yes