PowerExchange for HANA User Guide for PowerCenter

10.5.4
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5
- 10.4.1
- 10.4.0

Back Next

Creating a HANA Mapping

After you import the HANA table, view, or modelling view, create a mapping.

To read from modelling views in SAP HANA, you must select a source filter that you configured in HANA and specify the variables or parameters in the source qualifier.

Perform the following tasks to create a mapping to read from HANA modelling views:

Create a mapping.

If you use input parameters, do not connect the input parameters in the Source Qualifier to the output fields. Otherwise, the mapping fails.

To edit the Source Qualifier, click the

Properties

tab in the

Edit Transformations

window.

Click the

icon next to the

Source Filter

field.

The

SQL Editor

page appears.

Select the column view in which you want to apply a filter from the list of column views on the left pane.

Specify the variable name or input parameter name in double quotes. Specify the variable value or input parameter value in single quotes. When you want to specify more than one variable or parameter, separate the variables or parameters using commas.

The following image shows a source filter for a variable value: The view uses a variable COMPANY that has a value of 1000.