跨 Informatica ETL 和 ASP.NET CRUD 页面重用业务逻辑的最佳方法是什么？
我不了解 Informatica 的第一件事，但我正在寻找方法来解决用于在表中插入和更新记录的重复业务逻辑。 问题是以有效的方式进行。
1) 我们有可以一次插入、更新和删除一条记录的网页。
2) 我们有 Informatica ETL 加载程序，可以从暂存（临时）表中获取记录并加载它们。 这个过程对我来说是一个黑匣子，但我知道Informatica具有内置的效率，例如读取内存中相当大的表等，因此可以快速验证许多记录。
据我所知，如果将业务编辑放在 Web 服务中，则执行 CRUD 操作的网页以及 Informatica 加载流程都可以重用该 Web 服务，但是如何有效地做到这一点呢？ 一次向 Web 服务传递一条记录会降低 ETL 效率。 传递数千条记录也是如此。
我感觉自己一无所知，因为我不知道 Informatica 是如何工作的。
有人有什么建议吗？
I don't know the first thing about Informatica but I am looking for ways to resolve duplicating business logic that for inserting and updating records in a table. The problem is doing it in an efficient manner.
1) We have web pages that insert, update and delete records one at a time.
2) We have Informatica ETL load programs that take records from a staging (temp) table and load them. This process is rather a black box to me, but I know that Informatica has efficiencies built in, such as reading fairly large tables in memory, etc, so many records can be validated quickly.
I understand that if the Business edits were placed in web service that this web service could be reused by both the web page doing CRUD operations as well as the Informatica load process, but how do you do this efficiently? Passing one record at a time to a web service would kill the ETL efficiency. So would passing thousands of records.
I feel like I am in the dark cause I don't know how Informatica works.
Does anybody have any suggestions?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
恐怕你得去了解一下 InfoMatica。 它的运作方式可能与你想象的完全不同，使你所有的假设都是错误的
I'm afraid you'll have to go learn about InfoMatica. It may operate in a totally different manner than you imagine, making all your assumptions false