Skip to Content
avatar image
Former Member

Full Load in sequence from ODS to ODS

Hi All,

we have a unique problem at my client. We load the delta for the day (Delivery) into Datastage and then do a full load into a ODS. Inorder that the records dont collapse we have a unique key which helps to keep the delta images unique in the ODS. Then we load the other datatargets from here - ODS and Cubes, using full load.

What we see is that the records go out of sequence when it moves form tha source ODS to the target ODS or Cube. For instance :

1. Image of record craeted $100.00

2. Image of record changed -$100.00

3. Final image $50.00

In this scenario the I expect $50.00 to show up in th traget ODS but I sometimes get -$100.00

which means the data is not sent in a sorted fashion (in our case as per the unique key)

So what I infer is that we need to have a full load process which acts like a delta load thus maintaining the sequence of records during load and activation.

I can control the sequence of the records in a packet by using a generic function module extractor with sort function. But during load/Activation into target ODS, how do I control the sequence in which the packets are processed.

What is the significance of tbale RODELTAM ? Does this table control the way the packets are handled. If yse how do I update this table ?

Any input will be helpful.

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Jul 25, 2004 at 08:15 AM

    Records 2 and 3 should be created in a second request ... while record 1 in another, previous one.

    SAP BW should activate records according to "M-Queue" (/BIC/<ODSNAME>40 table ...) physical key, so Req, DataPack and RecNo ... So record 3 shoul come after record 2 in higher level ODS. It won't solve ther problem, but you could sort DATA_PACKAGE in a start routine, according to this sequecnce. The problem comes when records 2 and 3 are in different Packages.

    According to me there's something unclear: ask for SAP Help opening a message in OSS.

    For more details about RODELTAM check SAP Documentation. This table explains the way Different Delta types do work.

    GFV

    P.S. Are you sure there aren't particular Custom Rules in your Update Rule?

    Add comment
    10|10000 characters needed characters exceeded