SAP HANA Top 10 Interview Question and Answers

Here this article is about SAP HANA Top 10 Interview Question and Answers which are very useful for the seekers in the future when you attend interview regarding SAP FICO. These Question and answers are explained in a brief way and in a simple manner where the readers can understand easily without any difficulties. After reading these please share your testimonial with us. All the best

Introduction to SAP HANA

SAP HANA is an application which is used in memory database technology that allows the processing of huge amount of data in a short time. The in memory computing engine allows HANA to process data stored in RAM as opposed to reading it from a disk. This allows the application to provide immediate results from customer transactions and data analyses.

1) Mention the various types of replication techniques?

Ans: ETL based replication using BODS
Trigger based replication using SLT
Extractor based data acquisition using DXC

2) Define SLT?

Ans: SLT stands for “SAP Landscape Transformation” which is a set off based replication. SLT replication server is the replication technology to pass data from source system to the target system. The source can be also SAP or non-SAP. Target system is SAP HANA system which contains HANA database.

3) Define Configuration in SLT?

Ans: The information to create the connection between the source system, SLT system, and the SAP HANA system is specified within the SLT system as a Configuration. We can define a new configuration in Configuration & Monitoring Dashboard.

4) Mention any prerequisites before creating the configuration and replication?

Ans: For the SAP source systems DMIS add-on is installed in SLT replication server. User for RFC connection has the role IUUC_REPL_REMOTE assigned but not DDIC. For non-SAP source systems DMIS add-on is not required and grants a database user sufficient authorization for data replication.

5) Define Configuration and Monitoring Dashboard?

Ans: It is an application that runs on SLT replication server to specify configuration information like source system, target system, and relevant connections so that data can be replicated. It can also use it to monitor the replication status.

Status Yellow: It may occur due to triggers which are not yet created successfully.

Status Red: It may occur if master job is aborted (manually in transaction SM37).

6) What is advanced replication settings?

Ans: A transaction which runs on SLT replication server to identify advanced replication settings like Modifying target table structures, Specifying performance optimization settings.

7) Define Latency?

Ans: It is the length of time to replicate data (a table entry) from the source system to the target system.

8) Define logging table?

Ans: A table in the source system that records any changes to a table that is being replicated. This ensures that SLT replication server can replicate these changes to the target system.

9) What are Transformation rules?

Ans:A rule specified in the Advanced Replication settings transaction for source tables such the data is transformed during the replication process.

For example we can specify rule to

• Convert fields
• Fill empty fields
• Skip records

10) How to avoid unnecessary logging information from being stored?

Ans:We can pause the replication by stopping the schema related jobs.