SAP HANA Connector > Mappings and mapping tasks with SAP HANA Connector > SAP HANA lookups in mappings
  

SAP HANA lookups in mappings

When you configure field mappings, you can create a lookup to an SAP HANA object. Lookups are only applicable for SAP HANA database tables and views. You can't configure lookups for SAP HANA database modelling views.
Note: You can't configure a Lookup transformation in a data transfer task.
The following table describes the SAP HANA lookup object properties that you can configure in a Lookup transformation:
Property
Description
Connection
Name of the lookup connection.
You can select an existing connection, create a new connection, or define parameter values for the lookup connection property.
If you want to overwrite the lookup connection properties at run time, select the Allow parameter to be overridden at run time option. When the task runs, the agent uses the parameters from the file that you specify in the task advanced session properties.
You can switch between a non-parameterized and a parameterized SAP HANA connection. When you switch between the connections, the advanced property values are retained.
Object Type
Type of the source object.
Select one of the following lookup object types from the list:
  • - Single Object
  • - Query
  • - Parameter
Default is Single Object.
When the lookup source is large, you can use a custom query to reduce the number of columns to query.
Lookup Object
Name of the lookup object for the mapping.
Parameter
This property appears only if you select Parameter as the object type.
A placeholder to dynamically assign values at run time for the lookup object without the requirement to edit the task.
Select an existing parameter for the lookup object or click New Parameter to define a new parameter for the lookup object.
If you want to overwrite the parameter at run time, select the Allow parameter to be overridden at run time option when you create a parameter. When the task runs, the agent uses the parameters from the file that you specify in the task advanced session properties.
Multiple Matches
Behavior when the lookup condition returns multiple matches.
Select one of the following options from the list to determine the behavior:
  • - Return first row
  • - Return last row
  • - Return any row
  • - Return all rows
  • - Report error
Default is Return any row.
Query
This property appears only if you select Query as the object type.
The query to look up data.
Click Define Query, enter a valid custom query, and then click OK.
The following table describes the SAP HANA lookup advanced properties that you can configure in a Lookup transformation:
Property
Description
Lookup Source Filter1
Limits the number of lookups that the mapping performs on the cache of the lookup source table based on the value you specify in the filter condition.
Maximum length of the filter condition is 32768 characters.
This property is applicable when you select Single Object as the object type and enable lookup cache on the Advanced tab of the Lookup transformation.
For more information about this property, see Lookup source filter in Transformations in the Data Integration documentation.
Lookup SQL Override
Overrides the default SQL query used to read data from the SAP HANA source.
Tracing Level1
Sets the amount of detail that appears in the log file.
Select one of the following options from the list:
  • - Terse
  • - Normal
  • - Verbose Initialization
  • - Verbose Data
Default is Normal.
1Doesn't apply to mappings in advanced mode.