Skip to Content
author's profile photo
Former Member

Deletions of Multiple Request from ODS in one go

Oct 07, 2005 at 11:11 AM | 7 Views

Hi,

we have ODS which has multiple initialization based on selection .

Now if we want to delete all the request related to one o the selection initalization then can we do it in one go.

I want to delete the records from active data table and change log as well.

Sachin K

BW (SAP Business Warehouse)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    author's profile photo
    Former Member
    Oct 07, 2005 at 12:23 PM

    Sachin,

    as already explained in the past, after your several init loads, delta is summarized in only one...so, after the inits, there isn't a delta belonging to an init and a delta belonging to another one: delta is unique.

    So you can do only a selective deletion based on the criteria you want to use.

    Hope it helps!

    Bye,

    Roberto

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 07, 2005 at 11:27 AM

    Hi,

    I think it is not possible to delete all the reqests related to one init at a time.

    Deleting Data from the ODS Object:

    http://help.sap.com/saphelp_nw04/helpdata/en/2d/677b3c513d3311e10000000a114084/content.htm

    Regards-

    Siddhu

    Add comment
    10|10000 characters needed characters exceeded