Partitioning BIG Fact QVD file into multiple QVD Files?
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.