Previous Topic: Define an Informatica JobNext Topic: Search for a Task in an Informatica Workflow


Search for an Informatica Workflow

You can use the Search Informatica Workflows dialog to search for and select a workflow that is defined on Informatica PowerCenter. You can also view the sequence of tasks and the hierarchy of objects within a workflow.

Follow these steps:

  1. Ensure you are connected to the server.
  2. Open the Basic page of the Informatica job definition.
  3. Complete the following required fields:
    Agent name

    Specifies the name of the Informatica agent where the workflow runs.

    Folder name

    Specifies the Informatica PowerCenter repository folder name where the specified workflow resides.

  4. Click the arrow search button next to the Workflow name field.

    The Search Informatica Workflows dialog opens.

    Note: The required fields in this dialog are populated with the information that is specified on the Basic page of the job definition. You can also select another repository folder from the Folder name drop-down list.

  5. (Optional) Specify the information in the Informatica Server Info section.

    Note: The fields in this section are populated with the information that is specified on the Basic page of the job definition, if any.

  6. (Optional) Specify the filter criteria in the following field:
    Matching pattern

    Specifies the matching pattern string that is used to retrieve the names of workflows. Only workflows whose names contain the search pattern are displayed. % is the only wildcard character that is supported for the pattern matching.

    Example: If you specify "A%ab%" as the matching pattern, all the workflows whose names start with A and contain ab in the middle or at the end are displayed. If you specify "%file%" as the matching pattern, all the workflows whose names contain file are displayed, for example: file_task, X_file_Task and T_file.

    Note: If you do not specify a matching pattern, all workflows that belong to the specified repository folder are displayed.

  7. Click the arrow search button next to the Informatica Server Info section.

    The Workflows table is populated with the list of workflows that meet the matching pattern string.

    Note: You can sort the data in the table by clicking on a table column heading.

  8. (Optional) Select a workflow and click Workflow Details to display the sequence of tasks for the selected workflow in a tabular format.
  9. (Optional) Select a workflow and click Workflow Object Hierarchy to display the hierarchy of all tasks within the selected workflow in a graphical format.
  10. Select a workflow and click Select Workflow to specify the workflow name in the job definition.

    The selected workflow is set on the Basic page of the job definition.

Example: List Workflows that Match a Specified Pattern

Suppose that you want to retrieve a list of Informatica workflows whose names contains INF and underscore (_).

To list workflows based on matching pattern criteria

  1. Open the Basic page of the Informatica job definition.
  2. Enter the following information:
  3. Click the arrow search button next to the Workflow name field.

    The Search Informatica Workflows dialog opens.

  4. Enter %inf%_% in the Matching pattern field.
  5. Click the arrow search button next to the Informatica Server Info section.

    The Workflows table is populated with the list of workflows that meet the search criteria.