Need to see the filter criteria value of the filter
Data Sync Question
Where do i see date-time stamp of the criteria / filter
Oracle Analytics Cloud Data Sync (2.5)
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:
\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.
Thank You. I can see my Prune time had no effect. Do I need to select / click "Generate" after I select my Prune time?
You dont have to regenerate, this should be automatic runtime behavior. I just tried it with 2.6. It works.
Sorry, I should have mentioned this before... Go to Views->System Properties. Set the Server Log Level to FINEST. Rerun the job. This information is printed in the FINE log level. Inspect the log file. You should see the statements like below:
378 FINE 2019-05-01 10:19:56.274 PST Executing query : SELECT "SHIPTO_ADDR_KEY","OFFICE_KEY","EMPL_KEY","PROD_KEY","ORDER_KEY","UNITS","DISCNT_VALUE","BILL_MTH_KEY","BILL_QTR_KEY","BILL_DAY_DT","ORDER_DAY_DT","PAID_DAY_DT","DISCNT_RATE","ORDER_STATUS","CURRENCY" FROM "SAMP_REVENUE_F" WHERE 1=1 AND ("ORDER_DAY_DT" > ?) 379 FINE 2019-05-01 10:20:04.594 PST Bind parameters : Type: java.sql.Timestamp Value: 2019-04-30 17:15:02.0
