In the scenario of an update to an Info-Cube from an ODS, the system automatically creates a number of dialog process based on the volume of data to be updated.
Since each of these processes run independently, it appears that the start rtn is executed in each process.
In the cases where a large table is read into memory in the start rtn, this happens in each process which is an unnecessary in terms of efficiency of the load process.
Any ideas on ways around this and/or is there a way to share the table in memory once its read.
Thanks Mathew
Add a comment