Each aggregate table column can have a transformation associated with it. The transformation will be included in the generated procedure and will be executed as part of the procedure update. The transformation must therefore be a valid SQL construct that can be included in a Select statement. For example, we could have a transformation of 'load_order_line.quantity * 0.125' to calculate a tax column of 12.5%. Click the Transformation tab to enter a transformation.

Transformations are only put into effect when the procedure is re-generated.

Refer to Transformations for details.
 

  • No labels