3 Replies Latest reply: Feb 23, 2016 12:11 AM by Tresesco B RSS

    Full day reload help ???

    Amit Saini

      Hi Folks,

       

      I'm using below script for generating QVD over the weekends for the full week , in case I have missed the data for any weekday!

       

       

      Let vLoadFrom = timestamp(If(Weekday($(vLAST_LOAD_TIME)) >= 5, WeekStart($(vLAST_LOAD_TIME)), $(vLAST_LOAD_TIME)), 'DD.MM.YYYY HH24:MI:SS');

       

      STICHPROBE:

       

      LOAD

       

          '$(vPlant)' as Plant,

       

          *;

       

      SQL SELECT

       

      NSPCIDNR,

       

      NTOOLNR,

       

      NSTPNR,

       

      NPERS_IDNR

       

      FROM $(vPlantAutor).STICHPROBE

       

       

      WHERE DTTSERF > to_timestamp('$(vLoadFrom)', 'DD.MM.YYYY HH24:MI:SS');

       

       

       

      store STICHPROBE into $(vQVDCurrentYear)\$(vPlant)_STICHPROBE.qvd;

       

       

      Now what I'm looking for is :

       

      Suppose when I have triggered QVD Generator @ 6:00 AM , this might have missed some data which was made available  later this day@9:00 PM inside database. So to support these cases of database update issue , is there any solution with the above script where I can write :

      "Each day @ 11:00 PM , I want a full load for fetching data from database for the full day and store as QVD"

       

      Please suggest if this approach is possible or not???

      Thanks,

      AS