Designer Guide

10.5
- 10.5.6
- 10.4.1
- 10.4.0

Back Next

Step 1. Create a Mapping Parameter

You can create mapping parameters for any mapping or mapplet. You can declare as many mapping parameters as you need. Once declared, use the parameter in the mapping or mapplet.

To create a mapping parameter:

In the Mapping Designer, click Mappings > Parameters and Variables. Or, in the Mapplet Designer, click Mapplet > Parameters and Variables.

Click the Add button.

Enter the following information and click OK:

Field	Description
Name	Parameter name. Name parameters $$ParameterName . The syntax for the parameter name must be $$ followed by any alphanumeric or underscore characters.
Type	Variable or parameter. Select Parameter.
Datatype	Datatype of the parameter. Select a valid transformation datatype. Use any datatype except Binary or Raw.
Precision or Scale	Precision and scale of the parameter.
Aggregation	Use for variables.
IsExprVar	Determines how the Integration Service expands the parameter in an expression string. If true, the Integration Service expands the parameter before parsing the expression. If false, the Integration Service expands the parameter after parsing the expression. Default is false. If you set this field to true, you must set the parameter datatype to String, or the Integration Service fails the session.
Initial Value	Initial value of the parameter. If you do not set a value for the parameter in the parameter file, the Integration Service uses this value for the parameter during sessions. If this value is also undefined, the Integration Service uses a default value based on the datatype of the mapping variable. Use any of the following formats for initial values for Date/Time parameters: MM/DD/RR MM/DD/RR HH24:MI:SS MM/DD/YYYY MM/DD/YYYY HH24:MI:SS.US
Description	Description associated with the parameter.

Rename Saved Search

Table of Contents

Designer Guide

Designer Guide

Step 1. Create a Mapping Parameter

Step 1. Create a Mapping Parameter