Reading Data from SAP HANA Modelling Views Using PowerCenter

Reading Data from SAP HANA Modelling Views Using PowerCenter

Input Types for HANA Modelling Views

Input Types for HANA Modelling Views

You can use the following input types when you read data from SAP HANA modelling views:
  • Variables. A variable is a filter. A variable is associated with an attribute column, for example, company name, of the view. However, a variable does not appear in the source metadata in the PowerCenter Designer.
    Provide the variable value in the attribute column that you specified in SAP.
  • Parameters. An input parameter is a placeholder to the query. You can use parameters to insert values for analytical views and calculation views. The data type for an input parameter in PowerCenter is
    char
    .
    Specify the data for input parameters in the format that you defined in SAP.

0 COMMENTS

We’d like to hear from you!