Wednesday, August 29, 2018

Informatica PowerCenter Architecture

Informatica Software Architecture illustrated as :
Informatica ETL product, known as Informatica Power Center consists of 3 main components.
1. Informatica PowerCenter Client Tools:These are the development tools installed at developer end. These tools enable a developer to
  • Define transformation process, known as mapping. (Power center Designer)
  • Define run-time properties for a mapping, known as sessions (Workflow Manager)
  • Monitor execution of sessions (Workflow Monitor)
  • Manage repository, useful for administrators (Repository Manager)
2. Informatica PowerCenter Repository:
Repository is the heart of Informatica tools. Repository is a kind of data inventory where all the data related to mappings, sources, targets etc is kept. This is the place where all the metadata for your application is stored. All the client tools and Informatica Server fetch data from Repository. Informatica client and server without repository is same as a PC without memory/harddisk, which has got the ability to process data but has no data to process. This can be treated as backend of Informatica. This architecture is visually explained in diagram below: 





3. Informatica PowerCenter Server:
Server is the place, where all the executions take place. Server makes Physical connections to sources/targets, fetches data, applies the transformations mentioned in the mapping and loads the data in the target system.


 This is the sufficient knowledge to start with Informatica. So lets go straight to development in Informatica.

Informatica Software Architecture illustrated as per knowledge, please feel free add/comment if anything i missed

2 comments:

  1. I think Informatica and its other aspects are actually very necessary to provide some more useful and necessary information about its tools.

    Informatica Read JSON

    ReplyDelete
  2. You sure know what you’re talking about. Everyone is going to soon be visiting your site. I surprised with the analysis you made to make this actual publish extraordinary. Excellent task!
    informatica online training
    informatica training

    ReplyDelete

Thank you :
- kareem