I have a question about any experience with very slow processing of DWH load JOB. What is quite interesting is that full load takes 1/4 of processing time of incremental one. We had experience that full load took more then incremental one but now it is opposite. It started after we have changed and increased amount of slices for DWH. It was not big change and even there are no data for those time periods.
Any idea or recommendation? Because it is oscilating from 90 to houndreds of minutes.