Thursday, 5 February 2015

50 TOP SAP HANA Interview Questions and Answers (Part1)

Below are some important SAP HANA interview questions which are asked in most MNC company interviews for beginners or professionals.
1. What are the different types of replication techniques?
There are 3 types of replication techniques:
1. SAP Landscape Transformation (SLT)
2. SAP Business Objects Data Services (BODS)
3. SAP HANA Direct Extractor Connection (DXC)
Note: There is one more replication technique called Sybase replication. It was part of initial offering for HANA replication, but not positioned / supported anymore due to licensing issues and complexity and mostly because SLT provides the same features.

2. What is SLT?
The SAP Landscape Transformation (LT) Replication Server is the SAP technology that allows us to load and replicate data in real-time from SAP source systems and non-SAP source systems to an SAP HANA environment.
The SAP LT Replication Server uses a trigger-based replication approach to pass data from the source system to the target system.
HANA Overview

3. What is the advantage of SLT replication?
1. SAP LT uses trigger based approach. Trigger-based approach has no measureable performance impact in source system.
2. It provides transformation and filtering capability.
3. It allows real-time (and scheduled) data replication, replicating only relevant data into HANA from SAP and non-SAP source systems.
4. It is fully integrated with HANA Studio.
5. Replication from multiple source systems to one HANA system is allowed, also from one source system to multiple HANA systems.

4. Is it possible to use a replication for multiple sources and target SAP HANA systems?
Yes, the SAP LT Replication Server supports both 1:N replication and and N:1 replication.
Multiple source system can be connected to one SAP HANA system.
One source system can be connected to multiple SAP HANA systems. Limited to 1:4 only.

5. Is there any pre-requisite before creating the configuration and replication?
For SAP source systems:
DMIS add-on must be installed in SLT replication server.
An RFC connection between the SAP source system and the SAP LT Replication Server has to be established.
User for RFC connection must have the role IUUC_REPL_REMOTE assigned.
Do not use a DDIC user for RFC connection.
For non-SAP source systems:
DMIS add-on is not required.
A database user has to be created with appropriate authorizations in advance and establish the database connection by using transaction DBCO in the SAP LT Replication Server.
Ensure the database-specific library components for the SAP 7.20 REL or EXT kernel are installed in the SAP LT Replication Server.

6. What is Configuration and Monitoring Dashboard?
It is an application that runs on SLT replication server to specify configuration information (such as source system, target system, and relevant connections) so that data can be replicated.
It can also use it to monitor the replication status (transaction LTR).
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).

7. What is advanced replication settings (transaction IUUC_REPL_CONT)?
The Advanced Settings (transaction IUUC_REPL_CONT) allows you to define and change various table settings for a configuration such as:
Partitioning and structure changes for target tables in HANA
Table-specific transformation and filter rules
Adjusting the number of jobs (and reading type) to accelerate the load/replication process

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

9. What is logging table?
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.

10. What are Transformation rules?
A rule specified in the Advanced Replication settings transaction for source tables such that data is transformed during the replication process. Example you can specify rule to
Convert fields
Fill empty fields
Skip records
More Questions & Answers :-

1 comment:

  1. Tks very much for your post.

    Avoid surprises — interviews need preparation. Some questions come up time and time again — usually about you, your experience and the job itself. We've gathered together the most common questions so you can get your preparation off to a flying start.

    You also find all interview questions at link at the end of this post.

    Source: Download Ebook: Ultimate Guide To Job Interview Questions Answers:

    Best rgs