使用 DD_INSERT 更新策略
为什么我们使用DD_Insert使用更新策略转换,但是Informatica会自动插入数据而无需更新策略转换?
期待答案
Why we use Update Strategy transformation with DD_INSERT however Informatica automatically inserts the data without Update strategy transformation?
expecting the answer
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
它是一种工具 - 许多逻辑需要不同的行为。
您的假设
Informatica自动插入数据
用于默认行为,所有设置均为默认设置。如果有人想插入,更新,删除,拒绝 - 他们可以在更新策略中使用不同的选项。您还需要将会话设置为数据驱动。如果仅放置DD_Insert,则意味着此管道仅用于插入。
Its a tool - and many logic demands different kind of behavior.
Your assumptions
Informatica automatically inserts the data
is for default behavior with all settings left as default. If someone wants to insert, update, delete, reject - they can use different options in update strategy. You also need to set the session to data driven.If you put only dd_insert, this means this pipeline is used only for inserting.
如果映射执行单一类型的操作并且它不是由数据驱动的,则根本不需要更新策略转换。
它甚至不仅仅用于插入,因为这是由
Treat input rows as
会话属性驱动的 [更多信息可以在这里找到]。此外,可以为整个会话指定通用方法,然后根据需要针对特定目标覆盖它。仍然没有使用
更新策略
转换。If a mapping performs single type of operation AND it's not driven by the data, then
Update Strategy
transformation is not at all required.And it's not even for inserts only, as this is driven by the
Treat input rows as
session property [more information can be found here].Furthermore, it's possible to specify general approach for the whole session and then override it for particular targets, if needed. Still without using
Update Strategy
transformation.