Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapplets
  4. Mapping Parameters
  5. Where to Assign Parameters
  6. Mapping Outputs
  7. Generate a Mapping from an SQL Query
  8. Dynamic Mappings
  9. How to Develop and Run a Dynamic Mapping
  10. Dynamic Mapping Use Cases
  11. Mapping Administration
  12. Export to PowerCenter
  13. Import From PowerCenter
  14. Performance Tuning
  15. Pushdown Optimization
  16. Partitioned Mappings
  17. Developer Tool Naming Conventions

Developer Mapping Guide

Developer Mapping Guide

User-Defined Parameters

User-Defined Parameters

User-defined parameters represent constant values that you can change between mapping runs.
For example, you create a mapping that processes customer orders. The mapping reads customer information from a relational table that contains customer data for one country. You want to use the mapping for customers in the United States, Canada, and Mexico. Create a user-defined parameter that represents the connection to the customers table. Create three parameter sets that set the connection name to the U.S. customers table, the Canadian customers table, and the Mexican customers table. Run the mapping with a different parameter set for each mapping run.
You can create the following types of parameters:
Connection parameters
Informatica connection names.
Date/time parameters
Dates.
Expression
An expression that defines a join condition, a filter expression, or a lookup condition.
Input Linkset
A set of ports to link in the
Run-time Linking
dialog box.
Numeric parameters
Integer, bigint, decimal, and double parameters.
Port
Name of a single port. You can use the port parameter in the Rank port of the Rank transformation.
Port List
A list of ports to include a group. You can use a port list parameter in the Aggregator transformation or the Rank transformation, for example.
Resource
The table, view, or synonym name of a relational data object. When the resource name is parameterized, then the Data Integration Service uses the parameter value in the runtime query to fetch the object.
Sort List
A list of ports to sort with a Sorter transformation. The list includes the port name and an indicator for ascending or descending sort sequence.
Sort Key List
A list of ports to sort with order keys in an Expression transformation configured for windowing. This list includes the port name and an indicator for ascending or descending sort sequence.
String
String parameters represent flat file names, directories, table names or run-time properties. Define string parameters with a precision of 32768 characters or less.
When you create a parameter, you cannot include a dollar sign ($) as the leading character in the parameter name.
When you use a parameter to set a property value, you must use the correct parameter type for the property. For example, you cannot use a connection type parameter for a target file name. You must use a numeric parameter type if you are using the parameter in a numeric expression.
In relational data objects, you do not need to escape the dollar sign ($) in SQL overrides, filter conditions, join conditions. The Data Integration Service treats a field that begins with a dollar sign in an SQL statement as a parameter.
A parameter cannot contain a series of values. If you provide a series of values in a parameter, the Data Integration Service treats the parameter values as a single string value.
For example, you have the parameters $IndexParameter1 (value 2) and $IndexParameter2 (value1, value2, value3). You include these parameters in the expression INDEXOF as:
INDEXOF($IndexParameter1,'value1','value2','value3')
The Data Integration Service returns the value 0 instead of the value 2.

0 COMMENTS

We’d like to hear from you!