Question - What is the Information model?
Answer -
Information model consists of Analytic, Attribute, and Calculation views and it is mainly used for hiding the technicalities of data selection so that it becomes easier for the business users to model their data who are having only functional knowledge about a database and doesn’t have any technical knowledge. So we can say that the information model hides the complexity and overcomes a few setbacks with the queries.
Information models are:
- Used for converting the linear structure into a multi-dimension structure without having technical knowledge.
- Process of source data(in tables) conversion into the format that is business understandable.
- Make use of Hardware advancements available in HANA.
- It is possible to reduce the data transfer between the database and application layer by defining information models inside HANA DB.
- Having Complex logic and also transformation executed in DB layer.