Data Integraton Hub DX_ETL DateTime Precision Issue
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.
Subscribe to:
Posts (Atom)
- J. Kinzer
- Tennessee, United States
- I work in technology for a U.S. company. I have worked with Informatica PowerCenter and Informatica Data Quality in developer and administrator roles. This blog will mostly contain technical tips and observations about Informatica PowerCenter and databases. Please comment on any post to share your opinion or feel free to email me.
- Administration (5)
- aggregation (1)
- Automation (5)
- Data_Integration_Hub (1)
- email (1)
- Informatica (13)
- Informatica Sequence (1)
- Informatica_10 (1)
- Job Scheduling (2)
- pmrep (4)
- Repository (1)
- SAP (1)
- Scripting (7)
- webservice (2)
Subscribe + Follow
Read This First
Many of the scripts referenced in this blog use server environment variables for repetitive command parameters. Read this post for an explanation.
Translate
About Me
Site Disclaimer
IMPORTANT, YOU are responsible for backing up your systems before trying or implementing any suggestions from this blog. I do not guarantee 100% accuracy in any code examples. I do not presume to know your system environment(s) or Security requirements; all code examples from this blog should be thoroughly tested before attempted use on a production system.