Skip to Content
0
Former Member
Sep 19, 2005 at 03:09 PM

Production system - deletion of data

25 Views

Hi,

This is my scenario

    Init + delta           FullUpdate
    -------------> CUBE A -----------> CUBE A1
                (Compression)
ODS -------------> CUBE B
    -------------> CUBE C
        {PSA}

Delta has been initialized and is flowing every nite from the ODS into the three cubes shown above(via the PSA). CUBE A is compressed and full uploads happen every night into CUBE A1.

Now we want to delete the contents of the CUBE A and load the data again without disturbing the delta, as the data in the ODS in massive - 20 million records.

My question is - can I delete the data from the cube and reconstruct from PSA, without disturbing the delta administration?

Girish