SAP BW on HANA Interview Questions and Answers
Q1. What is SAP BW on HANA? How It Works?
Ans: When individuals allude to running SAP Business Information Warehouse on the SAP HANA in-memory data set, or SAP BW on HANA for short, they are looking at running a specific rendition of SAP's BW programming that involves HANA as its essential data set and is exceptionally upgraded for the HANA stage.
BW upholds numerous information bases, including Oracle, MS SQL Server, DB2 and presently HANA. Utilizing BW on HANA implies that no other data set is required.
SAP BW is additionally uniquely streamlined for HANA far in excess of its enhancement for different data sets. BW has information base explicit improvements for different data sets - - for instance, it upholds DB2's grouping idea for extremely enormous tables, though most different data sets utilize a parceling idea to deal with this situation - - however the circumstance with SAP HANA exceeds all expectations. Exercises like the initiation step for DataStore Objects, or DSOs, and particular sorts of changes are practically something similar on HANA as on different data sets, however the real handling has been moved into HANA instead of occurring on the BW application server as it does with different information bases. This eliminates information development, making it conceivable to execute these exercises a lot quicker with BW on HANA.
Different highlights are accessible just with BW on HANA. For instance, the Open ODS View idea is a method for overlaying such BW semantics as security and the BW logical motor on information that is put away in tables beyond the BW framework. Be that as it may, Open ODS Views are empowered in BW provided that it is running on top of the HANA stage, and isn't accessible on other data set stages.
The specific highlights accessible, as well as whether or not they are executed on HANA versus the BW application server, changed between NetWeaver BW discharge 7.3 and discharge 7.4, so beware of individual elements in the event that you are taking a gander at BW on HANA utilizing the 7.3 stage.
Q2. How truly does SAP HANA uphold Massively Parallel Processing?
Ans: With accessibility of Multi-Core CPUs, higher CPU execution paces can be accomplished.
Likewise, HANA Column-based capacity makes it simple to execute activities in equal utilizing numerous processor centers.
In a section store information is now upward parceled. This implies that procedure on various segments can without much of a stretch be handled in equal. On the off chance that numerous sections should be looked or collected, every one of these tasks can be relegated to an alternate processor center.
What's more, procedure on one segment can be parallelized by apportioning the section into numerous areas that can be handled by various processor centers. With the SAP HANA data set, questions can be executed quickly and in equal.
Q3. What is the DIM ID?
Ans: DIM ID: are utilized to interface truth tables and aspect tables
Q4. What is a data source?
Ans: A design comprising of InfoObjects without industriousness for interfacing two changes
Q5. What are the moves toward load non-total 3D shape?
Ans: instate opening equilibrium in R/3 (S278)
actuate extricate structure MCO3BFO for information source 2LIS_03_BF
set up verifiable material archives in R/3
load opening equilibrium utilizing information source 2LIS_40_S278
load authentic developments and pack without marker update.
set up V3 update
load deltas utilizing 2LIS_03_BF.
Q6. What is a transnational data block?
Ans: These shapes are utilized for both read and compose; standard blocks are advanced for perusing. The conditional blocks are utilized in SEM.
Give model information sources supporting this?
2LIS_03_BF and 2LIS_03_UM
Q7. What is a source framework?
Ans: Any framework that is sending information to BW like R/3, lat document, prophet data set or outside frameworks.
Q8. What is the time dissemination choice in update rule?
Ans: This is to convey information per time; for instance, on the off chance that the source contains schedule week and the objective contains schedule day, the information is spit for each schedule day. you can choose either the typical schedule or the plant schedule.
Q9. What is the language SAP HANA is created ready?
Ans: The SAP HANA data set is created in C++.
Q10. What is impromptu investigation?
Ans: In customary information stockrooms, for example, SAP BW, a ton of pre-collection is finished for fast outcomes. That is the overseer (IT division) concludes which data may be required for examination and readies the outcome for the end clients. This outcomes in quick execution however the end client doesn't have adaptability.
The exhibition decreases emphatically to do examination on certain information that isn't now pre-accumulated. With SAP HANA and its fast motor, no pre-total is required. The client can play out any sort of activities in their reports and doesn't need to stand by hours to prepare the information for examination.
Q11. What are the kinds of properties?
Ans: Display just and navigational; show just properties are just for show and no investigation should be possible; navigational qualities act like standard attributes; for instance, expect that we have a client attributes with country as a navigational property; you can examine the information utilizing client and country.
Q12. Notice What Is The Role Of The Transaction Manager And Session?
Ans: The exchange chief co-ordinates information base exchanges and tracks running and shut exchanges. At the point when exchange is moved back or committed, the exchange supervisor advises the elaborate stockpiling motors about the occasion so they can run essential activities.
Q13. Make sense of How You Can Avoid Un-essential Logging Information From Being Stored?
Ans: You can keep away from un-important logging data from being put away by stopping the replication by halting the pattern related positions.
Q14. Make sense of How Sql Statement Is Processed?
Ans: In the HANA data set, each SQL explanation is executed in the reference of the exchange. New meeting is designated to another exchange.
Q15. What are the line based and segment based approach?
Line based tables:
It is the conventional Relational Database approach
It store a table in a grouping of columns
Section based tables:
It store a table in a grouping of segments for example the sections of a segment is put away in touching memory areas.
SAP HANA is especially upgraded for section request capacity.
SAP HANA upholds both line based and segment based approach.
Q16. Might you at any point parcel a block which has information as of now?
Ans: No; the 3D shape should be unfilled to do this; one work around is to make a duplicate of the 3D square A to 3D square B; trade information from A to B utilizing send out information source; void 3D shape A; make parcel on A; re-import information from B; erase block B.
Q17. Might you at any point impair store?
Ans: Yes, either around the world or utilizing inquiry investigate device RSRT.
Q18. What is worldwide exchange nile?
Ans: This is an exchange routine (ABAP) characterized at the data object level; this is normal for all source frameworks.