Adding Transformation and Lookup Details Graphically

You can add transformation and lookup details to a mapping specification in the Graphical Designer tab.

Adding transformation details involves setting up:

  • Business rule
  • Extended business rule transformation

Ensure that you define business rules under the Transformations node for the same ETL Option as the Project ETL. For more information on defining business rules, refer to the Defining and Managing Transformations section.

Adding lookup details involves setting up:

  • Trans lookup condition
  • Lookup reference column
  • Lookup on

Ensure that you scan the required table in the Metadata Manager to set trans lookup condition.

Adding Transformation Details

To add business rules graphically, follow these steps:

  1. In the Graphical Designer tab, click the mapping link of the required column and expand the Properties side deck.
  2. In Properties, expand the Transformation Details tab.
  3. Double-click the cell against the Business Rule and select the required value.

    4. Ensure that you defined business rules under the Transformations node for the same ETL Option as that of the Project ETL.

  4. Click .

    5. The business rule is added to the mapping link. You can add business rules for multiple mapping links.

To add extended business rule transformation graphically, follow these steps:

  1. In the Graphical Designer tab, click the mapping link of the required column and expand the Properties side deck.
  2. In Properties, expand the Transformation Details tab.
  3. Double-click the cell against Extended Business Rule Transformation.

    4. The Extended Transformation Rule Editor page appears.

  4. Select the pseudocode based on the Project ETL.

  5. Press Ctrl-Space.

    6. Note: If the required transformation is not available in the list, use to create and update the transformations list.

  6. Double-click the required transformation.

    7. You can use to replace transformation name with pseudocode.

  7. Click .

    8. The extended business rule transformation is added to the mapping link. You can add extended business rule transformations to multiple mapping links.

Adding Lookup Details

To add lookup details graphically, follow these steps:

  1. In the Graphical Designer tab, click the mapping link of the required column and expand the Properties side deck.
  2. Expand the Lookup Details tab.
  3. Drag the required table from Metadata Catalogue and drop it against Trans Lookup Condition.

    4. Once trans lookup condition is set, you can add lookup reference column and lookup on.

    To add lookup reference column, double-click the cell against Lookup Reference Column and select the required option.

    To add lookup on, double-click the cell against Lookup On and select the required option.

  4. Click .

    5. The lookup details are added to the mapping specification. You can add lookup details for multiple mapping links.