Informatica Version Differences

What are differences between Informatica PowerCenter 8 and Informatica PowerCenter 9 versions?

New Features on Informatica 9:
1. Informatica 9 includes the Informatica Developer and Informatica Analyst client tools.
2. Multiple rows return in lookup:
Lookups can now be configured as an Active transformation to return Multiple Rows. We can configure the Lookup transformation to return all rows that match a lookup condition. A Lookup transformation is an active transformation when it can return more than one row for
any given input row.
3. Enhanced support for lookup transformations, including cache updates, database deadlock resilience, SQL overrides for un cached lookups, and multiple rows return.
4. Limit the Session Log:
You can limit the size of session logs for real-time sessions. You can limit the size by time or by file size. You can also limit the number of log files for a session.
5. Single admin console for data quality (Informatica developer tool), PowerCenter, Power exchange and data services.
6. Informatica has the capability to pull data from IMS, DB2 on series and series and from other several other legacy systems (Mainframe) environment like VSAM, Datacom, IDMS etc.
7. Informatica supports open interfaces such as web services and can integrate with other tools that support these as well including BPM tool.
8. Informatica 9 will continue support feature of running the same workflow simultaneously.

What are differences between Informatica PowerCenter 9 and Informatica PowerCenter 10 versions?

Here are some of the key differences between Informatica PowerCenter 9 and 10:

1. User Interface: The user interface of Informatica PowerCenter 10 has been redesigned to provide a more modern and intuitive user experience. The new interface includes improved navigation, search, and collaboration features.
2. Cloud Integration: Informatica PowerCenter 10 includes enhanced support for cloud integration, including integration with popular cloud services such as Amazon Web Services (AWS) and Microsoft Azure.
3. Big Data Integration: Informatica PowerCenter 10 includes new capabilities for integrating with big data platforms such as Hadoop, Spark, and NoSQL databases. This includes support for data ingestion, processing, and integration with traditional data sources.
4. Data Quality: Informatica PowerCenter 10 includes improved data quality capabilities, including enhanced profiling, cleansing, and matching features. This helps ensure that data is accurate, consistent, and complete.
5. Real-Time Integration: Informatica PowerCenter 10 includes improved support for real-time data integration, including support for real-time data streaming and integration with message-oriented middleware (MOM) systems.
6. Administration and Monitoring: Informatica PowerCenter 10 includes new administration and monitoring features that provide greater visibility into system performance and enable more efficient management of large-scale deployments.
7. Performance and Scalability: Informatica PowerCenter 10 includes several performance and scalability improvements that enable faster processing of large volumes of data and more efficient use of system resources.
8. Overall, Informatica PowerCenter 10 provides a more modern and comprehensive data integration platform than its predecessors, with improved support for cloud and big data integration, enhanced data quality features, and improved performance and scalability.

What are differences i can see in Informatica PowerCenter 9 and 10 in client tools?

Here are some of the key differences you can see in the client tools of Informatica PowerCenter 9 and 10:

1. User Interface: The user interface of Informatica PowerCenter 10 has been redesigned to provide a more modern and intuitive user experience. The new interface includes improved navigation, search, and collaboration features.
2. Mapping Designer: The Mapping Designer tool in Informatica PowerCenter 10 includes new features such as the ability to create mappings using a drag-and-drop interface. It also includes new transformations and connectors for big data integration.
3. Workflow Manager: The Workflow Manager tool in Informatica PowerCenter 10 includes new features for managing and monitoring workflows, such as the ability to pause and resume workflows, and to monitor workflows in real-time.
4. Repository Manager: The Repository Manager tool in Informatica PowerCenter 10 includes new features for managing repositories, such as the ability to import and export repository objects, and to perform bulk operations on repository objects.
5. Metadata Manager: Informatica PowerCenter 10 includes a new Metadata Manager tool that provides a comprehensive view of metadata across the enterprise. This tool allows users to manage metadata from multiple sources and to track lineage and impact analysis across metadata assets.
6. Data Quality: Informatica PowerCenter 10 includes improved data quality capabilities, including enhanced profiling, cleansing, and matching features. The Data Quality tool in Informatica PowerCenter 10 has been redesigned to provide a more intuitive user experience.
7. Cloud Integration: Informatica PowerCenter 10 includes enhanced support for cloud integration, including integration with popular cloud services such as Amazon Web Services (AWS) and Microsoft Azure. The Cloud Connector tool in Informatica PowerCenter 10 provides a drag-and-drop interface for configuring cloud integrations.

Overall, the client tools in Informatica PowerCenter 10 provide a more modern and comprehensive data integration platform than its predecessor, with improved support for cloud and big data integration, enhanced data quality features, and improved performance and scalability.