Disable Schema Reconciliation
- John McKeever
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.
© 2015-2024 Data Migrators Pty Ltd.