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.