3 Replies Latest reply: May 22, 2012 7:02 AM by Deepak Vadithala RSS

    Loading 10 million records into qlikview memory...

      Hello ppl,

       

      I am new to qlikview, till now I have used qvd to store the data and generate the reports using the same. I came up with some doubts and one of them is like this. My source table is actually located in some db tool (example: oracle) which is holding 10 million records with each and every detail of my customer details, sales, volume and data (denormalised data). Using this dataset I need to create a star schema in Qlikview with few dimensions and fact tables. Now my problem is there any other way of creating this star schema other than first loading all records from my prime source. I want to generate my dimensions and facts without dumping all the data into qlikview memory...

       

      Please suggest me and also do let me know if my way to generate the report is correct or not...

       

      Thanks in advance....