Informatica Administration Guide 9

Posted on
Informatica Administration Guide 9 Average ratng: 3,5/5 7653 reviews
  1. Administration Guide Informatica 9.6.1
  2. Informatica Administrator Guide 9.6.1

As the installer (powercenter), copy the file to software directory, unzip and untar it: 3. 961 Software Installation Enter the choice(1 or 2):1 - Checking for existing 9.6.1 product installation. Unset the INFAHOME,INFANODENAME and INFADOMAINSFILE before continuing the installation. Continuing the installation with the environment variables set will cause the installation to fail. Installer will exit now. /opt/infa/svc-abc-snd/SOFTunset INFAHOME INFANODENAME INFADOMAINSFILE /opt/infa/svc-abc-snd/SOFT./install.sh OS detected is Linux. Welcome to the Informatica 9.6.1 Server Installer.

Administration Guide Informatica 9.6.1

Before you continue, read the following documents:. Informatica 9.6.1 Installation GuDEV and Release Notes. B2B Data Transformation 9.6.1 Installation, Configuration GuDEV and Release Notes. You can find the 9.6.1 documentation in the Product Documentation section at Configure the LANG and LCALL variables to generate appropriate code pages and create and connect to repositories and Repository Services.

Informatica Administrator Guide 9.6.1

Do you want to continue? (Y/N)Y Installer requires Linux version 2.6.18-0 or later versions of the 2.6.18 series or version 2.6.32-0 or later versions of the 2.6.32 series.

Current operating system Linux version 2.6.32-431. Current operating system meets minimum requirements.

Select to install or upgrade: 1. Install or upgrade Informatica.

Administration

Select this option if the machine does not have Informatica services installed or if it has Informatica 9.5.1 or an earlier version installed. Install or upgrade Data Transformation Engine Only. Select this option to install or upgrade only Data Transformation Engine. Enter the choice(1 or 2):1 - Checking for existing 9.6.1 product installation. To verify whether the machine meets the system requirements for the Informatica installation or upgrade, run the Pre-Installation (i9Pi) System Check Tool before you start the installation or upgrade process. It is recommended that you verify the minimum system requirements. Select one of the following options: 1.

Run the Pre-Installation (i9Pi) System Check Tool 2. Run the Informatica Kerberos SPN Format Generator 3. Run the Informatica services installation Select the option to proceed: (Default: 3)1 Preparing to install. Extracting the JRE from the installer archive.

Unpacking the JRE. Extracting the installation resources from the installer archive. Configuring the installer for this system's environment. The value for the DISPLAY variable is not valid. Set the DISPLAY variable to the graphics display server or unset the variable.

Do you want to continue the Informatica Services Installation (y/n)?y Preparing to install. Extracting the JRE from the installer archive. Unpacking the JRE. Extracting the installation resources from the installer archive. Configuring the installer for this system's environment. The value for the DISPLAY variable is not valid.

Set the DISPLAY variable to the graphics display server or unset the variable. /opt/infa/svc-abc-snd/SOFTunset DISPLAY /opt/infa/svc-abc-snd/SOFT./install.sh OS detected is Linux. Welcome to the Informatica 9.6.1 Server Installer. Before you continue, read the following documents:. Informatica 9.6.1 Installation GuDEV and Release Notes. B2B Data Transformation 9.6.1 Installation, Configuration GuDEV and Release Notes. You can find the 9.6.1 documentation in the Product Documentation section at Configure the LANG and LCALL variables to generate appropriate code pages and create and connect to repositories and Repository Services.

Do you want to continue? (Y/N)Y Installer requires Linux version 2.6.18-0 or later versions of the 2.6.18 series or version 2.6.32-0 or later versions of the 2.6.32 series. Current operating system Linux version 2.6.32-431. Current operating system meets minimum requirements. Select to install or upgrade: 1. Install or upgrade Informatica.

Select this option if the machine does not have Informatica services installed or if it has Informatica 9.5.1 or an earlier version installed. Install or upgrade Data Transformation Engine Only. Select this option to install or upgrade only Data Transformation Engine. Enter the choice(1 or 2):1 - Checking for existing 9.6.1 product installation. To verify whether the machine meets the system requirements for the Informatica installation or upgrade, run the Pre-Installation (i9Pi) System Check Tool before you start the installation or upgrade process. It is recommended that you verify the minimum system requirements.

Select one of the following options: 1. Run the Pre-Installation (i9Pi) System Check Tool 2. Run the Informatica Kerberos SPN Format Generator 3. Run the Informatica services installation Select the option to proceed: (Default: 3)1 Preparing to install. Extracting the JRE from the installer archive. Unpacking the JRE.

Extracting the installation resources from the installer archive. Configuring the installer for this system's environment.

Welcome - Step 1 of 4. Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time.

Informatica Pre-Installation (i9Pi) System Check Tool The Pre-Installation (i9Pi) System Check Tool verifies the minimum system and database requirements for the Informatica services installation or upgrade. Press to continue. System Information - Step 2 of 4. Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. Informatica installation directory: (default:- /opt/infa/svc-abc-snd):/opt/infa/svc-abc-snd/Informatica/9.6.1 Informatica starting port number: (default:- 6005):7888. Database and JDBC Connection Information - Step 3 of 4.

Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. Use Custom String 1-YES. 2-NO:1 Database type: 1-DB2 2-SQLServer.

3-Oracle 4-Sybase: Database user ID: (default:- INFADEVSNDDOM): Database user password:: Custom String:jdbc:informatica:Oracle://TEST-ora01.TESTING.com:1771;DatabaseName=indev. System Check Summary - Step 4 of 4. Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. Informatica Pre-Installation (i9Pi) System Check Tool Results Pass Disk Space: Available disk space is 18,628 MB. Sufficient for the Informatica installation.

Pass Processors: Available number of processors is 2. Sufficient for the Informatica installation. Pass Physical Memory: Available physical memory is 16,326 MB.

Sufficient for the Informatica installation. Pass Temporary Space: Available temporary disk space is 4,379 MB. Sufficient for the Informatica installation. Pass Ports: Port range is 7,080 - 7,084. All port numbers within the port range are available for the Informatica installation.

Pass Locale Environment Variable: The LANG environment variable is set to language C. The LCALL environment variable is set to language C. Sufficient for the Informatica installation. Pass JREHOME Environment Variable: The JREHOME environment variable does not contain a value.

Sufficient for the Informatica installation. Pass File Descriptor Limits: The file descriptor limits per process is 1620107. Sufficient for the Informatica installation. Pass RESOURCE Privilege: The database user account has the RESOURCE privilege. Sufficient for the Informatica installation. Pass CREATE TABLE Privilege: The database user account has the CREATE TABLE privilege. The installer successfully created a database table.

Pass CREATE VIEW Privilege: The database user account has the CREATE VIEW privilege. The installer successfully created a database view.

Information Informatica Installation Directory: /opt/infa/svc-abc-snd/Informatica/9.6.1 Information Informatica Starting Port Number: 7080 Information Database Type: Oracle Information Database User ID: INFADEVSNDDOM Information Operating System: Operating system is Linux. Operating system version is 2.6.32-431.11.2.el6.x8664. Information RAM: The memory module size is 16,326 MB. Press Enter to quit the pre-installation system check. Do you want to continue the Informatica Services Installation (y/n)?y Press Enter to quit the pre-installation system check.

Do you want to continue the Informatica Services Installation (y/n)?y Preparing to install. Extracting the JRE from the installer archive. Unpacking the JRE. Extracting the installation resources from the installer archive. Configuring the installer for this system's environment. Installation Type - Step 1 of 7. Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time.

Select to install or upgrade:. 1-Install Informatica 9.6.1. Select this option to perform a full installation of Informatica 9.6.1. 2-Upgrade to Informatica 9.6.1. Select this option to upgrade previous versions of Informatica products to Informatica 9.6.1.:1 Enable Kerberos network authentication. 1-No 2-Yes:. Installation Pre-Requisites - Step 2 of 7.

Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. Verify the installation pre-requisites and complete the pre-installation tasks before you continue. Disk Space Requirement: 7 GB Memory Requirement (RAM): 4 GB Database Requirements - Verify the Oracle, IBM DB2, Microsoft SQL Server, or Sybase ASE database version. Verify the database user account.

9.6.1

The account must have permissions to create and drop tables and views, and insert, update, and delete data. Pre-installation Tasks - Obtain the Informatica license key. Verify the minimum system requirements. Set the environment variables.

Verify the port availability. Set up the keystore file. On UNIX, set the file descriptor limit. On UNIX, configure POSIX asynchronous I/O. Download and extract the Informatica installer files.

Run the Informatica Pre-Installation (i9Pi) System Check Tool. If you are enabling Kerberos network authentication, run the Informatica Kerberos SPN Format Generator. Press to continue. License Key - Step 3 of 7. Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. Enter the license key file (default:- /opt/infa/svc-abc-snd/license.key):/opt/infa/svc-abc-snd/SOFT/LicenseKeyName.key.

Installation Directory - Step 3 of 7. Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. Enter the installation directory (default:- /opt/infa/svc-abc-snd/Informatica/9.6.1):. Pre-Installation Summary - Step 4 of 7. Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time.

Product Name: Informatica 9.6.1 Services Installation Type: New Installation Installation Directory: /opt/infa/svc-abc-snd/Informatica/9.6.1 Disk Space Requirements Required Disk Space: 6,999 MB Available Disk Space: 18,628 MB Press to continue.

Informatica ETL tool consists of following services & components. Repository Service – Responsible for maintaining Informatica metadata & providing access of same to other services. It is a collection of nodes and services. Further, this nodes and services can be categorized into folders and sub-folders based on the administration requirement. For example, in the below screenshot, you can see under domain window the folder 'DomainRajesh' is created under which we have created a node name 'node01rajesh' and services as 'guru99 integration services'. Node is a logical representation of a machine inside the domain.

Node is required to run services and processes for Informatica. You can have multiple nodes in a domain. In a domain, you will also find a gateway node. The gateway node is responsible for receiving requests from different client tools and routing those requests to different nodes and services. There are two types of services in Domain.

Application Services: Application service represents the server specific services like integration service, repository service, and reporting service. These services run on different nodes based upon the configuration. PowerCenter Repository PowerCenter repository is a relational database like Oracle, Sybase,server and it is managed by repository service. It consists of database tables that store metadata. There are three Informatica Client tools available in Informatica Powercenter. They are Informatica. Workflow Manager These clients can access to the repository using repository service only.

To manage a repository there exists an Informatica service called Repository Service. A single repository service handles exclusively only one repository. Also, a repository service can execute on multiple nodes to increase the performance. The repository services use locks on the objects, so multiple users cannot modify the same object same time. You can enable version control in the repository. With the version control feature, you can maintain different versions of the same object.

Objects created in the repository can have following three state. Impacted: Impacted objects are those whose child objects are invalid. For example in a mapping if you are using a reusable transformation, and this transformation object becomes invalid then the mapping will be marked as impacted. Domain Configuration As mentioned earlier, domain is the basic administrative control in Informatica.

It is the parent entity which consists of other services like integration service, repository service, and various nodes. The domain configuration can be done using the Informatica admin console. The console can be launched using web browsers. Once open in a web browser it prompts for administrator login.

The password is set during the Informatica installation. After login into the Informatica domain, the home page looks something like this. In the left pane it shows the existing nodes, repository services, integration services under the domain.

On the main window, it shows the status of those services, whether those are up or down. Properties of the domain Click on the properties menu in the admin page to view the properties of the domain.

Key properties of the domain are Resilience timeout – If any of the integration service or repository services goes down then resilience timeout is the no of seconds the application service tries to connect to those services. Restart Period – It is the maximum number of seconds the domain spends to restart a service. Dispatch Mode – It is the policy used by the load balancer to dispatch tasks to various nodes. Database type – The type of database on which domain is configured. Database host – Hostname of the machine on which domain is configured. Database port & name – It is the database port and the database instance name for the domain. These properties can be modified based upon requirement.

Powercenter client & Server Connectivity PowerCenter client tools are development tools which are installed on the client machines. Powercenter designer, workflow manager, a repository manager, and workflow monitor are the main client tools. The mappings and objects that we create in these client tools are saved in the Informatica repository which resides on the Informatica server. So the client tools must have network connectivity to the server. On the other hand, PowerCenter client connects to the sources and targets to import the metadata and source/target structure definitions. So it also must have connectivity to the source/target systems.

The integration service also combines data from different sources For example, it can combine data from an oracle table and a flat file source. So, in summary, Informatica integration service is a process residing on the Informatica server waiting for tasks to be assigned for the execution. When we execute a workflow, the integration service receives a notification to execute the workflow. Then the integration service reads the workflow to know the details like which tasks it has to execute like mappings & at what timings. Then the service reads the task details from the repository and proceeds with the execution. Sources & Targets Informatica being an ETL and Data integration tool, you would be always handling and transforming some form of data.

The input to our mappings in Informatica is called source system. We import source definitions from the source and then connect to it to fetch the source data in our mappings. There can be different types of sources and can be located at multiple locations. Based upon your requirement the target system can be a relational or flat file system.

Flat file targets are generated on the Informatica server machine, which can be transferred later on using ftp. Relational– these types of sources are database system tables. These database systems are generally owned by other applications which create and maintain this data. It can be a Customer Relationship Management Database, Human Resource Database, etc.

Administration

For using such sources in Informatica we either get a replica of these datasets, or we get select privileges on these systems. Flat Files - Flat files are most common data sources after relational databases in Informatica. A flat file can be a comma separated file, a tab delimited file or fixed width file. Informatica supports any of the code pages like ascii or Unicode. To use the flat file in Informatica, its definitions must be imported similar to as we do for relational tables.