I am having a problem in my project when loading an ODS.
Its a Z that was done to make full loads every week. It loads data into the ODS and after, if the load works well it makes another load into a cube deleting all the old requests.
2 weeks ago, due to a connection problem load failed. Till then, all the new loads fail because it tries to activate first the old one.
The old one is not in the ODS, we deleted it.
We need to load this weekend again and i think it will fail again.
My first idea was to change the status on that load and make a new one, will that works?
Thanks in advance