Interview Questions.

Q1. What Is Sqlscript In Sap Hana ?

It is a hard and fast of SQL extensions for SAP HANA database which allow builders to push information extensive good judgment into the database.

Q2. What Operator Is Used To Debug Sqlscript Procedures?

TRACE operator. It strains the tabular statistics handed as its argument into a local transient table and return its enter unmodified. The names of the transient tables may be retrieved from the SYS.SQL SCRIPT TRACE view. 

Example: out = TRACE (:input);

Q3. What Is The Difference Between Break And Continue?

Break approach loop must forestall processing, CONTINUE approach loop should stop processing the cutting-edge generation and right now start processing the subsequent generation.

Q4. Is It Possible To Specify The Type Of Data Load And Replication In Sap Hana ?

Yes it's miles feasible to specify kind of statistics load and replication in SAP HANA, it can be both in actual time, or scheduled via time or by means of interval.

Q5. What Is A Private Attribute In Sap Hana?

Private attributes are the attributes used inner a modeling perspectives and cannot be used outside the view.These are utilized in a modeling view to customize the behavior of an characteristic for most effective that view.

Q6. What Is Sap Hana Appliance 1.Zero?

SAP HANA 1.0 is an analytics equipment which consists of licensed hardware, and In Memory DataBase (IMDB), an Analytics Engine and a few tooling for buying information inside and outside of HANA. The logic and systems are constructed by way of the consumer and a tool is used.

Example: SAP BusinessObjects, to visualize or examine statistics.

Q7. Hana Uses Which Storage Subsystem?

A shared community attached and varies from dealer to dealer and is called the storage. Here both regular magnetic disks and SSD garage may be used for the backup of the database (HANA runs in reminiscence bear in mind, so disk storage is just for backup, and later, for information growing old). If the operator require 2x garage that you have RAM, which is 2x the database length - i.E. Storage length = 4x database length. Anyways in maximum cases there may be extra ultra-high pace SSD garage for log files.

Q8. Define Latency In Sap Hana ?

Latency is the period of time to copy records (a desk entry) from the supply machine to the target device.

Q9. Explain How Sqlscript Procedure Is Processed In Hana Database?

When a consumer creates a new manner, the HANA database query compiler first:

Parse the statements

Check the statement semantic correctness

Optimize the code for Declarative and Imperative good judgment

Code technology creates Calculation models for Declarative common sense and L nodes for Imperative common sense

Compiled manner creates Content within the database Catalog and in Repository

Q10. Is There Any Need Of Pre-requisite Before Creating The Configuration And Replication?

DMIS upload-on is set up in SLT replication server for SAP supply systems. The position IUUC_REPL_CONTENT is assigned to the consumer for RFC connection however no longer DDIC. DMIS add-on is notrequired and offers a database user sufficient authorization for statistics replication for a non-SAP supply gadget.

Q11. Define Configuration In Slt?

The records required to create the connection between the source gadget, SLT machine, and the SAP HANA system is special inside the SLT gadget as a Configuration. A new configuration in Configuration & Monitoring Dashboard (transaction LTR) can therefore be described.

Q12. How To Set-up Tracing?

From the Administration attitude, navigate to tab “Trace Configuration” . In order to exchange settings, you want to have device privileges “TRACE ADMIN” and “INFILE ADMIN”. 

Q13. What Are Transformation Rules?

Transformation rule is a rule special within the Advanced Replication settings transaction for supply tables this kind of way that the statistics is converted in the course of the replication procedure. 

For example: possible specify rule to Convert fields, Fill empty fields and Skip data

Q14. What Is Slt(sap Landscape Transformation) In Sap Hana?

The complete shape of SLT is SAP Landscape Transformation that's not anything but a trigger based totally replication. It is the replication generation to pass the information from the source system to the target system. Here the source may be both SAP or non-SAP whereas the Target gadget is SAP HANA gadget which incorporates HANA database.

Q15. What Additional Limitations Does Sybase Replication Server Present?

SRS has additional restrictions which might be well worth to be understood. It simplest replicates Unicode facts and does not assist IBM DB2 compress tables.

Q16. Can We Load And Replicate Data From One Source System To Multiple Target Database Schemas Of Hana System?

Yes. It may be loaded and replicated for up to 4 goals.

Q17. What Happens When You Compile The Procedure In Sap Hana ?

During compilation, the call to the procedure is rewritten for processing by using the calculation engine.

Q18. What Is The Relation Between The Number Of Data Transfer Jobs In The Configuration Settings And The Available Bgd Work Processes?

Each activity occupies 1 BGD work techniques in SLT replication server. For every configuration, the parameter Data Transfer Jobs restricts the most quantity of records load process for every mass transfer ID (MT_ID).

A mass transfer ID calls for as a minimum four background jobs to be to be had:

One grasp task

One master controller process

At least one data load task

One extra process either for migration/get admission to plan calculation/to trade configuration settings in "Configuration and Monitoring Dashboard".

Q19. Hana Support In Real-time What Types Of Source Database?

If Sybase Replication Server (SRS) for close to actual-time data is used then the licensing still (SAP have license deals pending) needs to checked. If DB2 is administered then its first-rate however with Oracle and Microsoft SQL Server there are some license challenges. So if license is sold thru SAP, because you can have a constrained license that doesn't permit extraction

Q20. How Big Does Hana Scale ?

Theory smart at the least very well. Most mid-size workloads - 2TB of in-memory storage is equal to 5-20TB of Oracle garage may be run by using the most important unmarried server HANA hardware. HANA works in a way meaning it's miles feasible to chain multiple structures together which means that scalability has hence-far been decided by using the dimensions of customers' wallets. Whilst SAP communicate up "Big Data" quite plenty, HANA currently handiest scales to the small-cease of Big Data relating to the type of massive datasets that FaceBook or Google ought to store - not Terabytes, however as a substitute Petabytes.

Q21. What Is Advanced Replication Settings?

Replication settings like modifying goal table systems, specifying overall performance optimization settings that defines transformation regulations.

Q22. When Should Be Sqlscript Used In Sap Hana ?

 It have to be utilized in cases where different modeling constructs of HANA such as Attribute views or Analytic perspectives aren't sufficient.