Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. Datatype Reference
  17. Configure the Web Browser

Designer Guide

Designer Guide

Step 1. Create a Mapping Parameter

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:
  1. In the Mapping Designer, click Mappings > Parameters and Variables. Or, in the Mapplet Designer, click Mapplet > Parameters and Variables.
  2. Click the Add button.
  3. 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.

0 COMMENTS

We’d like to hear from you!