nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Update / Inserts in Data-Sync

Brian666H

Summary

Looking for the count of records Inserted & Updated

Content

Is there a way to find out how many records were Inserted and Updated. Separate counts not total counts.

Version

Oracle Analytics Cloud Data Sync (2.5)

Find more posts tagged with

Reporting

Packaging and Licensing

Accepted answers

All comments

User743400-Oracle

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

Thanks for all your help!

Brian666H

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

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.