Table of Contents

Search

  1. Preface
  2. Introduction to Mapping Specifications
  3. Mapping Specification Configuration
  4. Mapping Specification Objects
  5. Mapping Specification Profiles
  6. Sharing Mapping Specification Logic

Mapping Specification Guide

Mapping Specification Guide

Creating a Mapping Specification Rule

Creating a Mapping Specification Rule

Create a rule for a target column in a mapping specification to develop business logic for the column. When you create a rule, you configure the edit options for the rule. You can also choose to make the rule reusable.
  1. From the Actions menu, click
    Edit
    Rules
    .
    The
    Edit Mapping Specification
    wizard appears.
  2. Select the
    New
    icon.
    The
    New Rule
    wizard appears.
  3. Select
    Create a Rule
    .
  4. Click
    Next
    .
  5. Enter a name and an optional description.
  6. Select a target column name to apply the rule to.
  7. To make the rule reusable, select
    Save the rule
    and select a project to save the rule.
  8. On the
    Functions
    tab, select a function, click the arrow icon, and select a column to add the function to the Expression editor.
  9. Optionally, on the Columns tab. select a target column and click the arrow icon to add it to the Expression editor.
  10. Optionally, on the
    Rules
    tab, select a column and datatype and click the arrow icon to add the rule column to the Expression editor.
  11. Optionally, on the
    Lookup
    tab, select a column and datatype and click the arrow icon to add the Lookup column to the Expression editor.
  12. Click
    Finish
    .
  13. Click
    Yes
    to replace the transformation object and click
    Save
    .

0 COMMENTS

We’d like to hear from you!