Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 53 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 293 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 116 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Incremental and Full load Timings
Hi Team,
I want to refresh my warehouse after each 4 hours and to achieve that I tried to check the Full load and Incremental load timings & Processed rows count etc details but i am not able to find those for FDI.
I have already checked the Common Subject Area and the DW_WH_REFRESH_SUMMARY table, It's not holding the Job Start time, Job end time , # records inserted, #records Updated etc. information.
Also I don't see any table/object in FDI where i can find the entire last load's statistics. All things in above mentioned area are holding specific table/object wise statistics.
Also in Request History tab, we don't have an option to check Incremental load's status, Please correct me here if i am wrong and if is there any option to check Incremental load statics from Request History tab then please guide me.
Can we have this option available in FDI?
Thanks,
Dhaval.