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

Version 1 Next »

Rule name

Lookup Failure

Parallel Job

Yes

Server Job

No

Job Sequence

No

Description

Identifies Lookup Stages with Lookup set to Fail

Description

Lookup stages have a ‘Condition Not Met’ setting which describes what happens when a key lookup fails. Options are:

  • Continue - The fields from that link are set to NULL if the field is nullable, or to a default value if not, and processing continues

  • Drop - Drops the row and continues with the next lookup

  • Fail - Causes the job to issue a fatal error and stop

  • Reject - Sends the row to the reject link

By default Lookup stages are configured to Fail should a key lookup fail. This unexpected job abort is, in most cases, not the behaviour the developer intended. These lookup fails should be handled gracefully in the ETL job.

Actions

Reconfigure your Lookup stage so that reference links are not set to abort the job should a key lookup fail.

  • No labels

© 2015-2024 Data Migrators Pty Ltd.