4 Replies Latest reply: Oct 20, 2011 5:34 AM by Chris Hopkins RSS

    Load only last 8 weeks data

    Chris Hopkins

      Hi, i have an application that is too big for our current server. I want to try and only load in the last 8 weeks worth of data but am unsure how to do this in the load script.

       

      Can anyone help please?

       

      I have attached my load script

        • Re: Load only last 8 weeks data
          Miguel Angel Baeyens de Arce

          Hi Chris,

           

          You need to add a WHERE clause to each table you want to reduce data, for example

           

          LOAD StoreNumber, 
               TransId, 
               TransStartDate, 
               TransStartTime, 
               EmployeeId, 
               TillNo, 
               TransStatus, 
               OverallDiscount, 
               Nolines, 
               TradingDate, 
               ZreadRef, 
               TrainingMode, 
               TrainerId, 
               %LkStoreTransID, 
               %lkStoreEmployee
          FROM $(cFileName) (qvd)
          WHERE Date(TransStartDate) >= Date(Today() -56);
          

           

          You can try a debug loading limiting the load to the first X number of rows.

           

          Hope that helps.

           

          Miguel Angel Baeyens

          BI Consultant

          Comex Grupo Ibérica