Using Source Expressions

When importing data, you can apply source expressions to source dimensions. Source expressions can be used to enhance and transform the source value read from the file. For example, use a Rpad expression type to pad (add extra characters) to the right of a source dimension value to ensure a specific length.

For an "Amount" source dimension, the following source expression types are available:

For information about applying source expressions to the Amount dimension, see Using Source Expressions for the Amount Dimension.

The following source expression types are available for non-Amount source dimensions:

To assign a source expression:

  1. From the Data Integration home page, click Image shows Select icon. to the right of the integration, and then select Map Dimensions.

  2. From Import Format, select the name of the import format to use for the integration.

    You can also add a user defined import format name.

  3. File-Based Sources Only. Optional: From Type, select the format of the file.

    For more information on file formats, see Creating the Dimension Maps.

  4. In the mappings grid, select the source value to which to add a source expression by clickingImage shows the Add row icon. to the right of the dimension, and then selecting Edit Source Expression.

  5. From the Edit Source Expression screen, click Expression Type, and then select a source expression.

    Note:

    The source expression types that can be applied to the Amount dimension include: Fill, DRCRSplit, Sign, Factor, and NZP. Multiple source expressions can also be applied to the Amount dimension. To add multiple source expression types, click Image shows the Add Expression icon.. The Amount dimension does not accept Constant, Lpad, and Rpad expression types.
  6. From the Edit Source Expression screen, select all parameters associated with the source expression, and click OK.

    The parameters shown on the page depend on the expression type.

    To remove a source expression type, click Image shows the Remove Expression icon.