In my application data model i have 10 dimension table and single fact table.
I have a requirmet to Schedule-reload of fact table every 30 minutes but dimension tables have to be scheduled-Reload daily once
How can i achieve this without reloading the dimension tables every 30 minutes and the fact table showing latest records(updated every 30 minutes) in a single application
Place all your Dimension tables script in one Qlikview file and save the dimension tables into QVD and schedule this file to load every day once, and put your fact table in separate qlikview file and schedule it to load every 30 mins. Now finally load this qvds into another new Qlikview file, which is your presentation file. Schedule this file to load every 30 mins. This way you can reduce loading the Dimension tables.
