1.
What Is Sap HANA Modelling?
Answer:
SAP HANA Modeling
at a glance:
SAP HANA Information
Modeling which also known as SAP HANA Data Modeling is the heart of HANA
application development. You can create modeling views on top of database
tables and implement business logic to create a meaningful report.
2.
Which Non-sap System Can Sap HANA Connect?
Answer:
Oracle Enterprise, IBM
Informix.
3.
What Are The Views Available In The Quick Launch Of Information Modeler?
Answer:
Navigator, Where-used
list, Job log, Properties.
4.
For What Life Cycle Management Perspective Is Used?
Answer:
We use Life cycle
management perspective to Upgrade/Updates for HANA studio.
5.
Opd For Data Replication Api Is Used In Which Replication?
Answer:
Data services 4.0.
6.
How Can You Ensure That Data Is Consistent In Source System And HANA System?
Answer:
Since any changes in
the source system are tracked in dedicated logging tables, the replication
status for each changed data record is transparent. An entry of logging table
is deleted after a successful commit statement from HANA database and this
procedure ensures the data consistency between a source system and HANA system.
7.
Which Section Controls The Data Processing In The HANA Db?
Answer:
Transaction Manager
controls the data processing in the HANA DB.
8.
What Is The Component Present In Persistence Layer In The HANA Db?
Answer:
The component present
in Persistence layer in the HANA DB is Page management & Logger.
9.
What Are The Types Of Joins Are Possible In Attribute View?
Answer:
o
Referential join
o
Inner join
o
Outer join
10.
What Is The Role Of Persistence Layer?
Answer:
It ensures that the
database is restored to the most recent committed state after a restart and
that transactions are either completely executed or completely undone. The
persistence layer offers interfaces for writing and reading data. It also
contains SAP HANA‘s logger that manages the transaction log. Log entries
can be written implicitly by the persistence layer when data is written via the
persistence interface or explicitly by using a log interface.
11.
What Does HANA Db Performs During Power Outage?
Answer:
Recovers log between
last data save point & time of failure.
12.
What Is The Operating System Of Imdb?
Answer:
SUSE Linux Enterprise
Server.
13.
Which Is The Default Perspective Of Imce Studio?
Answer:
Administrator console
14.
Name The Editions Of Sap HANA Software?
Answer:
o
Platform edition.
o
Enterprise edition.
o
Enterprise extended edition.
15.
What Are The Benefits Of Implementing Sap HANA With Sap Erp?
Answer:
o
Performance optimization for operational reporting.
o
Processing of large volumes of data.
o
Provision of real-time analytics.
16.
Do We Need A Special Driver To Access Data Within HANA?
Answer:
HANA provides both a
32-bit and 64-bit ODBC and JDBC drivers. SAP Business Objects 4.0, Data
Services 4.0 and many other SAP based tools have built-in support for these
drivers to help support all the features HANA has to offer.
17.
How Can We Load Data In HANA And How To Access The Data Stored In HANA?
Answer:
Loading data: There are several options available to get data into HANA.
SAP provides a real-time replication server called SLT Replication. With this
server you can replicate data from a SAP system or non-SAP RDBMS systems into HANA.
The data is copied in its native format and will then need to be de-normalized
on HANA using information views (attribute views, analytic views and
calculation views). According to the documentation, you can also leverage the
Sybase Replication Server for log based replication. In addition, Data Services
4.0 can be used to move data into HANA and can update data at near real time if
needed. Data Services 4.0 can also de-normalize the data given its
abundance of data transforms and provide data quality and cleansing transforms
that will help clean the data before it is loaded into HANA.
Access the data: There are several ways to access the data within HANA.
The ideal way to access data is through SAP Business Objects 4.0. There are
multiple tools within the Business Objects 4.0 platform for accessing HANA
data. You can utilize Web Intelligence, Crystal Reports, Explorer, “Analysis
Edition for Microsoft Office”, Mobile and Dashboard (Xcelsius). In short, any
tool in the platform that supports ODBC or a Universe can be utilized to access
data within HANA. These options work for SAP BW (powered by HANA) or for HANA
(Standalone). If you have SAP BW powered by HANA, you can utilize any of the
traditional query tools. For those that like viewing raw data results, you can
utilize HANA Studios to execute SQL statements and view the results.
18.
Why We Need To Go For Going In-memory?
Answer:
One reason is the
number of CPU cycles per second is increasing and the cost of processors is
decreasing. For managing the data in memory, there is five-minute rule which is
based on the suggestion that it costs more to wait for the data to be fetched
from disk than it costs to keep data in memory so it depends on how often you
fetch the data.
For example: there is a table and no matter how large it is and this
table is touched by a query at least once every 55 minutes, it is less
expensive (in hardware costs) to keep it in memory than to read it from memory
and if it is frequently accessed it is less expensive to store it in memory.
19.
What Are The Advantages Of Column Based Tables And Row-based Tables?
Answer:
Advantages of Column based tables:
o Calculations are typically executed on single or a few columns
only.
o The table is searched based on values of a few columns.
o The table has a large number of columns.
o The table has a large number of rows and columnar operations are
required (aggregate, scan, etc.).
o High compression rates can be achieved because the majority of
the columns contain only a few distinct values (compared to a number of rows).
Advantages of Row-based tables:
o The application needs to only process a single record at one
time (many selects and/or updates of single records).
o The application typically needs to access a complete record (or
row).
o The columns contain mainly distinct values so that the
compression rate would be low.
o Neither aggregations nor fast searching is required.
o The table has a small number of rows (e. g. configuration
tables).
20.
What Is Derived Attribute Views?
Answer:
In some business
cases, it is required to use the same attribute view more than once.
In such cases, one can
derive an attribute view using the base view which acts as reference to the
base attribute view. The derived attribute view will be opened in the read-only
mode. The only editable field will be its description. The derived attribute
view will act as a reference to its base attribute view.
