Oracle Analytics

Get Involved. Join the Conversation.

Topic

    Brian Hall
    Looking for a workaround / solution for filter date field
    Topic posted May 29, 2019 by Brian HallSilver Medal: 2,000+ Points, last edited September 11, 2019, tagged Access & Manage Data 
    60 Views, 1 Comment
    Title:
    Looking for a workaround / solution for filter date field
    Summary:
    Not all tables have a filter date field
    Content:

    Team

    In this wonderful world of Data-Sync (DS) 2.6.

    I am doing a copy of each table needed for my AP reports from PSOFT to ADW.  I still must set the keys (no big deal I got that) but DS also wants a “filter date field” it can use to compare to the last time it was updated. 

    In some of the tables (ps_voucher) we have “Last_Update_DTTM” however in other tables like (PS_PYMNT_VCHR_XREF) we have no such date field. 

    In this case DS forces us the do a destruct and initial load every time.

    Looking for a workaround / solution for said issue.

    Thanks

    Version:
    Oracle Analytics Cloud Data Sync (2.6)

    Comment

     

    • Juan Diego Ruiz

      Hi Brian,

      Here you have a summary of all load strategies available in DataSync:

      https://docs.oracle.com/en/cloud/paas/bi-cloud/bilpd/help-load-strategy-dialog.html

      Have you trield all of them? Some should not require the date according to the docs.

      Regards,

      Juan Diego