Tuesday, February 8, 2011

INFORMATICA 9.0.1 New Features.

  • 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.
  • Informatica analyst is a new tool available in Informatica 9.
  • There is architectural difference in Informatica 9 compared to previous version.
  • Browser based tool for business analyst is a new feature.
  • Data steward is a new feature.
  • Allows unified administration with a new admin console that enables you to manage power centre and power exchange from the same console.
  • Powerful new capabilities for data quality.
  • Single admin console for data quality, power centre, power exchange and data services.
  • In Informatica 9, Informatica data quality (IDQ) has been further integrated with the Informatica Platform and performance, manageability and reusability have all been significantly enhanced.
  • The mappings rules are shared between the browser based tool for analysts and the eclipse based development leveraging unified metadata underneath.
  • The data services capabilities in Informatica 9 , both over sql and web services ,can be used for real time dash boarding.
  • Informatica data quality provides world wide address validation support with integrated geocoding.
  • The ability to define rules and view and run profiles is available in both the Informatica developer (Thick client) and Informatica analyst (browser based tool-Thin client).these tools sit on a unified metadata infrastructure. Both tools incorporate security features like authentication and authorization ensuring..
  • The developer tool is now eclipse based and supports both data integration and data quality for enhanced productivity. It provides browser based tool for analysts to support the types of tasks they engage in, such as profiling data, specifying and validating rules & monitoring data quality.
  • There will a velocity methodology. Soon it’s going to introduce on I9.
  • 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, and IDMS etc.
  • There are separate tools available for different roles. The Mapping architect for Vision tool is designed for architects and developers to create templates for common data integration patterns saving developer’s tremendous amount of time.
  • Informatica 9 does not include ESB infrastructure.
  • Informatica supports open interfaces such as web services and can integrate with other tools that support these as well including BPM tool.
  • Informatica 9 complements existing BI architectures by providing immediate access to data through data virtualization, which can supplement the data in existing data warehouse and operational data store.
  • Informatica 9 supports profiling of Mainframe data. Leveraging the Informatica platform’s connectivity to Mainframe sources.
  • Informatica 9 will continue support feature of running the same workflow simultaneously.
  • Browser based tool is a fully functional interface for business analysts.
  • . Dashboards are designed for business executives.
  • There are 3 interfaces through which these capabilities can be accessed. Analyst tool is a browsed tool for analyst and stewards. Developers can use the eclipse based developer tool. Line of business managers can view data quality scorecards.


  1. Good information

    Check -

    1. Hello There,

      I love all the posts, I really enjoyed.
      I would like more information about this, because it is very nice., Thanks for sharing.
      A plain-text description of the exact rule would have helped; this way I can only guess that you mean the following:
      If the input is a number, then forward the number in port A; port B will be set to NULL.
      If the input is a number followed by only one alphabet character, then forward the number in port A and set port B to the alphabet character.
      In all other cases set port A to NULL and port B to the input value. This symbiotic transfer of information and ease of communication on projects helps reduce misunderstandings and ensure project success.
      If my understanding is correct, I would proceed like this:
      I read multiple articles and watched many videos about how to use this tool - and was still confused! Your instructions were easy to understand and made the process simple.

      Thank you,

    2. Hello There,

      Amaze! I have been looking bing for hours because of this and i also in the end think it is in this article! Maybe I recommend you something helps me all the time?
      My current (and by now last) idea is that somehow during the installation process the two JDKs (9.5.1 uses a 1.6 JDK, 10.1.1 uses a 1.8 version) got mixed up in the PATH or some other environment variable.
      From this Informatica IDQ training USA I hope you understand why I suggest the following: keep the 9.5.1 installation intact, install 10.1.1 on a fresh Windows machine, and have both running in parallel until you're ready to throw away 9.5.1 completely.

      By the way do you have any YouTube videos, would love to watch it. I would like to connect you on LinkedIn, great to have experts like you in my connection (In case, if you don’t have any issues).
      Please keep providing such valuable information.

      Best Regards,

  2. Good information

    Check -

  3. thank you for your wonderful information on informatica keep sharing thank you
    visit our site to learn

    learn Advanced informatica!

  4. Hi There,

    Love it absolutely! So crystalline. No mumbo jumbo. No non-sense. Straight and simple. You guys need a standing ovation for your good work.

    It may be that your Windows environment contains some reference to a previously installed Java version (be it the runtime, JRE, or a full-fledged Java Development Kit, JDK). If so, remove these references. This affects the following environment variables:

    - PATH (look out for any directory paths containing a directory name "jre"),
    - JAVA_HOME (this must not be set when the installation starts),
    - CLASSPATH (this must not be set when the installation starts).

    Appreciate your effort for making such useful blogs and helping the community.

    Best Regards,
    Irene Hynes

  5. Hello There,

    You make learning and reading addictive. All eyes fixed on you. Thank you being such a good and trust worthy guide.

    We are working on integration of SFDC (SalesForce CRM) with Exact Target(ET) (SalesForce Marketing Clound) through Informatica PowerCenter 9.5.1.
    But facing below issues:
    1) While importing SalesForce object into PowerCenter : Getting an error "timed out"
    2) How to connect to Exact target from power Center using API (we tested this from Java by passing proxy to webservie but not sure how to pass proxy to webservice in power Center)

    Awesome! Thanks for putting this all in one place. Very useful!

    Many Thanks,

  6. Aloha,

    Nice to be visiting your blog again, it has been months for me. Well this article that i’ve been waited for so long.

    Given this, I would be surprised to see anything on the test that was not covered in the modules, as it relates to the Cloud tool and topics covered about SalesForce. I would presume questions Informatica Data quality training USA that test general ETL transformation knowledge based on past PowerCentre tool experience.
    But great job man, do keep posted with the new updates.

    Kind Regards,

  7. Hey There,

    Nice to be visiting your blog again, it has been months for me. Well this article that i’ve been waited for so long.

    yes I can tnsping the db from the infa server
    the roles and privileges mentionned are given to the oracle user of the domain

    NB: I managed to install version 9.5.1 and 9.6.1 already on this test machine and used the oracle schema on the same database
    I started using Informatica Data quality trainingblog for my training practice.
    Anyways great write up, your efforts are much appreciated.