You can use parameters and variables to assign values to properties in the Designer and Workflow Manager and to override some service and service process properties. For example, you can use a parameter to specify the Lookup cache file name prefix or the default remote directory for an FTP connection.
If the property is a SQL statement or command, you can either use parameters and variables within the statement or command, or you can enter a parameter or variable in the input field for the property, and set the parameter or variable to the entire statement or command in the parameter file.
For example, you want to use a parameter or variable in a relational target override. You can enter a parameter or variable within the UPDATE statement of a relational target override and define the parameter or variable below the appropriate heading in the parameter file. Or, to define the UPDATE statement in a parameter file, complete the following steps:
1. In the Designer, edit the target instance, enter session parameter $ParamMyOverride in the Update Override field, and save the mapping.
2. In the Workflow Manager, configure the workflow or session to use a parameter file.
3. Set $ParamMyOverride to the SQL UPDATE statement below the appropriate heading in the parameter file.
You can also use a parameter file to override service and service process properties defined in the Administrator tool. For example, you can override the session log directory, $PMSessionLogDir. To do this, configure the workflow or session to use a parameter file and set $PMSessionLogDir to the new file path in the parameter file.
You can specify parameters and variables for the following PowerCenter objects:
Sources. You can use parameters and variables in input fields related to sources.
Targets. You can use parameters and variables in input fields related to targets.
Transformations. You can use parameters and variables in input fields related to transformations.
Tasks. You can use parameters and variables in input fields related to tasks in the Workflow Manager.
Sessions. You can use parameters and variables in input fields related to Session tasks.
Workflows. You can use parameters and variables in input fields related to workflows.
Connections. You can use parameters and variables in input fields related to connection objects.
Data profiling objects. You can use parameters and variables in input fields related to data profiling.
If the property is a SQL statement or command, you can either use parameters and variables within the statement or command, or you can enter a parameter or variable in the input field for the property, and set the parameter or variable to the entire statement or command in the parameter file.
For example, you want to use a parameter or variable in a relational target override. You can enter a parameter or variable within the UPDATE statement of a relational target override and define the parameter or variable below the appropriate heading in the parameter file. Or, to define the UPDATE statement in a parameter file, complete the following steps:
1. In the Designer, edit the target instance, enter session parameter $ParamMyOverride in the Update Override field, and save the mapping.
2. In the Workflow Manager, configure the workflow or session to use a parameter file.
3. Set $ParamMyOverride to the SQL UPDATE statement below the appropriate heading in the parameter file.
You can also use a parameter file to override service and service process properties defined in the Administrator tool. For example, you can override the session log directory, $PMSessionLogDir. To do this, configure the workflow or session to use a parameter file and set $PMSessionLogDir to the new file path in the parameter file.
You can specify parameters and variables for the following PowerCenter objects:
Sources. You can use parameters and variables in input fields related to sources.
Targets. You can use parameters and variables in input fields related to targets.
Transformations. You can use parameters and variables in input fields related to transformations.
Tasks. You can use parameters and variables in input fields related to tasks in the Workflow Manager.
Sessions. You can use parameters and variables in input fields related to Session tasks.
Workflows. You can use parameters and variables in input fields related to workflows.
Connections. You can use parameters and variables in input fields related to connection objects.
Data profiling objects. You can use parameters and variables in input fields related to data profiling.
I feel this is the best way of providing some useful and more aspects of Informatica in order to make it more usable for the IT world.
ReplyDeleteInformatica Read Rest Api