3 Replies Latest reply: Mar 17, 2015 1:34 PM by Jonathan Poole RSS

    Load Data into QS/QV - Best Practice

    Imtiaz Ullah

      Hi all,

       

      Just interested in your thoughts on a best practice for importing data into Qlik.

      Historically I have always worked on a Star Schema model in SQL Analysis Services, so the traditional Fact with Dimensions etc.

       

      One thing I have noticed (more in QS, only just getting my hands on to QV) however, it appears that during the load process, I could write just a wide SQL query which has already joined on to the dimensions, or I could load each dimension as it's own table and then the fact, and leave Qlik to create the model.

       

      I know in QS you can create dimensions on the fly within the app, so this could be used to work around the need to have separate dimension?

       

      Just interested in your thoughts really.

      Thanks

      Immy