PowerCenter has a service-oriented architecture, which gives it the ability to scale services and share resources across multiple machines. High availability functionality helps minimize service downtime due to unexpected failures or scheduled maintenance in the PowerCenter environment. To understand the architecture of Informatica PowerCenter, we will discuss the various components that form the Informatica architecture.

The Informatica architecture is divided into two sections: server and client.

The server setup can be done on Windows or UNIX operating systems, while the client installation can only be done on the Windows operating system. As a best practice, we should always install the server first and then the client.

Informatica services include various services that start the service manager on individual nodes.

The service manager is the component that starts and runs the application services on the node in a domain.

The repository is the component that stores the metadata that is created when you work on client tools. The following points describe a repository:

• It is a centralized database of Informatica PowerCenter, which is used to store the metadata that is created when the code is designed in client tools.
• When you wish to...

The Informatica administration home page is the single place where all Informatica components can be created and configured. The Administration Console home page opens in the web browser. It does not require an internet connection. You can use any browser to open the admin console. You might need to check the browser settings if the administrator home page will not open. Based on your system configuration and settings, you might need to try using a different browser.

Perform the following steps to configure the Informatica components:

1. Informatica Administrator Home Page can be located under All Programs in your Start menu.
2. Navigate to Start | All Programs | Informatica 10.1.0 | Server | Informatica Administrator Home Page:

This will open Informatica Administrator in your default web browser.

3. Log in to the Informatica Administrator...

Our first step is to create a repository. As mentioned earlier in the book, the repository is the centralized database of Informatica, which is used to store metadata generated in the client tools.

To create the first repository, follow the process mentioned in the preceding section. Refer to the following screenshot.

1. Click on the Services and Nodes option. You will be presented with various services. You will see the domain name and the node name on the left side of the screen, which we created in the earlier section:

2. Navigate to Domain under Domain Navigator | Actions | New | PowerCenter Repository Service...:

3. This will open a pop-up window, which will allow you to provide details for creating the repository, as shown in the following points. Insert the details:
   • Repository name: Add the name of the repository...

Integration Service is required for the flow of data from the source to the target through Informatica. We discussed integration service in detail in the earlier section in this book. Perform the following process to configure the integration service:

1. Navigate to Domain under Domain Navigator | Actions | New | PowerCenter Integration Service...:

2. This will open a new screen, which will allow you to provide details for creating integration services, as shown in the following screenshot.
   • Mention the following details:
   • Name: Add the name of the integration service. You can specify any name as per your liking. We are using INTE for our reference in this book.
   • Description: You can write some description of the integration service. This is an optional field.
   • Location: Specify the domain name we created earlier. The domain...