I've an implemented data flow for the data source 0FI_GL_4.
As we know, this specific DS is not a reference for "performance topics", it usually has a slow load process.
Here in my system, it's very slow since always, I mean, we considerer as "normal" when a load that loads ~5 millions of records takes ~6 hours to finish... And I'm saying only for the InfoCube load process.
My current issue is that for some reason, this same loads starts to take longer each time a new one is performed.
Now days, during an InfoCube load with ~6 millions of records, it takes between 10 and 15 days!!! It's unbelievable!!!
We already tried a lot of actions within this data flow, but nothings worked.
Rebuild of the Star Schema, changing dimensions, delete index, clear tables, provide more backgrounds to the process, but all of that was unsuccessfully.
I would like to know if some of you already had this kind of issue and how did you solved that or if anyone here has some idea about how to fix that?