|
<< Click to Display Table of Contents >> ETL > 14.0 > Implementation Guide > Tutorial and implementation guide > Steps > Enriching Fallback |
The last item in the enrichment list may be a fallback, which provides a way to guarantee there is a non-null value in the enriched column once the transformation is over.
{
"take": {
"value": "n/a"
}
}
The fallback is defined by omitting any parameters except of the value, which should be a fixed value to be used as a last-resort if all enrichment steps failed to deliver a non-null value.
You can safely omit the last step (fallback). If fallback is not defined (all look-up items have parameter in) then NULL will be used as a fallback value.
The value type is inferred from the context. To enforce an arbitrary column type (for example VARCHAR(128)) use the property type. More information about arbitrary types can be found in chapter Arbitrary column types