Informatica TO_BIGINT,TO_DECIMAL 转 字符串
2021/6/9 10:36:33
本文主要是介绍Informatica TO_BIGINT,TO_DECIMAL 转 字符串,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
Informatica PowerCenter中 TO_BIGINT,TO_DECIMAL这两个函数遇到字符串时 会自动返回0值 而不报错。 TO_BIGINT( value [, flag] ) TO_BIGINT( IN_TAX, TRUE )
IN_TAX |
RETURN VALUE |
---|---|
'7245176201123435.6789' |
7245176201123435 |
'7245176201123435.2' |
7245176201123435 |
'7245176201123435.2.48' |
7245176201123435 |
NULL |
NULL |
'A12.3Grove' |
0 |
' 176201123435.87' |
176201123435 |
'-7245176201123435.2' |
-7245176201123435 |
'-7245176201123435.23' |
-7245176201123435 |
-9223372036854775806.9 |
-9223372036854775806 |
9223372036854775806.9 |
9223372036854775806 |
TO_BIGINT(IN_TAX)
IN_TAX |
RETURN VALUE |
---|---|
'7245176201123435.6789' |
7245176201123436 |
'7245176201123435.2' |
7245176201123435 |
'7245176201123435.348' |
7245176201123435 |
NULL |
NULL |
'A12.3Grove' |
0 |
' 176201123435.87' |
176201123436 |
'-7245176201123435.6789' |
-7245176201123436 |
'-7245176201123435.23' |
-7245176201123435 |
-9223372036854775806.9 |
-9223372036854775807 |
9223372036854775806.9 |
9223372036854775807 |
TO_DECIMAL( value [, scale] )
例:
TO_DECIMAL( IN_TAX, 3 )
IN_TAX |
RETURN VALUE |
---|---|
'15.6789' |
15.679 |
'60.2' |
60.200 |
'118.348' |
118.348 |
NULL |
NULL |
'A12.3Grove' |
0 |
'711A1' |
711 |
'1234567890.123' |
1234567890.123 |
'123456789012345678901234567890.123' |
Error. Integration Service skips this row. |
'1234567890123456789012345678901234567890.123 |
Error. Integration Service skips this row
转自https://www.cnblogs.com/dl-ekong/p/8295825.html |
这篇关于Informatica TO_BIGINT,TO_DECIMAL 转 字符串的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2024-05-29Elasticsearch慢查询日志配置
- 2024-05-29揭秘华为如此多成功项目的产品关键——Charter模板
- 2024-05-29海外IDC业务拓展的7大挑战
- 2024-05-29InLine Chat功能优化对标Github Copilot,CodeGeeX带来更高效、更直观的编程体验!
- 2024-05-29CodeGeeX 智能编程助手 6 项功能升级,在Visual Studio插件市场霸榜2周!
- 2024-05-29AutoMQ 生态集成 Apache Doris
- 2024-05-292024年IDC行业的深度挖掘:机遇、挑战与未来展望
- 2024-05-29五款扩展组件齐发 —— Volcano、Keda、Crane-scheduler 等,邀你体验
- 2024-05-29AutoMQ 对象存储数据高效组织的秘密: Compaction
- 2024-05-29活动预告|来 GIAC 大会听大数据降本利器:AutoMQ 基于云原生重新设计的 Kafka