Engine Compatibility Mode
Due to the shift from single-threaded data processing with the original engine to multi-threaded with AMP, the record output order with some tools might be different from the input order when using AMP. This is one of the key differences between the engines that changes the user experience and expectations.
In most cases, workflow performance with the new record output order on AMP with Engine Compatibility Mode is slower than without this functionality, but still faster than with the original engine.
- The Engine compatibility mode check box is available in the Designer UI under the Use AMP Engine check box.
- The Engine compatibility mode check box is unchecked by default, even when the Use AMP Engine check box is turned on for all new workflows.
Engine Compatibility Mode can affect the record order for the following tools:
-
Batch macros
-
Cross Tab
-
Data Cleansing (when removing null rows)
-
Join (Join by Specific Field)
-
Join Multiple (Join by Specific Field)
-
Multi-Row Formula (Group By)
-
Poly Build
-
Running Total (Group By)
-
Sample (Group by column)
-
Summarize (Group By)
-
Tile (Group by columns)
-
Unique