Why do we delete setup tables?

[Former Member]

Hi Experts,

While doing Standard LO extraction why do we delete setup tables?

Do we delete even for delta loads?

Thanks in advance,

Raj

[Former Member · Accepted solution]

While doing Standard LO extraction why do we delete setup tables?

[Former Member]

Hi,

Normally the delta will happen through rsa7 and the full/init load will happen through setup tables.

The setup table deletion is done to avoid any duplicacy in the setup table. Before doing the full/init the data for that particular selection condition is checked in the ssetup table if completely not there the remainint data is deleted from teh SETUP table and again forthat selection parameters statistical run is done to fill in the setup table and then full/init is done to extract the data to BW.

Hope this helps

Assign points if helpful

Janardhan KUmar

[Former Member]

Deletion comes when you have to reinitialise delta and not otherwise.

Ravi Thothadri