Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Query name

Sequential File Incomplete Column Handling

Server Asset Type

Sequential File

Analysis Type

Remediation

Output Type

Descriptive

Description

Describes the Stage, Link and Column that are not set to the default Missing Column Action value.

Issue

The Sequential File stage in Server offers far more granular support for missing or incomplete options than is possible in Parallel, The default value causes the job to abort, which is the most conservative default option to choose in Parallel. Any field that is set to a different option is listed in the result, leading to a review of the initial requirement and/or manual remediation.

Actions

Understanding the data is key. As the available actions to handle incomplete data are less granular than in Server, decisions on how to handle data issues need to be made on a per table level.

The default mode of operation is to now reject any rows containing incomplete data, which is the same as setting the Reject Mode property to Discard and Warn in the Server version, but set at a stage level.

Adding $APT_IMPORT_HANDLE_SHORT as a job property changes this behaviour to the equivalent of Retain and Warn, but affects the entire job.

  • No labels