PowerCenter 9.5
PowerCenter Advanced Edition: Metadata Manager
Capabilities:
- Delivers new XConnects – SAP Netweaver Business Warehouse, IBM Rational Data Architect, and BI and data modeling sources
- Includes new XConnect certifications – IBM Cognos 10, CA ERwin 8, MicroStrategy 9.2.1, Oracle Business Intelligence Enterprise Edition 11g, Sybase PowerDesigner 16 and Embarcadero ER/Studio 8.5.1
- Delivers new, easy-to-use custom XConnect with better manageability of loads via validation and user-friendly logging
Benefits:
- Expands metadata management connectivity
Informatica Data Integration Analyst Option
Capabilities:
- Enables guided mappings that auto-map source to target, provides join recommendations, and previews data midstream in the mapping
- Embeds profiling within mapping specifications, increasing analyst productivity and understanding of data
- Enables SQL query interface for mapping specifications for those analysts who prefer to validate mapping logic using SQL
- Provides descriptions that improve collaboration between analysts and developers
Benefits:
- Increases productivity for self-service and collaboration for analysts
PowerCenter Pushdown Optimization Option
Capabilities:
- Supports SQL-based error tables in Teradata
- Supports SQL MERGE for Teradata
- Supports case-insensitivity in aggregation on Teradata
- Supports subquery when using SQL overrides on Teradata
Benefits:
- Increases support for pushdown optimization in Teradata
PowerCenter Data Validation Option
Capabilities:
- Includes functionality focused on operational production validation scenarios
- Incremental data validation
- Enhanced management reports and dashboards with drill down capabilities
- User authentication via PowerCenter domains
- Extends data connectivity with Salesforce.com, SAS, SAP Transparent Tables, IBM DB2 zOS, and IBM Netezza
- Includes join wizard for complex table joins and heterogeneous tables
Benefits:
- Lowers risk of production failures when rolling out new data integration processes to production systems
The information being provided is for informational purposes only. The development, release and timing of any Informatica product or functionality described today remain at the sole discretion of Informatica and should not be relied upon in making a purchasing decision. Statements made are based on currently available information, which is subject to change. Such statements should not be relied upon as a representation, warranty or commitment to deliver specific products or functionality in the future.