Thursday, 2 August 2012

What are new features of INFORMATICA 9 compared to INFORMATICA 8.6

Informatica 9 empowers line-of-business managers and business analysts to identify bad data and fix it faster. Architecture wise there are no differences between Informatica 8 and 9 but there are some new features added in powercenter 9.

New Client tools
Informatica 9 includes the Informatica Developer and Informatica Analyst client tools.
The Informatica Developer tool is eclipse-based and supports both data integration and data quality for enhanced productivity.From
here you can update/refine those same rules, and create composite data objects - e.g. Get customer details from a number of different sources and aggregate these up to a Customer Data Object.
The Informatica Analyst tool is a browser-based tool for analysts, stewards and line of business managers.  This tool supports data profiling, specifying and validating rules (Scorecards), and monitoring data quality.

Informatica Administrator
The powercenter Administration Console has been renamed the Informatica Administrator.
The Informatica Administrator is now a core service in the Informatica Domain that is used to configure and manage all Informatica Services, Security and other domain objects (such as connections) used by the new services.
The Informatica Administrator has a new interface. Some of the properties and configuration tasks from the powercenter Administration Console have been moved to different locations in Informatica Administrator. The Informatica Administrator is expanded to include new services and objects.

Cache Update in Lookup Transformation
You can update the lookup cache based on the results of an expression. When an expression is true, you can add to or update the lookup cache. You can update the dynamic lookup cache with the results of an expression.

Database deadlock resilience
In previous releases, when the Integration Service encountered a database deadlock during a lookup, the session failed. Effective in 9.0, the session will not fail. When a deadlock occurs, the Integration Service attempts to run the last statement in a lookup. You can configure the number of retry attempts and time period between attempts.

Multiple rows return
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.

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.

We can enable auto-commit for each database connection. Each SQL statement in a query defines a transaction. A commit occurs when the SQL statement completes or the next statement is executed, whichever comes first.

Passive transformation
We can configure the SQL transformation to run in passive mode instead of active mode. When the SQL transformation runs in passive mode, the SQL transformation returns one output row for each input row.

Connection management
Database connections are centralized in the domain. We can create and view database connections in Informatica Administrator, Informatica Developer, or Informatica Analyst. Create, view, edit, and grant permissions on database connections in Informatica Administrator.

We can monitor profile jobs, scorecard jobs, preview jobs, mapping jobs, and SQL Data Services for each Data Integration Service. View the status of each monitored object on the Monitoring tab of Informatica Administrator.

We can deploy, enable, and configure deployment units in the Informatica Administrator. Deploy Deployment units to one or more Data Integration Services. Create deployment units in Informatica Developer.

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. The Model repository also stores run-time and configuration information for applications deployed to a Data.

Data Integration Service
Application service that processes requests from Informatica Analyst and Informatica Developer to preview or run data profiles and mappings. It also generates data previews for SQL data services and runs SQL queries against the virtual views in an SQL data service. Create and enable a Data Integration Service on the Domain tab of Informatica Administrator.

XML Parser
The XML Parser transformation can validate an XML document against a schema. The XML Parser transformation routes invalid XML to an error port. When the XML is not valid, the XML Parser transformation routes the XML and the error messages to a separate output group that We can connect to a target.

Enforcement of licensing restrictions
Powercenter will enforce the licensing restrictions based on the number of CPUs and repositories.
Also Informatica 9 supports data integration for the cloud as well as on premise. You can integrate the data in cloud applications, as well as run Informatica 9 on cloud infrastructure.



  1. I am robert..Good work buddy... keep continuing... it shows yours commitment towardsinformatica field...

  2. It is very useful, Good work buddy.

  3. Hi Everyone
    can you please explain how to update lookup cache in look up t/r using exp t/r result


  4. Good work...Please provide us access to copy this data..Thanks

    1. Hi,.I think you can copy it.Please try again :)

  5. Hi All,

    coud any one help me in gettting the Informatica Administration difference between 8.6.1 and 9.5.1 for administrators ?

    Please mail me to


  6. nice work buddy.....

  7. Thanks Kashinathan.

  8. . A large number of packers And movers in chennai in this Internet world search up the hunt on Google of whatever we require and henceforth we have acquainted ourselves with get together your needs in only a single button click.

  9. Movers And Packers In Hyderabad are proficient in whatever we do and dependably take after our clients' input which helps us each time to develop and take in more and more with every single criticism. We are exceptionally grateful for the criticism we get from you as it helps us in expanding our execution and make you fulfill with the administrations given and desire from you to prescribe us to others.

  10. Packers And Movers Delhi prompt moving, relocation and shifting services for people and corporation moving to Delhi and round the India. For Movers Packers Delhi city full target report on supply of revenue and effective Movers And Packers Delhi, contact today 08290173333. We include our network in major cities like Bengaluru, Bangalore, Gurgaon, Hyderabad, Chandigarh, Haridwar, Chennai, Noida, Mumbai, Pune, Jaipur, Lucknow, Patna, Bhopal, Bhubaneswar, Ahmedabad and Kolkata.

  11. Local Packers And Movers Bangalore have earned our name and got so prominent simply in light of our persevering and commitment towards our work. Once on getting your enquiry we seek among the rundown of grouped that could address your issues most likely. Remembering your conditions we offer you the most suitable individual you require for your moving. Movers And Packers in bangalore people are even looking forward for what is best for you.

  12. Packers Movers Kolkata are please to help people in the most meaningful manner we did whatever makes us feel
    comfortable. We love to help people in the best manner as we can do. By giving you our services we feel like we are on the
    top of this world. You just have to keep faith in us and we will be their anytime you wanted. Join hands with us and
    forget all your worries regarding shifting and packing and moving from one place to another.

  13. Packersand Movers Kolkata has spearheaded the pattern of rapid administrations and unloading help. An arrangement of migration whether it's your office or your living spot, moving includes various troubles and issues. Presently moving to an alternate city is totally bothered free when the packers and movers Kolkata is with you.


Related Posts Plugin for WordPress, Blogger...