Informatica SQL Server Dates

The Informatica supports SQL Server date format.

One of the common problem is the conversion from string to date happening in Informatica Expression. Check the Session configuration for “DateTime Format String” first. The default format string is “MM/DD/YYYY HH24:MI:SS.US”. Make sure the string value has the same format.

Other Related Problems:
https://network.informatica.com/thread/9778

Advertisements