Table of Contents

Search

  1. Preface
  2. The Transformation Language
  3. Constants
  4. Operators
  5. Variables
  6. Dates
  7. Functions
  8. Creating Custom Functions
  9. Custom Function API Reference

Transformation Language Reference

Transformation Language Reference

$PM<SourceName>@TableName, $PM<TargetName>@TableName

$PM<SourceName>@TableName, $PM<TargetName>@TableName

$PM
<SourceName>
@TableName and $PM
<TargetName>
@TableName return the source and target table names for relational source and target instances as string values. Use these variables with any function that accepts string datatypes.
The variable name depends on the source or target instance name. For example, for a source instance named “Customers,” the built-in variable name is $PMCustomers@TableName. If the relational source or target is part of a mapplet within a mapping, the built-in variable name includes the mapplet name:
  • $PM
    <MappletName>
    .
    <SourceName>
    @TableName
  • $PM
    <MappletName>
    .
    <TargetName>
    @TableName
Use $PM
<SourceName>
@TableName and $PM
<TargetName>
@TableName in a mapping or a mapplet. For example, in a mapping that contains multiple relational sources, you can use $PM
<SourceName>
@TableName in the output port of an Expression transformation to write the source table name for each row to the target. You can also use these variables in input fields that accept mapping variables.