Q. What is difference between SAP User and DB user? Ans. Schema user , i.e the database user is used to access the data with certain authorization levels. Q. What is Information Model and why is it required? Ans. Information Model main purpose is to hide the technicalities to select data and make it easier for business users to model their data which can be pulled w/o technical knowledge just db functional knowledge is sufficient. An information model ( purpose was to hide the complexity and to overcome some setbacks with the queries ) · Used to convert linear structure to a multi dimension structure w/o knowing technical language Are Process of converting source data (in tables) into business understandable format They also make use of Hardware advancements in HANA. · If we define information models inside HANA DB, We can also reduce the data transfer b/w DB and App layer Complex logic as well as transformation executed in DB layer.
