Learn SAP HANA Training from the Best Tutors
Search in
Answered on 04/02/2021 Learn SAP HANA
Pooja Jain
SAP ONLINE TRAINING AND CERTIFICATION
Answered on 10/12/2019 Learn SAP HANA
Sai V
Tutor On Salesforce development and Artificial Intelligence and machine learning python
Answered on 23/10/2018 Learn SAP HANA
Pramod Mouli
Learn SAP HANA Training from the Best Tutors
Answered on 19/05/2018 Learn SAP HANA
Subha Hana Consultant
SAP HANA Consultant with BODS and SAP ABAP having an 10+ years of total experience on IT field. First...
Answered on 08/04/2018 Learn SAP HANA
TechGeest Solutions
Training Centre
Lesson Posted on 24/02/2018 Learn SAP HANA
Top 15 SAP HANA Interview Questions & Answers
Harsh Sharma
I am working from past 15 years in different Sap Domains and having vast experience in lot of SAP technologies...
1) Mention what is SAP HANA?
Ans. SAP HANA stands for High Performance Analytical Appliance- in-memory computing engine. HANA is linked to ERP systems; Frontend modeling studio can be used for replication server management and load control.
2) Mention the two types of Relational Data stored in HANA?
Ans. The two types of relational data stored in HANA includes
3) Mention what is the role of the persistence layer in SAP HANA?
Ans. SAP HANA has an in-memory computing engine and access the data straightaway without any backup. To avoid the risk of losing data in case of hardware failure or power cutoff, persistence layer comes as a savior and stores all the data in the hard drive which is not volatile.
4) Mention what is modeling studio?
Ans. Modeling studio in HANA performs multiple task like
5) Mention what are the different compression techniques?
Ans. There are three different compression techniques
6) Mention what is latency?
Ans. Latency is referred to the length of time to replicate data from the source system to the target system.
7) Explain what is transformation rules?
Ans. Transformation rule is the rule specified in the advanced replication setting transaction for the source table such that data is transformed during the replication process.
8) Mention what is the advantage of SLT replication?
Ans. The advantage of SLT replication are:
9) Explain how you can avoid un-necessary information from being stored?
Ans. To avoid un-necessary information from being stored, you have to pause the replication by stopping the schema-related jobs
10) Mention what is the role of master controller job in SAP HANA?
Ans. The job is arranged on demand and is responsible for
11) Explain what happens if the replication is suspended for a longer period of time or system outage of SLT or HANA system?
Ans. If the replication is suspended for a longer period of time, the size of the logging tables increases.
12) Mention what is the role of the transaction manager and session?
Ans. The transaction manager co-ordinates database transactions and keeps a record of running and closed transactions. When transaction is rolled back or committed, the transaction manager notifies the involved storage engines about the event so they can run necessary actions.
13) Explain how you can avoid un-necessary logging information from being stored?
Ans. You can avoid un-necessary logging information from being stored by pausing the replication by stopping the schema-related jobs.
14) Explain how SQL statement is processed?
Ans. In the HANA database, each SQL statement is implemented in the reference of the transaction. New session is allotted to a new transaction.
15) Name various components of SAP HANA?
Ans. The various components of SAP HANA are:
Learn SAP HANA Training from the Best Tutors
Lesson Posted on 24/02/2018 Learn SAP HANA
SAP HANA SQL Stored Procedure Tutorial
Harsh Sharma
I am working from past 15 years in different Sap Domains and having vast experience in lot of SAP technologies...
A procedure is a unit/module that perform a specific task. This procedure can be combined to form larger programs. This basically forms the 'Modular Design'. A procedure can be invoked by another procedure which is called the calling program.
Procedures are re-useable processing block with a specific sequence of data transformation. The procedure can have multi-input/output parameters. The procedure can be created as read-only or read-write.
An SQL Procedure can be created at:
Stored Procedure syntax in SAP HANA is as shown below:
SYNTAX
CREATE PROCEDURE [()] [LANGUAGE ] [SQL SECURITY ] [DEFAULT SCHEMA ] [READS SQL DATA [WITH RESULT VIEW ]] AS {BEGIN [SEQUENTIAL EXECUTION] END | HEADER ONLY }
Lesson Posted on 24/02/2018 Learn SAP HANA
SAP HANA Architecture, LandScape, Sizing: Complete Tutorial
Harsh Sharma
I am working from past 15 years in different Sap Domains and having vast experience in lot of SAP technologies...
SAP HANA Database is Main-Memory centric data management platform. SAP HANA Database runs on SUSE Linux Enterprises Server and builds on C++ Language.
SAP HANA Database can be distributed to multiple machines.
SAP HANA Advantages are as mentioned below -
SAP HANA Database consists of a set of in-memory processing engines. Calculation engine is main in-memory Processing engines in SAP HANA. It works with other processing engine like Relational database Engine(Row and Column engine), OLAP Engine, etc.
Relational database table resides in column or row store.
There are two storage types for SAP HANA table.
Text data and Graph data resides in Text Engine and Graph Engine respectively. There are some more engines in SAP HANA Database. The data is allowed to store in these engines as long as enough space is available.
In this tutorial, you will learn:
SAP HANA Architecture
SAP HANA Landscape
SAP HANA Sizing
SAP HANA Architecture:
Data is compressed by different compression techniques (e.g. dictionary encoding, run length encoding, sparse encoding, cluster encoding, indirect encoding) in SAP HANA Column store.
When main memory limit is reached in SAP HANA, the whole database objects (table, view,etc.) that are not used will be unloaded from the main memory and saved into the disk.
These objects names are defined by application semantic and reloaded into main memory from the disk when required again. Under normal circumstances SAP HANA database manages unloading and loading of data automatically.
However, the user can load and unload data from individual table manually by selecting a table in SAP HANA studio in respective Schema- by right-clicking and selecting the option "Unload/Load".
SAP HANA Server consists of:
SAP HANA Database Main server are index server. Detail of each server is as below:
Below is the architecture of Index Server.
SAP HANA Index Server overview:
This server is used in Text Analysis and extracts data from a text when the search function is used.
This Server contains all information about the system landscape. In distributed server, the name server contains information about each running component and location of data on the server. This server contains information about the server on which data exists.
Statistic server is responsible for collecting the data related to status, resource allocation / consumption and performance of SAP HANA system.
XS Server contains XS Engine. It allows external application and developers to use SAP HANA database via the XS Engine client. The external client application can use HTTP to transmit data via XS engine for HTTP server.
SAP HANA Landscape:
"HANA" mean High Performance Analytic Appliance is a combination of hardware and software platform.
Below are SAP HANA Innovation in the field of Hardware/Software.
There are two types of Relational data stores in SAP HANA: Row Store and Column Store.
Row Store:
Column Store:
Read and write operation performance optimized with below two data structure.
Main Storage:
Main Storage contains the main part of data. In Main Storage, suitable data compression Method (Dictionary Encoding, Cluster Encoding, Sparse Encoding, Run Length encoding, etc.) is applied to compress data with the purpose to save memory and speed up searches.
We can manually load data in Main memory by option "Load into Memory" and Unload data from Main memory by "Unload from Memory" option as shown below.
Delta Storage:
Delta storage is used for a write operation and uses basic compression. All uncommitted modification in Column table data stored in delta storage.
When we want to move these changes into Main Storage, then use "delta merge operation" from SAP HANA studio as below:
Process of moving Data from Delta to Main Storage during delta merge:
There is a buffer store (L1-Delta) which is row storage. So in SAP HANA, column table acts like row store due to L1-delta:
So, Column storage is both Write-optimized and Read-optimized due to L1-Delta and main storage respectively. L1-Delta contains all uncommitted data. Committed data moves to Main Store through L2-Delta. From main store data goes to the persistence layer (The arrow indicating here is a physical operator that send SQL Statement in Column Store). After Processing SQL Statement in Column store, data goes to the persistence layer.
E.g. below is row-based table:
Table data is stored on disk in linear format, so below is format how data is stored on disk for row and column table -
In SAP HANA memory, this table is stored in Row Store on disk as format:
Memory address
And in Column, data is stored on disk as:
Memory address
Data is stored column-wise in the linear format on the disk. Data can be compressed by compress technique.
So, Column store has an advantage of memory saving.
SAP HANA Sizing:
Sizing is a term which is used to determine hardware requirement for SAP HANA system, such as RAM, Hard Disk and CPU, etc.
The main important sizing component is the Memory, and the second important sizing component is CPU. The third main component is a disk, but sizing is completely dependent on Memory and CPU.
In SAP HANA implementation, one of the critical tasks is to determine the right size of a server according to business requirement.
SAP HANA DB differ in sizing with normal DBMS in terms of:
The Application server CPU and application server memory remain unchanged.
For sizing calculation SAP has provided various guidelines and method to calculate correct size.
We can use below method:
By using Quicksizer tool, Requirement will be displayed in below format-
Answered on 07/03/2018 Learn SAP HANA
Pragim Technologies
Learn SAP HANA Training from the Best Tutors
Answered on 06/10/2017 Learn SAP HANA
Lalitha p.
Sap Fico Trainer
UrbanPro.com helps you to connect with the best SAP HANA Training in India. Post Your Requirement today and get connected.
Ask a Question
The best tutors for SAP HANA Training Classes are on UrbanPro
The best Tutors for SAP HANA Training Classes are on UrbanPro