SAP-HANA
Top 15 SAP HANA Interview Questions & Answers
Download PDF 1) Mention what is SAP HANA? SAP HANA stands for High Performance Analytical...
What is SQL Script?
SQL Script is a collection of extensions to SQL. It can be used in stored procedure in place of plain SQL. It determines the functional and procedural extensions.
In SQL Script user can define local variables for structure and tables that are primarily used for the creation of stored procedure.
SQL script can also be used in Calculation view. In SQL Script, there are two different logic containers-
SQL Script Language elements are as below –
Declarative SQL Script Logic (Functional Extension)
Orchestration SQL Script Logic (Functional Extension)
Orchestration logic is used to implement data flow by using DDL, DML and SQL Query Statements and control flow logic using imperative language constructs such as loops and conditionals.
Imperative SQL Script Logic (Procedural Extension)
Imperative logic splits the logic among several data flow. E.g. IF, ELSEIF, ELSE, CASE, FOR (Loop) and Exceptions.
Importance of SQL Script
Only SQL Script provides the necessary elements to migrate data-intensive logic or the operation of the application server to the database server.
Key points of SQL Script;
By using SQL Script, parallel processing mode can be achieved.
Download PDF 1) Mention what is SAP HANA? SAP HANA stands for High Performance Analytical...
What are Attributes? Attribute view acts like a dimension. It join multiple tables and act as...
In this tutorial, we will learn, 1) SAP HANA Data Type 2) SAP HANA Identifiers SAP HANA Data Type...
What is SAP HANA Analytic view? SAP HANA Analytic view is based on STAR Schema Modelling, and it...
What is Data profiling? Data profiling is the process of analyzing the data available in an...
What is Calculation View? SAP HANA Calculation view is a powerful information view. SAP HANA...