Data Map push is taking extremely longer time
I launched a Data Map directly to push WFP data to FS. It could finish in a few seconds 2 months ago. Yet it gradually takes longer and longer time. Yesterday, it took around 1 hour.
As you can see below, the Export data file is less than 200Kb; so it's not that much data. There were some additional dimension members but it's not that many as well.
I was guessing there were some #Missing blocks; so use CLEARBLOCK EMPTY to do some clearing on those combinations that are defined in the data map. It did get better since before clearing #Missing blocks, it took 1.5 to 2 hours.