SAP HANA Developer Interview Questions and Answers

What is SLT? How do you configure it?
It stands for SAP Landscape Transformation. It triggers replication of data from source to target system where either of the two ends has to be SAP HANA.
The configuration is performed in the Configuration & Monitoring dashboard using t-code LTR.

What are the different Replication techniques?
Trigger based replication using SLT
ETL based replication using BODS
Extractor data acquisition using DXC

What is Row based and Column based approach?
The database table is populated in the sequence of rows. Relational databases till now have been following Row based approach. On the contrary, Column based approach has tables being populated in sequence of columns occupying all contiguous memory locations.  HANA supports both but is optimized more for Column approach.

What are the prerequisites to configure SLT?
For SAP source systems – The role IUUC_REPL_REMOTE is assigned to the RFC user
DMIS add-on has to be installed in the SLT system.For non-SAP systems – DMIS is not essential here. A database user can be authorized to perform replication activities.

What are Transformation rules?
These are the rules defined in the Advanced Replication Settings such that the data for the source tables is transformed during replication process.Fill Empty Fields
Convert Fields
Skip Records
What factors affect the change in number of jobs?
Number of Jobs depends upon the following –
The number of tables to be replicated
Number of configurations managed in SLT system
Initial Load speed
Expected Replication Latency time

What are the different scenarios in Replication?
Load – Starts the initial load of replication of data from the source system. It is a one-time process.
Replicate – Actual phase of replication. Database triggers and different logging tables for every table is created in SLT.
Stop – Stops any replication currently in process. Database triggers are aborted.
Suspend – Table replication is paused. Database trigger will not be deleted and changes will be filled in logging tables.
Resume – Restarts the replication for a suspended table.

What is the maximum table name length and the Max number of columns allowed? 
Max table name length – 127 characters
Max no of columns – 1000All geared up for a career in SAP HANA? Stay tuned and keep updated with more insights.

Tags: Top 100 sap hana interview questions
Share this article :

Post a Comment

Copyright © 2011. SAP HANA TUTORIALS FREE - S/4 HANA - All Rights Reserved