Description

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

...

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.