Skip to Content
0
Former Member
Sep 13, 2007 at 04:03 PM

Generate incremented unique values in ODS

48 Views

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