VERIFIED SOLUTION i
Resolve different outputs from the same plan after version upgrade in Sagent
Different output from the same plan (using Sorted Union transform) on different version of Sagent.
This could happen due to a scenario where column(s) get deleted, during upgrade, from the key column list of Sorted Union transform after upgrading from Sagent.
UPDATED: December 26, 2017
Try following steps to get the desired results:
- Open the plan in Design Studio.
- Open the properties of 'Sorted Union Transform'.
- Switch to Advance tab.
- Uncheck the option that 'Data is presorted'.
- Press OK.
Operating System: Windows and AIX
- No Downloads