Design of DSO

Posted by on







New Data (Activation Queue) table
when 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 Table
The 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 wont be available in new data.. it will be available only available in active data.. and change log table...

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










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...



Comments

  1. UnknownSeptember 26, 2013 at 9:12 AM

    hi can you please provide me more info about dso

    ReplyDelete
  2. Mrs. MansoorDecember 6, 2013 at 3:18 AM

    excellent & thank you

    ReplyDelete
  3. Mohammed SiddiquiDecember 23, 2013 at 4:02 AM

    excellent buddy...

    ReplyDelete
  4. Mohamed AslamMarch 2, 2014 at 9:44 PM

    Thanks

    ReplyDelete
  5. AnonymousMarch 22, 2014 at 6:54 PM

    Great job!

    ReplyDelete
  6. UnknownJune 4, 2014 at 12:14 AM

    Fantastic post ...thank you very much

    ReplyDelete
  7. MaheshAugust 14, 2014 at 3:49 AM

    Query will use ACTIVE TABLE and Loading to DSO or Cube will get data from CHANGE LOG TABLE. But in image 2 mappings it is showing differently. Could you please correct me if i am wrong.

    ReplyDelete
    Replies
    1. AnonymousSeptember 28, 2018 at 8:01 PM

      yes if we report on DSO the data will display from active data table but loading data from dso to infocube will get data from change log table.

      Delete
    2. AnonymousMarch 12, 2020 at 1:10 AM

      for Queries it will use Active table...That's correct.
      While loading data from DSO to Infocube --> 1. For full load, data will be taken from Active table..
      2. For delta load, data will be taken from Change log table.

      Delete
  8. rajamohanDecember 20, 2018 at 8:52 AM

    Adding to Anonymous in extraction mode if it is full it will fetch the data from Active table and if it is delta it is fetch from change-log table

    ReplyDelete

Post a Comment