informatica 值大于此列允许的指定精度
我尝试在 Informatica 中使用一对一映射直接映射来加载表 ADuplicate，该表与表 A 重复。
但我收到以下错误： “值大于此列允许的指定精度”
我注意到，对于 C4 列（两个表中的数字（15）），在加载时存在问题。
加载时出现错误的数据是 200000300123 和 -1000000000000000000000000000000000000000000
我的疑问是：
- 该值在相同精度的源中可用。为什么达不到目标？
- 我将目标列 C4 更改为“数字”字段，我可以使用 TOAD 手动插入此值，但为什么不能使用 Informatica 执行相同操作？
请帮帮我。
预先感谢
尚穆根
I tried to load a table ADuplicate which is duplicate of Table A using one to one mapping direct mapping in Informatica.
But I got following error:
"Value larger than specified precision allowed for this column"
I noticed that for C4 column, which is number(15) in both tables, has the problem while loading.
Data which has error in loading are 200000300123 and -1000000000000000000000000000000000000000000
My doubt is:
- This value is available in Source of same precision. Why doesn't it get into target?
- I changed the Target Column C4 as just Number field I could insert this value manually using TOAD but why couldn't I do the same using Informatica?
Please help me out.
Thanks in advance
Shanmugam
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您是否在源和目标之间进行了一些转换，为该端口设置了不同的精度？尤其是目标之前的那个？
写入目标的数据具有更高的精度 - 可能在中间的某些转换中设置得更高。您可以在中间使用表达式转换进行测试以降低精度。
Do you have some transformation between source and target that sets a different precision for this port? Especially the one before the target?
The data written to the target has higher precision - possibly set higher in some transformation(s) in the middle. You may test with an expression transformation in the middle to reduce the precision.
尝试选中会话属性的“属性”选项卡中的“启用高精度”。
Try checking "Enable high precision" which is available in "properties" tab in session properties.