4 Replies Latest reply: Aug 3, 2012 3:35 AM by Steven Bain RSS

    Schedule Script to Load Current FACT - but Keep Previous DIMS?

    Steven Bain

      Hiya Guys,

       

      I have 5 Dimension tables, and 1 Fact table.

       

      The Dimension tables will change very rarely - and I would like to automatically update my Fact table very regulary.

       

      If I load all the tables once, and then in subsequent loads only generate a new Fact .qvd and import - QV removes the previous Dimension tables created... is there any way around this? (so I am only loading the current Fact data and keeping the old Dimensions?).

       

      Also, I would like to schedule the Fact load... maybe once a minute?! - very small dataset... does anyone have a best-practice way of setting-up a Schedule for such a high-frequency update? - Windows Task Scheduler/QEMC/other?... load time of the Fact table is litterally only a couple of seconds - but I don't want to grind the Server to a hault!

       

      Any information/suggestions welcome!

       

      Cheers,

       

      Steve.