3 Replies Latest reply: Mar 16, 2015 11:51 PM by jagan mohan rao appala RSS

    Partitioning BIG Fact QVD file into multiple QVD Files?

    Shivendoo Kumar

      Hi Members,

       

      I have more than 600 million records in one of my fact tables and this table holds exactly 2 years of data in my DWH which is having daily partition in SQL Server DWH DB. So In SQL Server DB, I have total 730 partitions for this fact table.

       

      Question arises, is that possible to partition QVD file? If yes I would like to partition my fact QVD into 8 quarters (2 years of data) so that we should not face any performance issue. Maximum users browse recent 3, 6 months data but few users go for 1 year or 2 years data.

       

       

      2nd query, What would be the script in dashboard which should dynamically point to right partition based on user selection.

       

      If anyone has done any such implementation please provide steps and script if any.

       

      Message was edited by: Shivendoo Kumar