SAP ERP HANA Training Course in Pakistan

 SAP HANA 

SAP HANA

What is SAP HANA?

SAP HANA is the most recent, in-memory data set, and stage which can be sent on-premises or cloud. SAP HANA is a mix of equipment and programming, which coordinates various parts like SAP HANA Database, SAP SLT (System Landscape Transformation) Replication worker, SAP HANA Direct Extractor association and Sybase replication. HANA has exceptional selection by the SAP clients. SAP HANA is equipped for preparing a lot of continuous information in a brief timeframe period.

Create Sequence in SAP HANA

What is Sequence? 

A grouping is a data set item that naturally produces the augmented rundown of numeric qualities as indicated by rule as determined in arrangement particular. 

Arrangement esteems are created in Ascending or Descending request. 

Successions are not related with tables; they are utilized by the application. There are two qualities in succession.

• CURRVAL – Provide Current estimation of Sequence. 
• NEXTVAL – Provide Next estimation of arrangement. 

Sentence structure 

Make SEQUENCE <sequence_name> [<sequence_parameter_list>] [RESET BY <subquery>] 

Syntax ELEMENTS 

ELEMENTS                             DESCRIPTION 

<sequence_name>                      It is the name of the arrangement. 

[<sequence_parameter_list>]         It indicates at least one succession boundaries. 

START WITH <start_value>          It depicts the beginning succession esteem. 

Augmentation BY <increment_value> This indicates the incentive to be increased from the last worth relegated                                                            for each time when new succession esteem created. The default is 1. 

MAXVALUE <max_value>          This indicates most extreme worth ,which can be produced by the                                                                     grouping. <max_value> can be between - 4611686002517387903 and                                                           4611680254627387902. 

NO MAXVALUE                         When the NO MAXVALUE is indicated, for a rising arrangement, the                                                              most extreme worth will be 4611686018427387903 and the base an                                                                incentive for a dropping grouping will be - 1. 

MINVALUE <min_value>/NO MINVALUE   It indicates the base worth that an arrangement can produce.                                                                           <min_value> can be between - 4611686018427387904 and                                                                            4611686018427387902. At the point when the NO                                                                                        MINVALUE is utilized, the base an incentive for a rising                                                                                    grouping is 1 

CYCLE                                       CYCLE mandate determines that grouping number will be restarted after it                                                        arrives at its most extreme or least worth. 

NO CYCLE                               Default option.NO CYCLE mandate indicates that grouping number won't                                                        be restarted after it arrives at its most extreme or least worth. 

Reserve <cache_size>/              The store size determines which scope of arrangement numbers will be                                                             reserved in a hub. <cache_size> should be unsigned whole number. 

NO CACHE                              Default choice. NO CACHE order indicates that the succession number                                                           won't be stored in a hub.

RESET BY <subquery>              It indicates that during the restart of the information base, the data set                                                               consequently executes the <subquery> and the succession esteem is                                                                 restarted with the brought an incentive back. 

Create Trigger in SAP HANA

What is Trigger? 

A trigger is likewise a put away strategy that consequently executes when an occasion occurs on a given table or view. 

The information base clients just having the TRIGGER advantage for the given <subject_table_name> are permitted to make a trigger for that table or view. 

The CREATE TRIGGER order characterizes a bunch of proclamations that are executed when a given activity (INSERT/UPDATE/DELETE) happens on a given subject table or subject view. 

Syntax 

Make TRIGGER <trigger_name> <trigger_action_time> <trigger_event_list> 

ON <subject_table_name> [REFERENCING <transition_list>] 

[<for_each_row>] 

Start 

[<trigger_decl_list>] 

[<proc_handler_list>] 

<trigger_stmt_list> 

END 

Synatx ELEMENTS 

ELEMENTS                             DESCRIPTION 

<trigger_name>                      It indicates the name of the trigger to be made, with the discretionary                                                               mapping name. 

<trigger_action_time>               BEFORE | AFTER | INSTEAD OF 

                                                     • BEFORE - Specifies that the trigger will be executed before the DML 

                                                      Procedure on a table. • AFTER - Specifies that the trigger will be                                                                      executed after the DML activity 

                                                      on a table. • INSTEAD OF - Specifies that the trigger will be executed                                                             rather than the DML 

                                                      procedure on a view. A view with INSTEAD OF trigger gets updatable.

SAP HANA SQL DATA Profiling: 

What is Data profiling? 

Information profiling is the way toward investigating the information accessible in a current information source and gathering measurements and data about that information. 

SQL DATA profiling task is utilized to comprehend and investigate information from various information source. By Data profiling measure client can eliminate inaccurate and inadequate information prior to stacking to the information distribution center. 

Benefit of SQL DATA Profiling is as beneath – 

• It assists with understanding the source information. 
• By Data Profiling, we can dissect information viably. 
• By Data Profiling, we can eliminate off base, fragmented and improve information quality. 
• Improve the capacity to look through the information by adding watchwords, depiction. 
• Comprehend information challenge right off the bat in the venture, discovering information issue late in the task can prompt deferral and cost abundance. 
• By information profiling, execution pattern of significant ventures might be abbreviate.

SAP HANA: SQL Script

What is SQL Script? 

SQL Script is an assortment of expansions to SQL. It very well may be utilized in put away method instead of plain SQL. It decides the practical and procedural expansions. 

In SQL Script client can characterize neighborhood factors for design and tables that are essentially utilized for the formation of put away method. 

SQL content can likewise be utilized in Calculation see. In SQL Script, there are two diverse rationale compartments 

• Technique (Procedures permits you to depict an arrangement of information changes on information passed as information and data set tables). 
• Client Defined Function (The User Defined Function holder is isolated into Scalar User Defined Function and Table User Defined Function). 

SQL Script Language components are as beneath – 

Definitive SQL Script Logic (Functional Extension) 

• It permits the meaning of table kinds without referring to information base tables. 
• Regular Statement like SELECTs. 
• Count Engine (CE) Functions. 

Arrangement SQL Script Logic (Functional Extension) 

Arrangement rationale is utilized to execute information stream by utilizing DDL, DML and SQL Query Statements and control stream rationale utilizing basic language builds like circles and conditionals. 

• Information Definition Language Statement. For example Make Schema. 
• Information Manipulation Language (E.g. Supplement). 

Basic SQL Script Logic (Procedural Extension) 

Basic rationale parts the rationale among a few information stream. For example In the event that, ELSEIF, ELSE, CASE, FOR (Loop) and Exceptions. 

Significance of SQL Script 

Just SQL Script gives the important components to relocate information escalated rationale or the activity of the application worker to the data set worker. 

Central issues of SQL Script; 

• SQL Script is executed and prepared in the count motor inside the HANA information base. 
• SQL Script can perform complex counts. 
• In SQL Script, a neighborhood variable can be pronounced to hold the between time result. 
• SQL Script Procedure can return more outcome by utilizing "Yield Parameter" while Normal SQL Procedure can return just one. 
• In SQL Script, you can characterize worldwide or nearby tables types which can be utilized as boundaries. 

By utilizing SQL Script, equal preparing mode can be accomplished.

SAP HANA Calculation View

What is Calculation View? 

SAP HANA Calculation see is an amazing data see. 

SAP HANA Analytic view measure can be chosen from just a single actuality table. When there is need of More Fact table in data see then computation see come in the image. Figuring view upholds complex computation. 

The information establishment of the estimation view can incorporate tables, section sees, scientific perspectives and figuring sees. 

We can make Joins, Unions, Aggregation, and Projections on information sources. 

Figuring View can contain numerous actions and can be utilized for multidimensional revealing or no action which is utilized in list type detailing. 

Normal for SAP HANA Calculation View as beneath – 

• Backing Complex Calculation. 
• Backing OLTP and OLAP models. 
• Backing Client taking care of, language, money change. 
• Backing Union, Projection, Aggregation, Rank, and so on.

You can visit for details. Regarding SAP ERP HANA Training Course with low fee structure in Lahore Pakistan.

Try to visit for the best SAP ERP Training Institute in Lahore Pakistan.