These are the questions asked in the 'SAP HANA SQL & SQL Scripting' course and we are keeping here for your quick reference. Treat them like "SAP HANA Interview Questions". ***Scroll down to see 'SLT for HANA' course questions***
Will it be possible to install SAP HANA Express Edition with 4GB RAM on my laptop?
Unfortunately it's not possible. You need minimum 8GB of RAM to start with HXE Server only version.
Can I write report as we write in ABAP using SAP HANA SQL script?
SQL will not have those features. We should go with reporting tools like Business Objects, Tabeleau, etc to get formatted reports.
What is the recommended way of moving the runtime objects (i.e tables, functions) in your schema to QA/PRD ?
You should not transport any run-time tables/objects. Always go with design time objects to transport across landscape. Transport methodology changes from client to client based on their landscape and policies. It's hard to say this is recommended way :)
In the training it's covered how to import data from a file into table. How can I do the opposite, that is, export data from HANA DB to a text file?
To export data from a table, right click on the table in HANA studio and choose 'Export'. You will have two format options
to export data (CSV & Binary). Also export is not just limited to tables, you can also export full schema.
What is the purpose of import parameter and when to use import/Export option?
Import parameter is like a variable where you can store some value and use that parameter in your line of code or include program. One simple example is if you are writing a line of code and you logic exceeded the number of characters SAP allowing, then you can leverage import parameter to shorten the code.
Export parameters are simply output/result field of the code. which is actually pass to the target table.
Can you please Explain me the difference between the Development Objects & Design Time Objects?
Development object gets create when you execute the SQL Command directly in the SQL console. Not flexible to change and transport.
if you create a object from repositories, then that's a Design time object. When you activate the design time object it creates a runtime object. you can change design time object. when you change and activate design time object, relevant runtime objects gets update.
What is called an "EXIT HANDLER" and "RESIGNAL" in Exception Handling?
EXIT HANDLERs are used to detect unwanted or unexpected scenarios and handle them without exiting from the script execution. We can also provide custom message.
In our example, negative discount is unwanted and we handled with exit handler. Signal is to call the defined EXIT HANDLER.
Error insufficient privilege while building transaction application even after providing GRANT INSERT ON SCHEMA T4H TO _SYS_REPO WITH GRANT OPTION?
Run following 2 statements
GRANT SELECT ON SCHEMA T4H TO _SYS_REPO WITH GRANT OPTION;
GRANT INSERT ON SCHEMA T4H TO _SYS_REPO WITH GRANT OPTION;
I don't see the keyword SCALAR in the entire session. We are just using CREATE FUNCTION. How we are saying its scalar function?
From run time object prospective, you will not differentiate scalar and table function with symbols/icons. You can identify only by seeing the code and if it's having any table return type then it's a table function else it's a scalar function. But from design time prospective you can easily identify by seeing icon it self. Further lectures will give more clarity.
Can you give better understanding on ' :cat = ' and 'x := '
i.e " : " position before " : cat " and after " x : " how this change of colon position is working?
If you want to access the value of the variable, then use :var in your code. If you want to assign a value to the variable, then use var: in your code.
from HANA 2.0 onwards both var:= 10 and var = 10 are same for assigning values.
How UPSERT statement understand what is the key column to compare the values, is this the primary key always? or whatever we mentioned in the where clause?
use either WHERE condition or PRIMARY KEY option.
If WHERE condition is true then it works like a update, if not insert.
Use the keyword "WITH PRIMARY KEY" to update the table using the primary key value in the VALUES clause
UPSERT Table_1 VALUES (1, 'A') WITH PRIMARY KEY;
These are the questions asked in the 'SLT for HANA' course and we are keeping here for your quick reference.
SAP EIM is nothing but SAP BODS or SAP data services is it true... ?
Smart Data Integration (SDI) and Smart Data Quality (SDQ) together comes under SAP HANA Enterprise Information Management (EIM).
If you are familiar with SAP Data Services or BODS then the design concepts for SDI or SDQ are similar but not 100% same.
What are the authorizations required to see data provisioning tab and where can we check those authorizations?
You need standard SAP delivered role 'SAP_IUUC_REPL_ADMIN'. Check with your security team if they are following any custom build roles.
Following are useful T-Codes to check authorizations in any SAP Netweaver systems (including SLT)
SU01/SU01D: To display/assign roles to a user.
SU10: Add/remove multiple roles to multiple users
PFCG: Assign one role to multiple users
If the source and target system is ABAP system then in both source and target system connection type will be RFC,right?