Interview Questions.

Q1. What Is Ad Hoc Analysis?

In traditional statistics warehouses, including SAP BW, lots of pre-aggregation is performed for short consequences. That is the administrator (IT branch) makes a decision which facts might be wished for evaluation and prepares the result for the quit users. This results in fast overall performance but the end person does no longer have flexibility. 

The performance reduces dramatically if the consumer wants to do evaluation on a few information that isn't already pre-aggregated. With SAP HANA and its fast engine, no pre-aggregation is needed. The consumer can carry out any type of operations in their reviews and does now not must wait hours to get the information ready for evaluation.

Q2. What Is Global Transfer Nile?

This is a switch routine (ABAP) defined on the data object degree; this is not unusual for all source structures.

Q3. Can You Disable Cache?

Yes, both globally or using question debug tool RSRT.

Q4. What Is An Info Source?

A shape inclusive of InfoObjects without endurance for connecting  ameliorations.

Q5. What Is A Transnational Infocube?

These cubes are used for each examine and write; wellknown cubes are optimized for analyzing. The transactional cubes are used in SEM.

Q6. What Are The Types Of Attributes?

Display best and navigational; display most effective attributes are best for display and no evaluation may be achieved; navigational attributes behave like ordinary characteristics; as an instance, anticipate that we have a consumer characteristics with u . S . As a navigational attribute; you can analyze the records the use of consumer and u . S . A ..

Q7. What Is The Dim Id?

DIM ID: are used to connect reality tables and measurement tables.

Q8. What Are The Steps To Load Non-cumulative Cube?

Initialize commencing balance in R/3 (S278)

prompt extract structure MCO3BFO for statistics source 2LIS_03_BF

set up historical material files in R/three 

load opening stability using records supply 2LIS_40_S278 

load historical movements and compress without marker update. 

Installation V3 replace

load deltas the use of 2LIS_03_BF.

Q9. How Does Sap Hana Support Massively Parallel Processing?

With availability of Multi-Core CPUs, higher CPU execution speeds may be done. 

Also, HANA Column-primarily based storage makes it easy to execute operations in parallel the usage of a couple of processor cores. 

In a column store facts is already vertically partitioned. This way that operations on unique columns can easily be processed in parallel. If a couple of columns need to be searched or aggregated, each of these operations can be assigned to a special processor middle. 

In addition, operations on one column can be parallelized by way of partitioning the column into a couple of sections that can be processed by using exclusive processor cores. With the SAP HANA database, queries may be achieved hastily and in parallel.

Q10. What Is The Time Distribution Option In Update Rule?

This is to distribute facts consistent with time; as an instance, if the source consists of calendar week and the target includes calendar day, the facts is spit for each calendar day. You can pick both the normal calendar or the manufacturing unit calendar.

Q11. What Are The Row-based And Column Based Approach?

Row based tables:

It is the traditional Relational Database approach

It save a desk in a series of rows

Column primarily based tables:

It keep a desk in a series of columns i.E. The entries of a column is saved in contiguous memory places.

SAP HANA is in particular optimized for column-order storage.

SAP HANA helps both row-based totally and column-based method.

Q12. What Is A Source System?

Any machine this is sending records to BW like R/three, lat report, oracle database or external structures.

Q13. Can You Partition A Cube Which Has Data Already?

No; the cube ought to be empty to do that; one paintings round is to make a replica of the dice A to dice B; export facts from A to B using export statistics source; empty dice A; create partition on A; re-import facts from B; delete dice B.

Q14. What Is The Language Sap Hana Is Developed In?

The SAP HANA database is advanced in C++.