The Data Integration Service can push down transformation logic that contains the TO_DATE function when TO_DATE converts a DATS, TIMS, or ACCP data type character string to one of the following date formats:

MM/DD/YYYY
YYYY/MM/DD
YYYY-MM-DD HH24:MI:SS
YYYY/MM/DD HH24:MI:SS
MM/DD/YYYY HH24:MI:SS

The Data Integration Service processes the transformation logic if you apply the TO_DATE function to a data type other than DATS, TIMS, or ACCP or if TO_DATE converts a character string to a format that the Data Integration Services cannot push to SAP.

The Data Integration Service processes transformation logic that contains other Informatica functions.