Wednesday, November 4, 2009








  • Informatica Architecture -


    • Informatica 7.x provides following components
      PowerCenter Repository
      PowerCenter Repository Server
      PowerCenter Client
      PowerCenter Server

      Informatica 8.x provides following components

  • Domain
    Nodes
    Repository Service
    Integration Service

In Informatica 7.x Informatica server,load manager LM, data transfer manager DTM ,reader,temp server and writer are the components of informatica server. First load manager sends a request to the reader thread if the reader thread is ready to read the data from source and dump into the temp server and data transfer manager manages the load and it send the request to writer thread as per first in first out process and writer thread takes the data from temp server and loads it itno the target.


The differences between 7.x and 8.x is on architecture and the administration of the product. PowerCenter 8.x is having Service Oriented Architecture (SOA).The SOA architecture has replaced several servers that were used within the PowerCenter 7.x . A Tomcat web server is used to run an Informatica 'domain' comprising of several repositories or integration services. An integration service is responsible for data movement.SOA allows a single console tool to be used to administer the PowerCenter installer. This tool is web based and can be accessed from anywhere in your network. SOA supports several integration or repository services to run concurrently. This allows high availability to be implemented (if a server hosting an integration service fails these tasks can be 'failed over' onto another node in the domain).Additionally PowerCenter 8.x supports the use of Java in mappings, the ability to 'push down' processing into the database and other similar improvements. There is nosignificant change in the client interface.Additional Information: Several terms have acquired a new meaning with the change in product architecture.PowerCenter 7.x PowerCenter 8.x R epository server and repository R epository service PowerCenter Server Integration service Some other enchancements like push down processing, more flexible java transformations, SQL transformations, string parsing functions are newly added to 8.x. Only change we can see in it is a single place where we do all administration stuff. Repository server is renamed as repository service and informatica pc server renamed as integration service. Not much change in client interface as we still have Repository Manager,Designer,Workflow Manager and Workflow Monitor.Also on 8.5 and 8.6, security, user and group administration has been moved to the administration console.When comparing to the architecture 7.1 n 8.1,Domain,Node,Integration Services added to the 8.1 architectutre.Domain is a web based admin console.Node is like INF server or power centre server.Integration Servicesis like repository server.Domain,Node,Integration Services are at one place that is Domain Database .In 8.1 we don't have admin console and repository agent also you can install or have multiple Nodes in a single machine,we can intiate multiple processes simultaneously.In INF 8.1 has more security you can not create repository without previliges.you no need to start the services in control panel every time also some of the transformations added in 8.1.They are SQL,JAVA transformations.It supports unstructured data like emails,word,pdfs.concept of flatfile updation is introduced.Effective in PowerCenter 8.0, you might notice an increase in memory and CPU resource usage on machines running PowerCenter Services. The following factors can increase memory and CPU resource usage:Updates to Integration Service and Repository Service processes. The pmserver and pmdtm process for the Integration Service and the pmrepagent process for the Repository Service include updated functionality that requires more memory and CPU resource usage.High availability. You configure a domain for high availability, service restart, failover, and recovery operations.Java Runtime Environment (JRE). The PowerCenter service-oriented architecture uses JRE to run the PowerCenter domains and nodes. Domains and nodes require more memory and CPU resources than when you run a PowerCenter Server or Repository Server in PowerCenter 7.x.Log Manager. The Log Manager requires additional memory and CPU resources when it collects and processes a large number of log events.

11 comments:

  1. For latest and updated Informatica certification dumps in PDF format contact us at completeexamcollection@gmail.com

    ReplyDelete
  2. Thanks a lot for explaining practically. Fantastic Post! Get more information Informatica Training in Chennai|Spring Training in Chennai

    ReplyDelete
  3. Much appreciated for clarifying for all intents and purposes. Incredible Post! Get more data.
    Education | Article Submission sites | Technology

    ReplyDelete
  4. Wonderful post!!Thank you for sharing this info with us.
    Keep updating I would like to know more updates on this topic
    Very useful content, I would like to suggest this blog to my friends.

    Best Informatica Training center In Chennai

    Informatica course in Chennai

    ReplyDelete
  5. Really nice blog post.provided a helpful information.I hope that you will post more updates like this
    more about Informatica Online Course

    ReplyDelete
  6. Informative post, We can assume it is a part of Informatica Online Training. Great!

    ReplyDelete