Use this page to list or modify the default parameters of a user-defined program, and to change the order in which the parameters are processed.
Previously defined steps that use the user-defined program will not reflect any changes that you make to the parameters. You must duplicate the changes that you make in the parameters list in the parameters list for the existing steps.
Use this page to select and remove agent site locations for the program definition. You must specify an agent site that contains the program. A program can exist on more than one agent site.
This page lists the agent sites where a user-defined program is located and the agent sites where the user-defined programs can reside. For the Data Warehouse Center to use a user-defined program, you must save the program on an agent site.
If you are defining a transformer, you must ensure that the agent that you define to this program is connected to the database where your transformer exists. If you assign an agent to this program definition that is not connected to the target database specified on this page, you will receive a warning when you create a step that uses this program.
For example, you have the following agent, source and targets:
|
Agent |
Source |
Target |
|
Agent A |
Source 1 |
Target 1 |
|
Target 2 |
Suppose Agent A is connected to Source 1 and Target 1. Now, suppose that your transformer exists on Target 2. If you define your transformer program definition to use Agent A, you will receive a warning when you try to create a step. This warning is issued because Agent A is not defined to the target that contains the transformer.
To use Agent A, you must define it to Target 2, or you must store the transformer on Target 1 and add Target 1 to the target resources definition.