Informatica PowerExchange Valuable Features
The main benefit of PowerExchange is its native real-time capabilities. Competing tools are counting on third-party packages or Oracle to offer real-time capabilities. However, Informatica has a native ability to scan the data on the file system level and capture the changes almost instantly when I push it to the consumers. The solution has a powerful built-in replication engine.View full review »
A valuable feature is the way it utilizes a push down optimization. This teradata is a fantastic combination of BDO and I think is one of the features which has really been very prominent and very effective. You're using the Hadoop ecosystem to do a significant amount of necessary processing and you're using the internal transformation engine of Informatica to do that.
Another feature of the solution is coupling up and seamlessly driving the underlying stock jobs or scoop jobs which are essentially executable within the Hadoop ecosystem. This provides a significant amount of control over the landscape and overall implementation.
A further element is the underlying metadata and the monitoring and auditing components which Informatica provides. If you're running a complex next gen, powerful analytics and modern BI analytics platform or an ecosystem, then I think these three things along with the integration with external sources and external components is seamless in terms of an SMS engine or an email or even offering integration with WhatsApp.
Along with that, Informatica has been trying to spread its tentacles across stuff like Data Life Cycle Management and a lot of things in MDM, etc. Overall it's a rich toolkit and covers a very wide aspect of data management.
Software Test Automation Engineer at a insurance company with 1,001-5,000 employees
The target system is Legacy Systems.View full review »