Thursday, February 10, 2011

New Features of PowerCenter 9.0.1

PowerCenter 9.0.1 delivers the full range of data integration capabilities to ensure that all data can be accessed, integrated, and delivered throughout the enterprise at any speed.
PowerCenter All Editions (Standard, Advanced, Real Time)

    * New upgrade wizard and installer
    * New unified administration console
    * Improvements to Mapping Analyst for Excel, including support for reusable rules and usability enhancements
    * Improvements to Mapping Architects for Visio, including support for PowerExchange data sources, transformation shortcuts and custom transformation editing
    * Enhanced support for lookup transformations including cache updates, database deadlock resilience, SQL overrides for uncached lookups and multiple rows return
    * Guaranteed exactly-once semantics extended to SQL transforms—if there is an interruption in processing a real-time message, PowerCenter guarantees once-only delivery and can recover without requiring the message to be sent again

PowerCenter Advanced Edition: Metadata Manager and Business Glossary

    * Improved impact analysis, with ability to view a list of the impacted objects
    * Approval workflow for business terms—create and edit draft business terms, propose the business terms for review by data stewards, and then publish the terms
    * Business terms change notifications to stakeholders—send emails to notify users to review draft business terms or new comments
    * Import/export business glossaries
    * Metadata audit trails for all user-definable metadata, with ability to view the history of changes to business glossary categories, business terms, and custom objects
    * Improvements to metadata bookmarks, including access to Metadata Manager and Business Glossary objects and features from external applications
    * Enhancements to metadata loading and linking processes, including automatic connection assignments, support for multiple PowerCenter parameter files, automated cross-resource linking, and resource connection testing
    * Support for Microsoft SSRS/SSAS metadata

PowerCenter Real Time Edition

    * Improved XML exception management—validate and route invalid XML to a separate output group
    * Dynamic lookup cache refresh—update the lookup cache based on the results of an expression
    * Session log file rotation—limit the size of session logs for real-time sessions by time or file size

0 comments:

Post a Comment

newer post older post Home