What are the different types of schema used in Qlikview?

Sharad Jaiswal
Sharad Jaiswal

Posted On: Feb 22, 2018

 

There are two types of the schema used in Qlikview. They are Star Schema and Snowflaking schema. The schema in Qlikview is a dimensional model to store data.

  • Star schema: It is a common dimensional model as it uses simple dimensions and facts to organize data. Both fact and dimension are interlinked just like front-end and back-end applications. A fact is an event that takes place when input data is given. The dimension stores the information the fact is associated with. For example, if a user logins a page then the login is the fact and the information entered is the dimension. This scheme is collected for a particular table and is represented in the form of a star. It contains facts and dimensions next to each other. When all of them is put together a start schema is formed.
  • Snowflaking schema: It is just an extension to the star schema. As the data increases additional dimensions may have to be added. We can add these new dimensions on the star schema through a relational environment. In this, the dimensions become multiple relational dimensions. When we represent this type of schema, the external extensions from a star schema give a snowflake-like pattern. Hence, this is called Snowflaking schema.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    QlikView Interview Questions

    Explain about all the features of Qlikview.?

    The segregation of data into different lists is the most useful tool in Qlikview. There are many features that can give reports on data sources available in the business organization. Quick storage: ...

    QlikView Interview Questions

    What is Set Analysis in Qlikview?

    With Qlikview, the analysis is made with the help of sets of different groups. This is applied for aggregation functions. This is used for comparing the sales or production based on the current and pr...

    QlikView Interview Questions

    How do you optimize the QlikView application?

    In QlikView, the QVD flies will store data that can be accessed for future use. The QV application can be optimized when we create QVDs. This gets stored in the RAM which ensures user experience too. ...