0

How to load a missing snapshot day

Patching caused the loader to be delayed and a scheduled incremental load of a snapshot for a table was missed. Is there a way to load the missing day into that table?

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Marc, if the data has been updated multiple times during the day, then Incorta will have no way retrieving the updated history.   If by 'loading the missing day' you mean create a snapshot for yesterday (Snapshot_Date = '10/06/2019') for example, but with today's image of the data, then you can simply replace sysdate in your incoremental query using a form of todate ('10/06/2019', 'MM/dd/yyyy'), where the exact format depends on your source database.  After running this incremental refresh, please remember to reset the incremental query to put sysdate as SNAPSHOT_DT.

    If you need more help with this, please log a ticket in Incorta support, and the support team will help you with this.

    Regards,

    Hichem

    Reply Like
    • Hichem Sellami Thank you. That is the approach I used. It looks as though it worked, but I will need to verify the data form SMSS as well. 

      Reply Like
Like Follow
  • Status Answered
  • 1 mth agoLast active
  • 2Replies
  • 23Views
  • 2 Following