Legacy Transformations

Overview

Modern versions of the Jet Data Manager use Set Based Transformations

Enable Scalar-Valued User Defined Functions

1. Right-click a table and select Advanced > Advanced Settings > Performance.

2. Check the box to use Legacy Transformations.

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