Manually Creating RA Informatica Agent Workflow Jobs

Manually define Jobs that run Informatica Workflows by creating WORKFLOWJOB Job types and using the Informatica page in a Job definition.

To manually create an RA Informatica Agent Workflow Job:

  1. Add a new Job by picking Informatica as your Job type and selecting WORKFLOWJOB.
  2. From the Job definition, select your RA Informatica Agent solution Agent object.
  3. Go to the Informatica page and enter the following information:
    • Connection to Repository

      • The Connection object you created. Make sure you select a Connection object that can connect to the Agent you selected for the Job.

    • Folder Name

      • The Informatica folder that contains the Workflow. This field is inactive until you select a connection to repository.

    • Workflow Name

      • The Workflow you wish to run. This field is inactive until you select a folder name.

    • Start from Task

      • An optional Task, Session, or Worklet to start running from. Tasks to start from may include reusable or non-reusable Worklets.

      For non-reusable Worklets, this list includes all:

      • Of the Worklet's Tasks, Sessions, reusable Worklets, and non-reusable Worklets.
      • Tasks, Sessions, and Worklets belonging to non-reusable Worklets.

        • When Tasks, Sessions, and Worklets are included in non-reusable Worklets, they will be listed in the Start from task drop-down list with their Worklet name followed by a period, and their name. When non-reusable Worklets include nested non-reusable Worklets, each non-reusable Worklet is listed separated by a period.

    • Parameter Source

      • Allows you to define how you specify which parameters the Job uses. The options are:

      • None: Uses no parameters.
      • Parameter File: Uses the parameter file specified in the Parameter File Name field below.
      • All File Parameters: Uses the local parameter file and settings specified on the All File Parameters page.
      • Job Parameters: Uses the Job parameters you get and/or set on the Job Parameters page.
    • Parameter File Name

      • An optional Informatica parameter file. You can:

      • Type in a valid parameter file.
      • Use the Retrieve button to retrieve the parameter file associated with the Job defined in Informatica.

        • If the Informatica Workflow has a parameter file attribute defined under Properties, the parameter file name is retrieved.

        When a Informatica Workflow does not have a parameter file attribute defined under Properties but the Session has a parameter file attribute defined under Properties, that parameter file is used when the job runs.

        Warnings:

        • This field only allows access to a parameter file that the Informatica installation can access.
        • UNC paths are not accessible.
    • Run Instance Name

      • An optional field to specify a string to pass to the Informatica Power Center Monitor. If the replacement value {JOB_RUNID} is used, the run ID will be used as part of the string. When this field is empty, the Automation Engine Run ID will be used.

      That only applies when the Workflow was created concurrent in PowerCenter.

    • Abort on Kill

      • When checked, the Job will abort when a kill command is issued from the Automation Engine. When unchecked (default), the Job is stopped.

    • Transfer Options

      • Allows you to override the Session Log File Transfer Option setting specified in the RA Informatica Agent solution Agent object selected for this Job. This option decides whether the RA Informatica Agent should transfer Session logs for Workflow Jobs. Whether or not you transfer Session log files affects how long it takes for the Jobs to complete in the Automation Engine.

      • Use agent settings: The value set for the Agent's Session Log File Transfer Option setting is used.
      • Always: Transfers log files for all Sessions in this Workflow.
      • For Failed Sessions or Workflows: Covers two cases:
        • If the Workflow fails, all the session logs are transferred, regardless of the individual session status.

          • For example, in the case that "Fail parent if this task fails" is enabled.

        • If the Workflow does not fail, only the log files for failed sessions are transfered.
      • Only for Failed Sessions: Transfers log files for failed Sessions in this Workflow regardless of the Workflow status.
      • Never: Does not transfer log files for Sessions in this Workflow. When this option is selected, the Session log file name is not listed in the Job report. The word "null" is written in its place.

      For more information, see topic Configuring the RA Informatica Agent Solution Agent.

      Important !

      When the Generate on error only box on the RA/Integration Reports page is checked (the title depends on the AWI version that is installed in your environment), the Session Log File Transfer Options for the Workflows Job is ignored and no Session logs will be transferred.

      Workflow log files are always transferred.

    • Override Child Job Tracking

      • Enables child Job tracking for this Workflow. When this box is checked, it overrides the Enable Child Job Tracking setting in the Agent definition for this Workflow Job.

  4. Add/edit Job parameters.
    5. To: Do this:

    Use a parameter file

    Enter the parameter file name in the Parameter File Name field. When a parameter file is used, the parameters on the Job Parameters page are ignored.

    Set values for one or more parameters already defined in Informatica

    Go to the All File Parameters page and use the select icon to select a parameter file in the Local Parameter File field. This will populate the All File Parameters page with one or more editable parameter tables.

    To clear all mapping tables and reset the Local Parameter File field, click Clear Mappings.

    To reload the parameter file, click Refresh.

    Use the Keep Existing Values checkbox to determine whether to overwrite existing mappings in the editable parameter tables.

    When checked the values are kept even when the parameter file values have changed. Refresh button does not override values.

    When unchecked all sections/variables are overwritten when you click the Refresh button.

    Precondition: The loaded parameter file must contain the section and name of the edited parameter.

    Get and set values for Job parameters already defined in Informatica

    Leave the Parameter File Name blank, go to the Job Parameters page and click Get Parameters, the RA Informatica Agent adds the following parameters to the parameters table.

    • Variables defined on the Workflow variable tab.
    • Variables/parameters from the mapping.
    • Mapping variable or parameter values that are being passed from one session to another in a Workflow.

    You can edit the parameter values by editing the Value column.

    Leave the Parameter File Name blank, go to the and click Get Parameters, The RA Informatica Agent adds the parameters defined in Informatica to the Job Parameters page. You can edit the parameter values by editing the Value column.

     

    Default values will be used for parameters that are already defined in Informatica, but they will not be displayed in the Value column.

    Add a custom parameter to the Job Parameters tab

    Click Add Row, the RA Informatica Agent adds a row where you can specify the name and value.

    Edit a custom parameter from the Job Parameters tab

    Edit the Value column.

    Delete a custom parameter from the Job Parameters tab

    Select a row and click Remove.