4 Replies Latest reply on Sep 20, 2011 2:09 PM by vivekinfa

    PowerCenter 9 New Features

    Active Member



      We are moving from Informtica 8.6.0 to 9.1.0. I have tried to search for PowerCenter document with new features in Informatica 9.0 compared to previous versions. Can anyone point me to the documentation where I can find new features for PowerCenter 9.




        • 2. PowerCenter 9 New Features
          Active Member

          This webinar talks about the Informatica Upgradation steps but about PowerCenter 9 features. I am looking specifically for PoweCenter 9 features. Please advice.



          • 3. PowerCenter 9 New Features
            Pattabhi Raman Administrators



            Send me a mail at praman@informatica.com and i shall email the new features guide to you.


            Pattabhi Raman

            • 4. PowerCenter 9 New Features
              vivekinfa Guru

              Hi Raj,

              Given below is a brief summary of the differences between 8.6.0 and 9.1.0(new features):


              New Services:
              Analyst Service
              Application service that runs Informatica Analyst in the Informatica domain.
              Model Repository Service
              Application service that manages the Model repository. The Model repository is a relational database that stores the metadata for projects created in Informatica Analyst and Informatica Designer.
              Data Integration Service
              Application service that processes requests from Informatica Analyst and Informatica Developer to preview or run data profiles and mappings.

              Domain Management:
              Informatica Administrator
              Informatica Administrator has a new interface.
              You can use infacmd to back up and restore the domain.
              The Informatica domain enforces the licensing restrictions on the number of CPUs and PowerCenter repositories.
              The License Management Report is enhanced to provide more statistics, such as user statistics and CPU statistics for each host.

              Mapping Objects:
              Lookup Transformation
              Cache updates
              You can update the lookup cache based on the results of an expression.
              Multiple rows return
              You 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.
              Data Transformation source and target
              You can configure a Data Transformation source or a Data Transformation target in a mapping. The Data Transformation source and the Data Transformation target process unstructured and semi-structured file formats, such as messages, HTML pages, and PDF documents.
              SQL Transformation
              Auto-commit for connections
              You can enable auto-commit for each database connection.
              Passive Transformation
              You can configure the SQL transformation to run in passive mode instead of active mode.
              Exactly-Once Processing
              The Integration Service provides exactly-once delivery of real-time source messages to the SQL transformation. If there is an interruption in processing, the Integration Service can recover without requiring the message to be sent again.
              Unstructured Data Transformation
              The Unstructured Data transformation accepts hierarchical groups of input ports.
              Identify Resolution Transformation
              The Identity Resolution transformation is an active transformation that you can use to search and match data in databases.


              Let me know if this helps.