Transformation Designer - element parameters - lookup

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 (mandatory)
tablename is the name of the lookup table to be used for this field.
business-unit

Where buspec is one of auto:source, auto:target, or a valid business unit.

To perform lookup operations specific to a business unit, the business unit to be used must be determined when the transformation of data takes place. This setting instructs the transformation to obtain the business unit from either the source of the data being transformed or the target of the transformed data.

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 (mandatory)
Specifies the fully qualified target path, as defined in the specified lookup table, to be generated in the output data.
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.