SAP HANA Interview Questions

   

Most important Interview Questions

What is a Five-minute rule in Sap HANA?
How does data get stored in sap hana?
What is Stall?
What is SAP HANA?
What are the advantages of SAP HANA?
How to Start/Stop HANA Database Services ?
.Is it possible to join tables of row-based with column-based tables?
What are the advantages of Columnar tables?
What are the types of data backup in HANA?

SAP HANA Questions And Answers
 A single source system can be connected to several target schemas in SLT, what is the maximum limit?
Answer:
Currently up to 1:4 is supported in SLT replication.

 What is the purpose of DB trigger in SLT?
Answer:
DB trigger considers only relevant table changes for DB recording and are recorded in logging tables; the replicated changes are later deleted from the logging tables. This approach will not have any performance impact in the source system.

 What is the purpose of Controller Module in SLT?
Answer:
Controller Module ensures mapping between HANA target database structure and source system structure. It also allows conversion of data values and scheduling options while replicating the source data.

 Which tool supports ETL based replication into HANA?
Answer:
Business Objects Data services (BODS) supports ETL based replication into SAP HANA.

 What are the advantages of using BODS to load data into SAP HANA?
Answer:
The advantages of using BODS to load data into SAP HANA are:
a) Loads unstructured data into SAP HANA
b) Sorts and filters relevant business data
c) Reads BI Content extractors or SAP function modules thereby reusing the logic
d) Merges multiple data streams
e) Transforms the data before loading using advanced and complex transformations
f) Supports connectivity to a wide range of data sources

 What are the limitations while using BODS for data replication?
Answer:
The limitations while using BODS for data replication are:
a) Since BODS uses batch mode to load the data, real-time capabilities will be limited; only near real-time can be achieved
b) ETL based replication takes longer time to implement

 Which SAP ECC table stores the extractors’ information used in Data Services?
Answer:
ROOSATTR table contains information on the SAP extractors used in Data Services.
 Which file types are supported in flat file upload to SAP HANA database?
Answer:
xls, .xlsx and .csv are the supported file types that can be uploaded into SAP HANA.

SAP HANA Overview

What's SAP Hana?

SAP High-performance Analytic Machine is surely an In-Memory Databases by SAP to shop data along with assess huge amounts connected with non-aggregated transactional data in real time.

In essence SAP HANA is usually a database. It address numerous issues that are becoming confronted inside the regular listings through their In-Memory principle.

Together with SAP HANA on the web coaching you will get the energy to formulate In-Memory apps in which assess huge amounts connected with data within real-time.

You want the info analysis no more hold out so very long pertaining to results?

You may rely on SAP HANA coaching along with trail developments along with situations in real time. With the combination of high-performance in-memory software package along with innovative components by SAP companions you can check speedily considerable amounts connected with data by disparate sources. Examination results can be acquired faster than in the past.

SAP relies on a versatile system that can effortlessly conform to improvements so as to bring in brand-new engineering along with apps in real time. It studies considerable amounts connected with data having industry-leading business intelligence along with in-memory computing along with attain advantages.

SAP HANA Online Training provides each OLTP along with OLAP functionality

OLTP: Easy queries such as PLACE, BRING UP TO DATE, DELETE and so on. It dividends several files which isn't going to need very much digesting time.

OLAP: Complex aggregations – sometimes combination of various OLTP queries. It dividends huge number connected with files dependant on the info and yes it needs additional digesting time Ex-mate: Information warehouses.