If you upgraded the Informatica platform, you need to perform some additional tasks within the Informatica domain.
Based on the version that you upgraded from, you might need to perform the following updates:
Update date/time data format for sources and targets
Perform this task in the following situation:
You upgraded from version 10.2.2 or earlier.
Effective in version 10.4.0, the Databricks Spark engine reads and writes date/time values in the format YYYY-MM-DD HH24:MM:SS.US.
To continue to use the Databricks Spark engine to read date/time data in other formats, edit mappings to include an Expression transformation. Read the date/time field from the source as a string. In the expression, convert the string to a date/time format.
To write data to a different format, use an Expression transformation to convert the date/time data to a different format. Then write the data to the target as a string.