What is Informatica PowerCenter and its Components
The PowerCenter server executes tasks based on work flow created by work flow managers. The work flows can be monitored using a work flow monitor. Jobs inside the program are designed in a mapping designer, which creates mapping between source and target. Mapping is a pictorial representation about flow of data from source to target. Transformations such as aggregation, filtering and joining are major examples of transformation.
The components within Informatica PowerCenter aid in extracting data from its source, transforming it as per business requirements and loading it into a target data warehouse. The key components of Informatica are PowerCenter Client Tools, Repository Server, Power Center Server and the Repository. The Repository Server and the PowerCenter Server constitute the ETL Layer which does the ETL process.
As Informatica says “The Power Center domain is the primary unit for management and administration within PowerCenter”. Doesn’t make much sense? Right… So here is a simpler version. Power Center domain is the collection of all the servers required to support Power Center functionality. Each domain has gateway (called domain server) hosts. Whenever you want to use Power Center services you send a request to domain server. Based on request type it redirects your request to one of the Power Center services.
Repository is nothing but a relational database which stores all the metadata created in Power Center. Whenever you develop mapping, session, workflow, execute them or do anything meaningful (literally), entries are made in the repository.
Integration Service does all the real job. It extracts data from sources, processes it as per the business logic and loads data to targets.
Repository Service is the one that understands content of the repository, fetches data from the repository and sends it back to the requesting components (mostly client tools and integration service)
PowerCenter Client Tools:
The PowerCenter Client consists of multiple tools. They are used to manage users, define sources and targets, build mappings and mapplets with the transformation logic, and create workflows to run the mapping logic. The PowerCenter Client connects to the repository through the Repository Service to fetch details. It connects to the Integration Service to start workflows. So essentially client tools are used to code and give instructions to PowerCenter servers.
PowerCenter Administration Console:
This is simply a web-based administration tool you can use to administer the PowerCenter installation.
Informatica PowerCenter High Availability Option automatically applies all high-availability features to all PowerCenter data integration capabilities, including data cleansing, data profiling, and unstructured and semi structured data processing. A Web-based administration console simplifies setup and management.
With this option, you can guard against platform service outage, ensure data uptime, and reduce the costs and risks associated with data downtime. This option strengthens PowerCenter’s readiness for mission-critical deployment.