AnsweredAssumed Answered

Load Data Warehouse Full Load Frequency

Question asked by Abhijit_Clarity on Mar 16, 2018
Latest reply on Mar 21, 2018 by Suman Pramanik

Hello Clarity Users,

Currently we have below schedule for Load Data Warehouse.

We have full load every night and it takes around  5 hours. We have three times Incremental Mode in a day. We were planning to stop Full load everyday and run it once a week. But we noticed that Incremental Load sometime misses the data. Hence we have to go with  Full load again.

Our Full Load completes at 5.30 am. We have first incremental scheduled at 10 am. Surprisingly it also takes around 100 mins. and then remaining two takes 35 mins.

I was wondering how other Clarity Admin managing this or what is there experience about Load Data Warehouse.

 

Kind Regards,

Abhijit

Outcomes