为什么 Informatica 中的 joiner 没有不等于运算符？
为什么Informatica的连接器转换不支持!=， >=、<= 运算符？
他们为什么要提出像查找这样的概念？
Why doesn't Informatica's joiner transformation support !=, >=, <= operators?
Why should they come up with a concept like lookup?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
Joiner 转换用于垂直整合。
例如，
在 order-tbl.item-id = item-tbl.item-id 上使用连接条件，您可以打印这样的报告
对于垂直合并，我无法想到需要其他条件（例如！=，>=）的场景，<=。
通过查找转换，一些核心 ETL 任务变得简单，例如
识别传入记录是否是新记录（主键不存在）或对现有记录的更新；
查找一个值，例如从 item-tbl 中查找 item-price 来计算订单总额。
Joiner transformation is used for vertical consolidation.
e.g
Using a join condition on order-tbl.item-id = item-tbl.item-id you could print a report like this
For vertical consolidation, I can't think of a scenerio needing other conditions like !=, >=, <=.
With lookup transformation, some core ETL tasks are made easy like
identifying if the incoming record is a new record (primary key doesn't exist) or an update to the existing record;
lookup a value e.g. lookup item-price from item-tbl to calculate order total.
现在，您可以使用查找转换的“多重匹配”功能以非等值连接条件连接异构源
您可以从以下 Informatica Marketplace 下载示例
https://community.informatica.com/solutions/mapping_multi_match_lookup_join
Now you can join heterogeneous sources with a non-equi join condition using a Lookup Transformation's "Multi Match" feature
You can download sample from following Informatica Marketplace
https://community.informatica.com/solutions/mapping_multi_match_lookup_join