SAP HANA Training by
Learn IT Training teaches you the essentials of HANA and concepts which are
related to real time industry practices by training you with practical methods
and live project case studies. Here you learn in detail about SAP HANA
architecture in training session you will learn some concepts related to
advancement of HANA i.e., SAP S4 HANA training.
HANA Architecture?
The SAP HANA database is developed in C++
and runs on SUSE Linux Server. SAP HANA database consists of multiple servers
and the most important component is the Index Server and consists of the
following.
Index Server: Main component of DB and
contains data stores, and engine for processing the data. Process the queries
in authenticated session and transactions.
Persistence Layer: Responsible for durability
and atomicity of transactions. Make sure that data is committed and can be
restore in case of disasters.
Processor Server: The index server uses the
preprocessor server for analyzing text data and extracting the information on
which the text search capabilities are based.
Name Server: The name server owns the
information about system. In a distributed system, the name server knows
location of components running and data located on which server.
XS Engine: Uses HTTP module (engine) to
connect to HANA database.
What
is row store and column store in HANA?
Row Storage: It stores table records in a
sequence of rows. Oracle, SQL server, Teradata store data in row storage.
Column Storage: It stores table records in
a sequence of columns i.e. the entries of a column is stored in contiguous
memory locations.
What
is calculation view, analytical view and attribute view?
Attribute View: Attribute view(s) are
dimensions or master data and can be joined with dimension table or another
attribute view.
Analytic View: Consists of fact table
(master table) with various dimension tables. Fact table contains the
transnational information. Easy to summarize (aggregate) the data from
dimensions table.
Calculation View: Calculation views are
composite views and can perform complex calculation on data. It can combine
information(such as facts) from various table, attribute and analytical views
into one large chunk.
What types are SQL joins are
available?
Left Outer join
Right outer join
Cartesian join
Want to take SAP HANA training, For more details please contact:
Visit: www.learnittraining.com
Email: contact@learnittraining.com
Phone: India+ 91 9912989639 ,USA+12108585008
To register for
free demo or online classes reach us at: http://www.learnittraining.com/student-registration/
Comments
Post a Comment