Query name	Disable Schema Reconciliation
Server Asset Type	Database Connectors
Analysis Type	Remediation
Description	List of Connectors supporting Schema Reconciliation that have Fail on type mismatch property set to True

Issue

Server Jobs do not validate Null values like Parallel Jobs and will process Null data regardless of a column’s nullability. To replicate this behaviour in Parallel, S2PX sets all columns to Nullable.

To avoid the risk of this change causing jobs to abort, the Fail on type mismatch property is set to False, where required, in the generated Parallel Job.

Disabling this property introduces the risk that other schema type differences introduced by Server to Parallel conversion will not be detected.

Users making active use of their Server Jobs' Schema Reconciliation capabilities should pay particular attention to this issue.

Actions

These jobs require particular attention in testing to verify that when they are executed with real data…

the Job produces the expected output, and
no other schema type differences are introduced, as the job will no longer abort for this reason.