Sequential File Incomplete Column Abort
Query name | Sequential File Incomplete Column Abort |
---|---|
Server Asset Type | Sequential File stage |
Analysis Type | Advisory |
Description | Describes the Stage, Link and Column that are not set to the default Missing Column Action value. |
Issue
In Sequential File’s Columns tab (under the Outputs link tab) each column has an attribute called Incomplete Column. The default value for this in Server Jobs is ‘Error’ (0) which causes the job to abort.
This behaviour is not available in the Parallel engine Sequential File where the default behaviour is to discard incomplete rows - the equivalent of the Discard and Warn action.
Actions
None required.
See also
© 2015-2024 Data Migrators Pty Ltd.