PowerCenter Task Configuration
To create and configure a PowerCenter task, export the workflow from the PowerCenter Repository Manager to an XML file and then upload the XML file in to Informatica Cloud. After you upload the file, map the uploaded connections to Informatica Cloud connections.
You can update an existing PowerCenter task to use a different PowerCenter XML file. When you upload a new PowerCenter XML file to an existing PowerCenter task, the PowerCenter task deletes the old XML file and updates the PowerCenter task definition based on new XML file content.
Rules and Guidelines for Configuring a Workflow XML File and PowerCenter Task
Use the following rules and guidelines when you configure a PowerCenter task:
- •The PowerCenter workflow can contain only supported transformations and other mapping objects. For more information, see Supported Transformations and Mapping Objects.
- •The PowerCenter workflow can contain a session task. Other tasks, such as Command and Decision tasks, are not supported.
- •The workflow can contain up to 10 partitions for sources and targets.
- •When a workflow includes a reusable mapplet, the mapplet instance name in the workflow must match the reusable mapplet name.
- •The XML file can contain only one workflow, one session, and one mapping.
- • The workflow import fails in the following cases:
- - The workflow XML file is empty.
- - The workflow XML file is not valid.
- - The workflow XML does not contain at least one source and target.
- - The workflow connections are not mapped to Informatica Cloud connections.
- - The workflow contains mapping objects that are not supported.
- •Tasks run in Informatica Cloud cannot use parameter files.
- •When a PowerCenter XML file contains Web Service connection information, you can configure a Web Service connection in the PowerCenter task. If you configure a different connection type, the PowerCenter task uses Web Service connection information saved in the workflow.
Configuring a PowerCenter Task
1. To create a PowerCenter task in Informatica Cloud, click Task Wizards > PowerCenter, and then click New.
To edit a PowerCenter task, click Task Wizards > PowerCenter, click the name of the PowerCenter task, and then click Edit.
2. In the Task Details area, configure the following fields:
Field | Description |
|---|
Task Name | Name of the PowerCenter task. The names of PowerCenter tasks must be unique within the organization. Task names can contain alphanumeric characters, spaces, and the following special characters: _ . + - Maximum length is 100 characters. Task names are not case sensitive. |
Description | Description of the PowerCenter task. Maximum length is 255 characters. |
Schedule | Determines how the task runs: - - To run the task manually, click Do Not Run This Task on a Schedule.
- - To associate the task with a schedule, click Run This Task on Schedule, and select a schedule.
To create a schedule, click New. |
Runtime Environment | Runtime environment that contains the Secure Agent to run the task. |
Workflow XML File | The PowerCenter workflow XML file associated with the task. Only the first 30 characters of the XML file name appear. To upload a file, click Upload XML File. After you upload the workflow XML file, the connections and transformations appear in the Workflow XML File Details area. To download the workflow XML file from Informatica Cloud, click Download XML File. You might download a file to import the workflow to the PowerCenter Workflow Manager for review. |
3. Optionally, configure email notification options.
You can configure the following email notification options:
Field | Description |
|---|
Use Default Email Notification Options for my Organization | Use the email notification options configured for the organization. |
Use Custom Email Notification Options for this Task | Use the email notification options configured for the task. You can send email to different addresses based on the status of the task: - - Failure Email Notification. Sends email to the listed addresses when the task fails to complete.
- - Warning Email Notification. Sends email to the listed addresses when the task completes with errors.
- - Success Email Notification. Sends email to the listed addresses when the task completes without errors.
Use commas to separate a list of email addresses. When you select this option, email notification options configured for the organization are not used. |
4. In the Connections area, for each connection reference, select an ICS connection.
To create a connection, click New. To edit a connection, click View, and in the View Connection dialog box, click Edit.
A connection reference is a source, target, or lookup connection defined in the workflow XML file.
The Transformations area displays all transformations defined in the workflow XML file.
5. Click Save.