Q. What is the difference between Row Storage and Column Storage? Row Store


Q. Why Fact Table should not be added in an Attribute View?



Download 0.51 Mb.
View original pdf
Page18/48
Date07.04.2021
Size0.51 Mb.
#56254
1   ...   14   15   16   17   18   19   20   21   ...   48
AOH INTERVIEW QUESTIONS
MTS Auth ISSUES
Q. Why Fact Table should not be added in an Attribute View?
Ans. It is recommended to use an Attribute View with only Master Table because of performance criteria. It is advisable that Fact/Transaction Table used with Analytical view, and not be used with
Attribute view due to performance implication since Attribute View is processed in the join Engine of
SAP HANA, it is not processed by OLAP Engine which is equipped to do aggregation.
Statement: To expose a View/Model to the user, you create a select query on top of your view and create an OData on your query and create a fiori app to expose it to the user…sap.viz OR use ALV
grid

Download 0.51 Mb.

Share with your friends:
1   ...   14   15   16   17   18   19   20   21   ...   48




The database is protected by copyright ©ininet.org 2024
send message

    Main page