Interview Questions.

Question 1. What Is The Time Distribution Option In Update Rule?

Answer :

This is to distribute data per time; for example, if the supply contains calendar week and the target incorporates calendar day, the statistics is spit for each calendar day. You can pick out either the everyday calendar or the factory calendar.

Question 2. What Is The Language Sap Hana Is Developed In?

Answer :

The SAP HANA database is evolved in C++.

SAP BI Interview Questions
Question 3. What Is Ad Hoc Analysis?

Answer :

In traditional records warehouses, which includes SAP BW, quite a few pre-aggregation is achieved for short outcomes. That is the administrator (IT branch) makes a decision which information might be wanted for evaluation and prepares the end result for the end users. This effects in rapid overall performance however the give up person does no longer have flexibility. 

The overall performance reduces dramatically if the consumer wants to do evaluation on a few facts that isn't already pre-aggregated. With SAP HANA and its rapid engine, no pre-aggregation is required. The consumer can carry out any form of operations in their reports and does not have to wait hours to get the information ready for evaluation.

Question 4. What Are The Types Of Attributes?

Answer :

Display handiest and navigational; display only attributes are most effective for show and no evaluation can be executed; navigational attributes behave like ordinary traits; for example, anticipate that we have a client characteristics with u . S . A . As a navigational characteristic; you can examine the records the usage of customer and country.

SAP BI Tutorial
Question 5. What Are The Row-primarily based And Column Based Approach?

Answer :

Row based tables:

It is the traditional Relational Database approach
It save a desk in a sequence of rows
Column based totally tables:

It save a desk in a sequence of columns i.E. The entries of a column is saved in contiguous memory locations.
SAP HANA is specifically optimized for column-order garage.
SAP HANA helps each row-based and column-based approach.
SAP WM Interview Questions
Question 6. Can You Partition A Cube Which Has Data Already?

Answer :

No; the cube ought to be empty to do this; one work around is to make a duplicate of the dice A to cube B; export data from A to B the usage of export statistics supply; empty dice A; create partition on A; re-import statistics from B; delete dice B.

Question 7. How Does Sap Hana Support Massively Parallel Processing?

Answer :

With availability of Multi-Core CPUs, higher CPU execution speeds can be accomplished. 
Also, HANA Column-based garage makes it smooth to execute operations in parallel the use of multiple processor cores. 
In a column keep information is already vertically partitioned. This approach that operations on different columns can easily be processed in parallel. If more than one columns need to be searched or aggregated, every of these operations may be assigned to a distinctive processor center. 
In addition, operations on one column may be parallelized by means of partitioning the column into a couple of sections that may be processed by means of exclusive processor cores. With the SAP HANA database, queries can be carried out hastily and in parallel.
SAP WM Tutorial SAP BO Interview Questions
Question eight. What Is The Dim Id?

Answer :

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

Question 9. What Is An Info Source?

Answer :

A structure along with InfoObjects without staying power for connecting two transformations.

SAP Netweaver Interview Questions
Question 10. What Are The Steps To Load Non-cumulative Cube?

Answer :

initialize opening stability in R/three (S278)
spark off extract shape MCO3BFO for information source 2LIS_03_BF
installation ancient cloth documents in R/3 
load opening balance using records source 2LIS_40_S278 
load ancient moves and compress with out marker replace. 
Set up V3 replace
load deltas the use of 2LIS_03_BF.
SAP BO Tutorial
Question eleven. What Is A Transnational Infocube?

Answer :

These cubes are used for each read and write; general cubes are optimized for reading. The transactional cubes are utilized in SEM.

SAP BODS Interview Questions
Question 12. What Is A Source System?

Answer :

Any system that is sending records to BW like R/3, lat file, oracle database or outside systems.

SAP BI Interview Questions
Question 13. Can You Disable Cache?

Answer :

Yes, either globally or the usage of query debug device RSRT.

SAP Netweaver Tutorial
Question 14. What Is Global Transfer Nile?

Answer :

This is a transfer routine (ABAP) described at the info object level; this is not unusual for all supply systems.