SAP Hana Interview Questions and Answers

In SAP HANA, catalog represents the SAP HANA’s data dictionary which includes all data structures, data, and tables which can be used. All the views and physical tables can be found under the catalog nod.

There are three types of views available in SAP HANA, which are as follows:

• Attribute views: It provides descriptive data about the characteristics of data in the user database.
• Analytic views: It constructs a central master “fact table” with key figures.
• Calculation views: It provides a way to do complex, flexible logic in the database.

In SAP HANA, Package is used by developers to group together related content objects in SAP HANA Studio. It only contains sub-packages and cannot include repository objects. A package consists of both sun packages and repository objects.

SAP HANA has six types of Join methods available with it. Inner Join: It selects the set of records matching in both the table.

• Left Outer Join: This Join selects the complete set of records from the first table while matching a record from the second table if available.
• Right Outer Join: It works opposite to Left Outer Join. It selects the complete set of records from the second table while matching a record from the first table if available.
• Full Outer Join: This Join selects all the records available from both the table.
• Referential Join: Works with the same principle as the Inner Join by confirming a maintained referential entity maintained between the two tables.
• Text Join: It is used to select language specific specifications.

Acquire guaranteed interview success with these advance SAP HANA interview questions.

Here are the advantages of SLT replication:

• It allows data replication from multiple system sources to one HANA system and one source system to various HANA systems
• It uses a trigger based approach and has no measurable performance impact on the source system.
• It offers data filtering and transformation capability before HANA database loading.

In SAP HANA, calculation views are used by developers to consume attribute and other calculation views. They are also used to perform very complex calculations.

There are two methods available to create calculation view in SAP HANA:

• SQL Editor
• Graphical Editor

In SAP HANA, the CE functions or Calculation Engine Plan Operators are specially optimized for HANA and can perform better compared to SQL statement.

In SAP HANA, a decision table is a tabular representation of the decision-making process. It doesn’t portray static solutions or answers, and standardized the logical process and allows developers to insert the values in both the actions and conditions related to the decision.