Informatica学习笔记1:UPDATEASINSERT 要求实现每天抽取数据,而且是如果有改变才抽取更新,没有就不更新, 因为源表中有最后修改时间的字段,我让它和SESSION上次运行时间比较来解决是否抽 取, 但问题是有的表中没有主键,我该怎么实现更新呢? 有主键的我在WORKFLOW的MAPPING里面勾上了UPDATEELSEINSERT 那没主键的
Hello All, In an Update Strategy Transformation is it necessary to select Insert as well as Update Else Insert in the Session properties. If the Insert is...
When a table is in the half way of executing a transaction and is the owner of a trigger and if the same table is accessed by the trigger somewhere else in the same time then at that instance mutating trigger occurs. Was this answer useful? Yes ReplyRobert May 8th, 2007 To avoid ...