Sign Up for Training |
Jet Global Company Site
Submit a Request
Become a Jet Insider
Give Feedback

Legacy Transformations


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.


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

  2. Check the box to use Legacy Transformations.

    • If Use legacy transformations 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.


Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request