Design of DSO

New Data (Activation Queue) tablewhen data is loaded into DSO, its first stored in this table..key fields consist of                               * Request ID - Number given to each data loading                               * Package ID - Request ID is divided into number of data sets known as Package ID                               * Record number - Individual records in each package ID are assigned a number . this is record number.

Active Data TableThe data from the active data table is generally used for reporting. This table can also supply the full data upload to another data target. The key field chosen while designing a DSO is the key of this table.

The activation process moves data from new data to active data... The process is actually cut and paste.. after activation data won’t be available in new data. It will be available only in active data.. and change log table...

Change Log TableAll of the changes to existing records are recorded in the change log table.

http://1.bp.blogspot.com/--WOV15KZqFM/Ub7ksb_Bt9I/AAAAAAAABME/cEk-et_5RJw/s1600/Untitled.png

when we load data to DSO.. the data will be available only in New data table... and wont be available for reporting or any other needs..

after activation data will be cut and pasted to active table and change log table.

now data is available in active data table and change log table...

when we do query on DSO... data is actually taken from active table..

one of the main plus point of DSO is.. its overwriting capability..

lets see how it is done..

new request id is copied in new data table..

now lets activate our new request RQ2..

as you can see change log table has all track of all records...