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.