英文: Cannot convert type string to date 问题 我有一个扁平文件,其中日期以2023062的形式出现,我正在使用转换substr(LTRIM(RTRIM(LINE)...
如何处理返回的API中第一个字符是数字而不是字母的情况?
英文: IICS: How to deal with API which returns first character as a number but not letter? 问题 嗨,Inform...
如何编写一个Swagger文件来捕获<>块内的信息?
英文: How to write a swagger file to capture the information within the <> block? 问题 我正在建立用于API调...
如何在IICS中比较具有拉丁字符的字符串与具有英文字符的同一字符串?
英文: How to compare string with Latin characters to same string with English characters in IICS? 问题 例...
使用命令提示符在Informatica中运行Postgres插入SQL。
英文: Running Postgres insert sql using command prompt informatica 问题 我正在通过Informatica命令提示符运行以下的Postgr...
I am not able to get exact value from sql developer to target file or target table.
英文: why i am not able get exact value from sql developer to target file or target table? 问题 我有两个环境,生...
用正则表达式或任何替换函数来替换出现 [,-] 模式的部分为空。
英文: How to write regex or any replace function to replace with null where [,-] pattern exist 问题 Inpu...
Informatica: 如何基于另一张表的聚合结果来筛选表格?
英文: Informatica: How to filter a table based on aggregation result of another table? 问题 在Informatica...
How to get flat files with no file structure as source and insert same data into table as target in IICS
英文: How to get flat files with no file structure as source and insert same data into table as target...