SAP HANA is a in-memory database developed by German software giant SAP in 201. it is designed as an in-memory to facilitate high performance. The system is designed in such a way that it can perform speedy reading operations on a massive volume of data without accessing the disk.
SAP HANA has a column-based storage architecture which is different from other architectures. Advantage of coulmn-based-architecture is that it needs lesser operations to access the needed data from the database storage. SAP HANA can be made available in the cloud or on-premise.
How can the database be copied from the backups?
For this a new target database is to be created first. Now you have to copy those backups needed to the target folder. Finally do recover the target database to the past-time-point we need.
When is backup and recovery needed?
Backup and recovery are needed in two scenarios. one, when a disk failure occurs. Two, when data volumes get damaged.
What are things needed for a successful backup and recovery?
The new target database to which we take backup data and the source database from which we do the backup should match in their number of hosts and the physical layout.
What types of back ups are available in SAP HANA?
In SAP HANA, Configuration backup, data backup and log backup are available.
List out some best practices that needs to be followed in HANA when connecting tables?
As a general rule, use always the left outer join with the Cardinality N:1 from fact table to dimension.
Decrease the Cardinality from center of star schema to the outside.
Before changing the Cardinality it is advised to drag join lines from fact to the outer tables.
To extract huge volume of data from SAP ECC, which dataflow can be used?
ABAP dataflows
The transaction adopted to release the extractors specified by customers is __________
RODPS_OS_EXPOSE
In SLT replication, the two types of Transformation rules available are:
Event-based and Parameter-based rules are the two types.
Differentiate between STOP and SUSPEND Replication in SAP HANA?
In the suspend mode, DB recording will be active while replication is stopped. But in the case of Stop mode, DB trigger will be deleted in addition to the stopping of delta recording by the SLT server.
The two most relevant control tables in SLT replication are:
RS_STATUS and RS_ORDER
Using BODS for data replication has limitations. explain?
Real-time data cannot be achieved instead we can only get near real-time data as it employs batch mode for data replication.
It also takes more time for ET based replication.
Mention the procedure to upload a flat file?
Create the source file to upload after that go to Import->SAP HANA Content->Data from local file. Choose the source file that needs to be uploaded. Now a target table is to be selected, to import the data. This can be a new one or an existing one.
Manage table definition after that perform the mapping of source to target columns. Lastly, Choose the option Finish.
The file formats that are supported for Flat file upload to SAP HANA database are:
.xlsx, .csv and .xls are the supported file formats
Join the top academy for learning SAP HANA course in the country
SAP HANA has a column-based storage architecture which is different from other architectures. Advantage of coulmn-based-architecture is that it needs lesser operations to access the needed data from the database storage. SAP HANA can be made available in the cloud or on-premise.
SAP HANA Interview Asked Questions
Here we discuss some questions that are most likely to ask in an SAP HANA interview so that you could prepare and answer such questions easily.How can the database be copied from the backups?
For this a new target database is to be created first. Now you have to copy those backups needed to the target folder. Finally do recover the target database to the past-time-point we need.
When is backup and recovery needed?
Backup and recovery are needed in two scenarios. one, when a disk failure occurs. Two, when data volumes get damaged.
What are things needed for a successful backup and recovery?
The new target database to which we take backup data and the source database from which we do the backup should match in their number of hosts and the physical layout.
What types of back ups are available in SAP HANA?
In SAP HANA, Configuration backup, data backup and log backup are available.
List out some best practices that needs to be followed in HANA when connecting tables?
As a general rule, use always the left outer join with the Cardinality N:1 from fact table to dimension.
Decrease the Cardinality from center of star schema to the outside.
Before changing the Cardinality it is advised to drag join lines from fact to the outer tables.
To extract huge volume of data from SAP ECC, which dataflow can be used?
ABAP dataflows
The transaction adopted to release the extractors specified by customers is __________
RODPS_OS_EXPOSE
In SLT replication, the two types of Transformation rules available are:
Event-based and Parameter-based rules are the two types.
Differentiate between STOP and SUSPEND Replication in SAP HANA?
In the suspend mode, DB recording will be active while replication is stopped. But in the case of Stop mode, DB trigger will be deleted in addition to the stopping of delta recording by the SLT server.
The two most relevant control tables in SLT replication are:
RS_STATUS and RS_ORDER
Using BODS for data replication has limitations. explain?
Real-time data cannot be achieved instead we can only get near real-time data as it employs batch mode for data replication.
It also takes more time for ET based replication.
Mention the procedure to upload a flat file?
Create the source file to upload after that go to Import->SAP HANA Content->Data from local file. Choose the source file that needs to be uploaded. Now a target table is to be selected, to import the data. This can be a new one or an existing one.
Manage table definition after that perform the mapping of source to target columns. Lastly, Choose the option Finish.
The file formats that are supported for Flat file upload to SAP HANA database are:
.xlsx, .csv and .xls are the supported file formats
Join the top academy for learning SAP HANA course in the country
