Categories
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Warehouse Refresh Statistics - add start time, duration, count of records
Branden Pavol
Rank 6 - Analytics Lead
In the Common - Warehouse Refresh Statistics, there are a few fields missing in order to do meaningful analysis. Please add the following:
- Warehouse Refresh Start Time
- Refresh duration in minutes (Warehouse Refresh Date Time - Warehouse Refresh Start Time)
- Count of successful records
Ideally, we would be able to track the data at a more granular level than just at the Warehouse start and end times. It would be good to know how each job is running. This is all important to me to determine what my Frequent Data Refresh intervals can be set at. Can I run them hourly? Every 3 hours? Every 6 hours? Maybe some jobs can run more often than others? I need to be able to break this down and then Oracle needs to give us more control over the execution of the jobs.
3