Changing the calculation order of derived attributes for JET transformations

You can change the calculation order of derived attributes. The calculation order is important if a derived attribute references another derived attribute.

Before you begin

You must have a transformation model file open. A transformation model file has the name transform.tma. The transformation input schema must contain at least one derived attribute. The derived attributes must be displayed in calculation order.

About this task

To move a derived attribute to a different position in the calculation order:

Procedure

  1. In the Transformation input schema and output actions pane, right-click the derived attribute; then click Move.
  2. Complete one of the following steps:
    • To move the attribute more than one step up or down in the hierarchy, click Move. In the Move window, click the destination for the derived attribute, and click OK.
    • To move the derived attribute up or down one level in the input schema hierarchy, click Move Up or Move Down.

What to do next

Tip: To change the calculation order, you can also drag attributes to a different location in the hierarchy.

Feedback