Is there a way to confirm that the FDI Warehouse Full Reload Schedule has performed successfully?

Question

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.

Sumanth V -Oracle · Answer

@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.

Georgina Sawyer · Answer

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.

Sumanth V -Oracle · Answer

@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:

https://docs.oracle.com/en/cloud/saas/analytics/24r3/fawag/view-load-request-history.html#GUID-6085251E-FB1C-4AE3-A3E8-517B2B3E5F65

Additionally, we also have a preview feature where you can subscribe for email notifications. Please refer the below document for details.

https://docs.oracle.com/en/cloud/saas/analytics/24r3/fawag/enable-event-notifications-preview.html