Table of Contents

Search

  1. Preface
  2. Mappings
  3. Parameters
  4. CLAIRE recommendations
  5. Data catalog discovery
  6. Visio templates

Mappings

Mappings

Rules and guidelines for in-out parameters

Rules and guidelines for in-out parameters

Consider the following rules and guidelines:
  • When you write expressions that use in-out parameters, you do not need string identifiers for string variables.
  • When you use a parameter in a transformation, enclose string parameters in string identifiers, such as single quotation marks, to indicate the parameter is a string.
  • When you use in-out parameter in a source filter of type date/time, you must enclose the in-out parameter in single quotes because the value received after
    Informatica Intelligent Cloud Services
    resolves the in-out parameter can contain spaces.
  • When required, change the format of a date/time parameter to match the format in the source.
  • If you copy, import, or export a
    mapping
    task, the session values of the in-out parameters are included.
  • You cannot use in-out parameters in a link rule or as part of a field name in a mapping.
  • You cannot use in-out parameters in an expression macro, because they rely on column names.
  • When you use an in-out parameter in an expression or parameter file, precede the parameter name with two dollar signs ($$).
  • An in-out parameter value cannot exceed 4000 characters.
  • For elastic mappings, you cannot use an in-out parameter as a placeholder for an expression.