Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Data-Sync New/Updated files not moving to cloud

Summary
Load Strategy New/Update not moving new / changed files
Content
At 7 AM this morning my job ran. My load Strategy is set to (Update Table - Add New - Update existing). My filter is V_Last_Update_DT.
Zero records were copied up to the cloud.
(select to_char(max(last_update_dt), 'mon-dd-yyyy hh:mm:ss') dt ,count(*) ct )
PSOFT DB: dt " apr-16-2019 12:04:00" ct"1531193"
OAC DB: dt"apr-16-2019 12:04:00" ct"1525021"
No records were moved
Version
2.5
Answers
-
Files are not read incrementally. All the files in the specified location are read. You should purge the old files and just keep the new ones for the loading. You can set "Delete source file(s) upon successful load (true/false)" to true for automatically delete files. Its possible that the new ones were loaded first and then the older ones - which may have caused some issue.
You may want to uptake the 2.6 version, which has some bug fixes.
0