Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Legacy Transformations

Overview

Modern versions of the Jet Data Manager use Set Based Transformations .

Should you need to use Scalar-Valued User Defined Functions , the following demonstrates how to enable this legacy feature.

Process

  1. Right click on a table and select Advanced → Advanced Settings → Performance

  2. Check the box to use Legacy Transformations.

    • If Use legacy t ransformations is checked, the Jet Data Manager will revert to the previous SQL Code generation for transformations and create Scalar-Valued User Defined Functions.
    • If Use legacy transformations is un-checked (Default) then the Jet Data Manager will generate CASE-WHEN structures in the Transformation views instead of Scalar-Valued User Defined Functions.

    legacy_trans.png

Published:

Legacy Transformations

Overview

Modern versions of the Jet Data Manager use Set Based Transformations .

Should you need to use Scalar-Valued User Defined Functions , the following demonstrates how to enable this legacy feature.

Process

  1. Right click on a table and select Advanced → Advanced Settings → Performance

  2. Check the box to use Legacy Transformations.

    • If Use legacy t ransformations is checked, the Jet Data Manager will revert to the previous SQL Code generation for transformations and create Scalar-Valued User Defined Functions.
    • If Use legacy transformations is un-checked (Default) then the Jet Data Manager will generate CASE-WHEN structures in the Transformation views instead of Scalar-Valued User Defined Functions.

    legacy_trans.png

For an optimal Community experience, Please view on Desktop