Engine Compatibility Mode
Due to the shift from single-threaded data processing with the original Engine to multi-threaded processing 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, performance of the workflow with the new record output order on AMP with Engine Compatibility Mode will be 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 these tools:
- Batch Macros
- Cross Tab
- 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