Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Update / Inserts in Data-Sync

Received Response
179
Views
14
Comments
2»

Answers

  • User743400-Oracle
    User743400-Oracle Rank 3 - Community Apprentice

    Its a not so common usecase.  So, probably not documented clearly.  But this is the precise use case for the prune time concept.  Hope you find this functionality useful.

  • Brian666H
    Brian666H Rank 6 - Analytics Lead

    Thanks for all your help!

  • Brian666H
    Brian666H Rank 6 - Analytics Lead

    One more question.  I set the Prune time yesterday and my process ran this morning.  Is there a log file that will tell me wjat refresh date/time used?  If all went well it should show 12:04 AM 04/30/2019  not 09:04 am 04/30/2019

  • User743400-Oracle
    User743400-Oracle Rank 3 - Community Apprentice

    Jobs->Runs->Tasks subtab.  Choose the row you are interested.  Click on details.  Choose the row that reads INSERT_UPDATE_DATACOPY.  Double click on Additional Info/Log.  There is a log file name published like so:

    D:\datasync\log\ReadFromOracle-Oracle12c.25944081\CR_AB_DATA_FROM_OCS-AB_OCS_TARGET.20190430.1020.log

    That log file will contain the filter criteria used.