The lookup element employs lookup tables which specify a set of data
values that should be passed to the function.
<lookup table='tablename' business-unit='buspec' unknown='unknownoption'>
<target/>
<source/>
</lookup>
Parameters
- lookup
-
- table
tablename is the name of the lookup
table to be used for this field. This parameter is mandatory.- business-unit
- Where
buspec is one of auto:source, auto:target, or a valid business unit.
- For example, when performing an internal transfer of data from business
unit BUA (the source) to BUB (the target), selecting
auto:source in the transformation selects BUA
as the business unit to be used for the transformation. Selecting auto:target, selects BUB as the business unit
to be used for the transformation. When the business unit for the
internal transfer is the same for the source and target, the selection of
either auto:source or auto:target in the transformation selects the
same business unit.
- Where there is no business unit specified for the source or target, a
'null' business unit is used for the transformation. In this case global
lookup data is used.
- unknown
- Where
unknownoption is one of the
following:
-
fail - an error message is
displayed when an unknown value is being transformed.copy - the source value is used
'as is', that is, a transformation is not performed on it.
- target
- Specifies the fully qualified target path, as defined in the specified lookup
table, to be generated in the output data. This parameter is mandatory.
- source
- Specifies the fully qualified source path in the input data. The following set of
rules applies:
-
- If this value is not present the default value specified in
the
SSX_LOOKUP_VALUE table is used.
- If this value is present, but not found in the lookup
table, the user configured value as specified in
unknownoption is used.
- If the value is present and can be found in the lookup
table, the substitution value from the lookup table is used.