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
Is there a way to confirm that the FDI Warehouse Full Reload Schedule has performed successfully?
I understand that you can check refresh statistics in the Common - Warehouse Refresh Statistics subject area, however their is no Process type for Full Reload.
I have also checked the DW_WH_REFRESH_SUMMARY in the ADW.
Is there a way to confirm that the reload schedule has successfully performed when scheduled using the Warehouse Full Reload Schedule function in FDI?
Thanks.
Answers
-
@Georgina Sawyer - Status can be checked in request history tab. It shows all the required details of a running job. Please review the below document for more details on same.
Reference:
Additionally, we also have a preview feature where you can subscribe for email notifications. Please refer the below document for details.
0 -
Hi @Sumanth V -Oracle, the Request History Tab only shows Data Reloads that are performed adhoc, ie. selected to perform with the next refresh.
I want evidence that the functional areas that are selected in the Warehouse Full Reload Schedule within the Pipeline settings have successfully reloaded on schedule.
0 -
@Georgina Sawyer - Request history is the only option available as of now, which shows the overall status of the job and doesn't split in detail showing the each functional areas statuses.
The other option would be to check the last updated date of the specific Fact tables of the functional area to see if it's refreshed.
0
