About The Use Of Setup Tables

About The Use Of Setup Tables

In lo extraction we delete setup tables for the first time (init and full update). The data is extracted from the setup table without intervening the application database.

My question is
1. After the full load or init load will the setup table is used? if how?
2. For direct update and queued delta setup table is used?

Set up tables is to store and pull the historic data in BW.

Once you do an init and stsrt filling the set up tables the delta queue is created in RSA7 which stores the delta. So once your set up tables are finished you do full repair or full load from the data ousrce to target and then you run the delta's.

Just remeber that set up tables are just the storage of data of the records before records stsrts moving into the delta queue.
The practice is to first do init W/0 data transfer in the data source and then start filling the set up table. As you will you do the init w/0 data transfer you will have all the new records pulled into the delta queue and after that you start filling the set up tables.

This can bring the new records which are also going to the delta queue but after the set up tables are filled the full loads to the target will be followed by delta loads which will overwrite with the new records.

Delta init and full upload's data comes from setuptable.

The system starts capturing all newly created records and modifications in either LBWQ/Sm13/Rsa7 according to update methods(Queue delta,unserialized delta,direct delta) . This collection starts once we activate the extraction structure. So these records will become as Delta loads. So there is chance of having the records in these queues which were records before filling setup table. And also these records comes into setup table if we do filling setuptable . So thats why we need to clear these queues before we start the filling setup table.

*-- Ravi