My Oracle Support Banner

DataSync: How To Run Tasks To Load Files From UCM TO ADW By Keeping The Refresh Date As Null? (Doc ID 2727769.1)

Last updated on NOVEMBER 18, 2020

Applies to:

Oracle Analytics Cloud - Version N/A and later
Information in this document applies to any platform.

Goal


Data load issue while loading CSV files from UCM to ADW tables using Datasync.

While loading data from csv files in UCM to landing tables using Datasync,the job does not pick up the files when the task is re-run.
The job works fine and data is loaded on the first run,but from 2nd run onwards data is not loaded.

On setting the refresh dates to null on the 2nd run, the data is picked up again.
But the idea is to have a full run always, and not to have an incremental run.

Is there a way to run tasks to load files from UCM to ADW, by keeping the refresh date as null.

The load strategy for the job was set to 'Replace data in table' and READ_TYPE is 'data Extract'.
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.