Showing posts with label Informatica_10. Show all posts
Showing posts with label Informatica_10. Show all posts

Data Integraton Hub DX_ETL DateTime Precision Issue

Posted by J. Kinzer 0 comments
Labels: ,

This issue was found in Informatica Data Integration Hub 10 on Windows Server 2012 using SQL Server 2012 as the Repository.

The PowerCenter Workflow DX_ETL can abort in mapping m_SET_CURRENT_CUTOFF giving the errors:

  • Timestamp parameters with a scale, must have a scale less than ten and a precision equal to 20 plus the scale. You specified a precision of 999 and scale of 9.
  • Fractional second precision exceeds the scale specified in the parameter binding.
Here are some steps you can take to correct this problem. Some or all of these steps may be required to correct the issue.

Subscribe to: Posts (Atom)