Informatica PowerCenter与自定义Perl ETL作业？ [英] informatica powercenter vs custom perl ETL job?

问题描述

我的大多数公司都使用Powercenter informatica进行数据库之间的Extract-Transform-Load类型数据移动作业。

Most of my company uses powercenter informatica for Extract-Transform-Load type data move jobs between databases.

但是我从事的项目有一个很大的自定义Perl作业，并添加了一些Java，可以很好地移动数据并触发其他一些更新。

However project I am on has a big custom Perl job with some Java thrown in for good measure to move data and trigger some other updates.

有人说要改用powercenter，人们在这种项目中的经验是什么，这有意义吗？似乎您在采用这种现成的解决方案时具有很大的灵活性，但是ETL工具是否可以在生产率方面给您带来很多好处？

There is talk of rewriting the thing to use powercenter instead, what are people's experiences on such a project, does it make sense? Seems like you trade lot of flexibility in going to such a "off the shelf" solution, but do the ETL tools buy you much in terms of productivity for example?

推荐答案

Informatica对运营团队非常有用。它使非技术人员可以监视和重新运行作业。但是，它使任何任务变得比需要复杂得多。它是一款庞大的软件，需要花费一些时间来学习，并且它的局限性在于无需编程即可完成的转换。我肯定会每天通过 Enterprise ETL工具使用Perl或编程语言。

Informatica is good for an operations team. It allows a non-technical person the ability to monitor and re-run jobs. However, it makes about any task much more complicated than it needs to be. It's a huge piece of software, and takes a while to learn, and it's limited in the transformations it can do without programming. I'd certainly use Perl or a programming language any day over an "Enterprise ETL" tool.

这篇关于Informatica PowerCenter与自定义Perl ETL作业？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！