Hi experts!
Im trying to generate a unique numeric value while loading data in an ODS.
Ex:
ODS Source:
CRED VAL
00006 10
00025 15
ODS Destination:
ID CRED VAL
1 00006 10
2 00025 15
Im using an abap routine which basically uses MAX(ID) to get the next value and assigns it to ID. It works fine. However when data is above 7000 registers datapackages are created. Apparently they are executed in parallel making the MAX(ID) to overlap, so instead of getting all the records, we are only getting the size of one datapackage. We will be loading over 3 million registers, so i guess increasing the size of the datapackage is not an option.
We are trying:
- To find a way to execute package by package, still not found.
- Divide into different requests, not achieved yet.
- Find another way to generate the next ID (internal table, NEXT_NUMBER functions, etc)
Does anyone have faced a similar problem? Can anyone give me a solution? It is urgent, I will award points!
DavidG