Incremental and Full load Timings

User_61DFB

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.