问题描述
我已经开发了一个Informatica PowerDesigner 9.1 ETL作业,该作业使用查找和更新转换来检测目标表是否具有来自源的传入行。我已经为Update转换设置了条件
I have developed an Informatica PowerDesigner 9.1 ETL Job which uses lookup and an update transform to detect if the target table has the the incoming rows from the source or not. I have set for the Update transform a condition
IIF(ISNULL(target_table_surrogate_id), DD_INSERT, DD_REJECT)
现在,当输入行已经在目标表中时,该行将被拒绝。 Informatica将这些拒绝的行写入.bad文件。如何预防呢?有没有办法确定拒绝的行没有写入.bad文件?或者我应该使用例如路由器进行了更新转换,以确定该行是否为插入行,然后丢弃其他行?
Now, when the incoming row is already in the target table, the row is rejected. Informatica writes these rejected rows into a .bad file. How to prevent this? Is there a way to determine that the rejected rows are not written into a .bad file? Or should I use e.g. a router insted of an update transform to determine if the row is insert row an then discard the other rows?
推荐答案
放入过滤器更新策略之前进行转换,并过滤掉不良行
Put a filter transformation before the update strategy transformation and filter away the bad rows
这篇关于Informatica将拒绝的行写入错误的文件,如何避免这种情况?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!