SAP HANA: Interview Questions 1 through 10

1. State the different types of replication techniques? 
 SAP HANA supports 3 types of replication techniques: 
  • ETL based replication using BODS 
  • Trigger based replication using SLT 
  • Extractor based data acquisition using DXC 
2. What is SLT?  
SAP Landscape Transformation (SLT) is a trigger based replication technology that used to provision the data from the source system to the target system.  
The source can be either SAP or non-SAP database whereas the target is SAP HANA system.
   
3. Can we load and replicate data from one source system to multiple target database schemas of HANA system?  
Yes; can be loaded and replicated for up to 4.  

4. Can the type of data load and replication be specified?  
It can be either in real time, or scheduled by time or by interval.  

5. Define Configuration in SLT?  
The information required to create the connection between the source system, SLT system, and the SAP HANA system is specified within the SLT system as a Configuration, and is defined in Configuration & Monitoring Dashboard (transaction LTR). 

6. What additional limitations does Sybase Replication Server present?  
SRS only replicates Unicode data and does not support IBM DB2 compress tables.

7. Define what is Configuration and Monitoring Dashboard?  
They are applications that run on SLT replication server to specify configuration information (such as source system, target system, and relevant connections) so that data can be replicated.  
The replication status (transaction LTR) can also be monitored. 
Status Yellow occurs due to triggers which are not yet created successfully. Status Red occurs if master job is aborted (manually in transaction SM37).  

8. What is advanced replication settings?  
Advanced Replication settings is a transaction that runs on SLT replication server to specify advanced replication settings like modifying target table structures, specifying performance optimization settings that defines transformation rules. 

9. Define Latency?  
Latency is the length of time to replicate data (a table entry) from the source system to the target system.  

10. What is logging table? 
 A logging table in the source system can record any changes to a table that is being replicated. 
This thereby ensures that the SLT replication server can replicate these changes to the target system.

No comments:

Post a Comment