Related Documentation › Informatica Jobs › Define an Informatica Job

Define an Informatica Job

You can define an Informatica job to start a predefined workflow on Informatica PowerCenter. You can start the workflow from the beginning of the workflow or from a specified task. You can also start a workflow instance.

Notes:

• Due to a known issue in Informatica, you cannot run workflow instances in parallel.
• To run these jobs, your system requires CA WA Agent for Linux or Windows and CA WA Agent for Informatica.

Follow these steps:

1. Open the Application that you want to add the job to in the Define perspective.

   The Application appears in the workspace.

2. Select the Informatica job in the Palette view, and drag the job to the workspace.

   The Informatica icon appears on the Application workspace view.

3. Right-click the Informatica icon, and select Edit from the pop-up menu.

   The Basic page of the Informatica dialog opens.

4. Complete the following required fields:

   Name

   Defines the name of the job that you want to schedule.

   Limits: 128 alphanumeric characters, plus the special characters commercial at (@), pound (#), dollar sign ($), underscore (_), square brackets ([]), brace brackets ({}), and percent sign (%) as a symbolic variable introducer character.

   Agent name

   Specifies the name of the agent that runs the Informatica job.

   Note: The drop-down list displays all the agents that are defined in the Topology for the specified job type.

   Folder name

   Specifies the Informatica PowerCenter repository folder name where the specified workflow resides. You can obtain this value from the Informatica server.

   Limits: Up to 79 characters

   Workflow name

   Specifies the name of the Informatica PowerCenter workflow to be started.

   Limits: Up to 79 characters

   Note: You can type the workflow name or, if you are connected to the server, click the arrow search button next to the field to search for a workflow that is defined in Informatica PowerCenter. You can also view the sequence of tasks and the hierarchy of objects within a selected workflow.

5. (Optional) Specify the following additional information:

   Informatica target

   Specifies the name of the Informatica target (infaTarget). The corresponding directory (install_dir/config/informatica/infaTarget) stored on the agent contains the properties for connecting to the Informatica server and one or more database repositories.

   Limits: Up to 128 characters

   Note: If this field is not specified, the agent uses the default value specified in the informatica.server.target.default parameter in the agentparm.txt file.

   Repository name

   Specifies the name of the repository created on the Informatica server. The repository can be obtained from the Informatica Administrative console. The corresponding property file (repositoryName.properties) stored on the agent contains the database connection properties for a specified Informatica target (infaTarget).

   Limits: Up to 128 characters

   Note: If this field is not specified, the agent uses the default value specified in the informatica.repository.name.default parameter in the informatica.properties file stored on the agent.

   Informatica user

   Specifies the Informatica server user name. The user must be defined in the Topology. This field supports the use of a namespace for a user that has more than one password. Contact your administrator for the user name defined in the Topology.

   Limits: Up to 128 characters

   Examples: Bob, Production:Bob

   Notes:

   • The drop-down list displays all of the user names that are defined in the Topology for the specified agent. You must have at least Read access to the ADMIN.Network Topology permission to view this list.
   • If this field is not specified, the agent uses the default value specified in the informatica.user.id.default parameter in the informatica.properties file stored on the agent.

   Workflow instance

   Specifies the name of the workflow instance to be started. When the task name and the workflow instance name are specified, the workflow instance is started from the specified task. When the task name is not specified, the workflow instance starts from the beginning. If the instance name is not specified, the workflow is started.

   Limits: Up to 79 characters

   Note: Before you select a workflow instance from the drop-down, you must specify the workflow in the Workflow name field. The workflow instances in the drop-down list are populated based on the specified workflow.

   Task name

   Specifies the name of the task to start the workflow from. If the task name is not specified, the workflow starts from the beginning.

   Limits: Up to 79 characters

   Note: You can type the task name or, if you are connected to the server, click the arrow search button next to the field to search for a task that is defined within the specified workflow. You can also view the details and the hierarchy of a selected task within the workflow.

   Param file

   Specifies the path and name of a parameter file on the Informatica server. Informatica PowerCenter processes the parameter file when running a workflow. The parameter file contains values for symbolic variables and must adhere to the format that Informatica PowerCenter expects. A property value that is set in a parameter file overrides a value for this property that is set at the session level or elsewhere.

   Limits: Up to 256 characters

   Pass on success only

   Indicates whether the status of the workflow is retrieved directly from Informatica or inferred depending on the successful execution of all the tasks. Select one of the following values from the drop-down list:

   • True—Returns the workflow status based on the status of tasks in the Informatica workflow. If all tasks in the workflow complete successfully, the agent reports the status of the workflow as successful. If any task in the workflow fails, the agent reports the status of the workflow as failed.
   • False—Returns the workflow status as reported by Informatica. In Informatica, a workflow can succeed even if one or more tasks in the workflow fail.

   Notes:

   • If you do not select any value from the drop-down list, the agent uses the default value specified in the informatica.passonsuccessonly.default parameter in the agentparm.txt file.
   • If no value is specified in the drop-down list or in the agentparm.txt file, the default value is False.

6. Click OK.

   The Informatica job is defined.

Example: Start a Workflow on Informatica PowerCenter from a Task

This example starts a workflow named WF_1 on Informatica PowerCenter from the copyfile task. The workflow is started from the copyfile task.

To start a workflow on Informatica PowerCenter from a task

1. Enter the following information on the Basic page of the job definition:
   • Name—INF_1
   • Agent name—AGENT_INF
   • Folder name—sandbox
   • Workflow name—WF_1
   • Task name—copyfile
2. Click OK.

Example: Start a Workflow with a Parameter File

Suppose that you want to start a workflow named WF_2 with the wf2.prm parameter file on Informatica server. When the workflow runs, Informatica PowerCenter processes the specified parameter file.

The wf2.prm parameter file includes symbolic variables that override the default log directory and file name:

;Workflow Parameters
[INFAPLUGIN.WF:wf_3]
;Session parameters
$PMSessionLogFile=wf3.log
$PMSessionLogDir=C:\Infa\Log
;mapping parameters

To start a workflow with a parameter file

1. Enter the following information on the Basic page of the job definition:
   • Name—INF_1
   • Agent name—AGENT_INF
   • Folder name—sandbox
   • Workflow name—WF_2
   • Param file—C:/Infa/wf2.prm
2. Click OK.

   The log files will be stored in the C:\Infa\Log directory on the Informatica server and their name will start with wf2.log. The actual files that Informatica generates will be longer, for example, wf2.log.1225.20131021131730.bin.

More information:

Informatica Jobs