Sap Hana Sql Script Interview Questions & Answers

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

    Answer :

    Each job occupies 1 BGD work processes in SLT replication server. For each configuration, the parameter Data Transfer Jobs restricts the maximum number of data load job for each mass transfer ID (MT_ID).

    A mass transfer ID requires at least 4 background jobs to be available:

    One master job

    One master controller job

    At least one data load job

    One additional job either for migration/access plan calculation/to change configuration settings in “Configuration and Monitoring Dashboard”.

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

    Answer :

    Yes it is possible to specify type of data load and replication in SAP HANA, it can be either in real time, or scheduled by time or by interval.

  3. Data Warehousing Interview Questions

  4. Question 3. What Additional Limitations Does Sybase Replication Server Present?

    Answer :

    SRS has additional restrictions which are worth to be understood. It only replicates Unicode data and does not support IBM DB2 compress tables.

  5. Question 4. Hana Support In Real-time What Types Of Source Database?

    Answer :

    If Sybase Replication Server (SRS) for near real-time data is used then the licensing still (SAP have license deals pending) needs to checked. If DB2 is run then its fine but with Oracle and Microsoft SQL Server there are some license challenges. So if license is bought through SAP, because you may have a limited license that does not allow extraction

  6. Data Warehousing Tutorial

  7. Question 5. Hana Uses Which Storage Subsystem?

    Answer :

    A shared network attached and varies from vendor to vendor and is called the storage. Here both regular magnetic disks and SSD storage can be used for the backup of the database (HANA runs in memory remember, so disk storage is just for backup, and later, for data ageing). If the operator require 2x storage that you have RAM, which is 2x the database size – i.e. storage size = 4x database size. Anyways in most cases there is additional ultra-high speed SSD storage for log files.

  8. SQL Database Interview Questions

  9. Question 6. How Big Does Hana Scale ?

    Answer :

    Theory wise at least very well. Most mid-size workloads – 2TB of in-memory storage is equivalent to 5-20TB of Oracle storage can be run by the biggest single server HANA hardware. HANA works in a way that means it is possible to chain multiple systems together which means that scalability has thus-far been determined by the size of customers’ wallets. Whilst SAP talk up “Big Data” quite a lot, HANA currently only scales to the small-end of Big Data referring to the kind of huge datasets that FaceBook or Google have to store – not Terabytes, but rather Petabytes.

  10. Question 7. What Is A Private Attribute In Sap Hana?

    Answer :

    Private attributes are the attributes used inside a modeling views and cannot be used outside the view.These are used in a modeling view to customize the behavior of an attribute for only that view.

  11. SQL Database Tutorial
    SAP BW Interview Questions

  12. Question 8. What Are Transformation Rules?

    Answer :

    Transformation rule is a rule specified in the Advanced Replication settings transaction for source tables such a way that the data is transformed during the replication process. 

    For example: one can specify rule to Convert fields, Fill empty fields and Skip records

  13. Question 9. Define Latency In Sap Hana ?

    Answer :

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

  14. SAP HANA Interview Questions

  15. Question 10. What Is Advanced Replication Settings?

    Answer :

    replication settings like modifying target table structures, specifying performance optimization settings that defines transformation rules.

  16. SAP BW Tutorial

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

    Answer :

    DMIS add-on is installed in SLT replication server for SAP source systems. The role IUUC_REPL_CONTENT is assigned to the user for RFC connection but not DDIC. DMIS add-on is notrequired and grants a database user sufficient authorization for data replication for a non-SAP source system.

  18. SQL Interview Questions

  19. Question 12. Define Configuration In Slt?

    Answer :

    The information required to create the connection between the source system, SLT system, and the SAP HANA system is specified within the SLT system as a Configuration. A new configuration in Configuration & Monitoring Dashboard (transaction LTR) can hence be defined.

  20. Data Warehousing Interview Questions

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

    Answer :

    Yes. It can be loaded and replicated for up to 4 targets.

  22. SAP HANA Tutorial

  23. Question 14. What Is Slt(sap Landscape Transformation) In Sap Hana?

    Answer :

    The full form of SLT is SAP Landscape Transformation which is nothing but a trigger based replication. It is the replication technology to pass the data from the source system to the target system. Here the source can be either SAP or non-SAP whereas the Target system is SAP HANA system which contains HANA database.

  24. Question 15. What Is Sap Hana Appliance 1.0?

    Answer :

    SAP HANA 1.0 is an analytics appliance which consists of certified hardware, and In Memory DataBase (IMDB), an Analytics Engine and some tooling for getting data in and out of HANA. The logic and structures are built by the user and a tool is used.

    Example: SAP BusinessObjects, to visualize or analyze data.

  25. SAP Testing Interview Questions

  26. Question 16. What Is Sqlscript In Sap Hana ?

    Answer :

    It is a set of SQL extensions for SAP HANA database which allow developers to push data intensive logic into the database.

  27. SAP Testing Tutorial

  28. Question 17. How To Set-up Tracing?

    Answer :

    From the Administration perspective, navigate to tab “Trace Configuration” . In order to change settings, you need to have system privileges “TRACE ADMIN” and “INFILE ADMIN”. 

  29. SAP BW on HANA Interview Questions

  30. Question 18. What Is The Difference Between Break And Continue?

    Answer :

    Break means loop should stop processing, CONTINUE means loop should stop processing the current iteration and immediately start processing the next iteration.

  31. SQL Database Interview Questions

  32. Question 19. What Operator Is Used To Debug Sqlscript Procedures?

    Answer :

    TRACE operator. It traces the tabular data passed as its argument into a local temporary table and return its input unmodified. The names of the temporary tables can be retrieved from the SYS.SQL SCRIPT TRACE view. 

    Example: out = TRACE (:input);

  33. SAP BW on HANA Tutorial

  34. Question 20. When Should Be Sqlscript Used In Sap Hana ?

    Answer :

     It should be used in cases where other modeling constructs of HANA such as Attribute views or Analytic views are not sufficient.

  35. SAP S/4HANA Interview Questions

  36. Question 21. Explain How Sqlscript Procedure Is Processed In Hana Database?

    Answer :

    When a user creates a new procedure, the HANA database query compiler first:

    • Parse the statements
    • Check the statement semantic correctness
    • Optimize the code for Declarative and Imperative logic
    • Code generation creates Calculation models for Declarative logic and L nodes for Imperative logic
    • Compiled procedure creates Content in the database Catalog and in Repository
  37. Question 22. What Happens When You Compile The Procedure In Sap Hana ?

    Answer :

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