DSO Activation taking long time!

We have a issue where our DSO has been activating for quite some time
now. We have an enhancement where we need to add fields in the DSO.

However,we found that the DSO is not activated after we have migrated
our. However,during the activation of the DSO, it is taking a very long
time in activating it.


DSO Tech name : ZDSO_RR

The Solution :

When you have large amount of data in the table (ODS), the following is a work around to get the new columns added to the ODS/DSO:

1. Make copy of the existing ODS (ODS1) to ODS2
2. Add new fields to ODS2
3. Load the data from ODS1 to ODS2 using datamart (use ODS2 for further purposes).

If you have some reporting queries defined on ODS1 then you need to do the following:

1. Make copy of the existing ODS (ODS1) to ODS2.
2. Load data from ODS1 to ODS2 using datamart.
3. Delete Data from ODS1.
4. Add new fields to ODS1.
5. Reload the data from ODS2 to ODS1 using data mart.

Please take note :

1) Create a DSO copy
2) Load data from original DSO to DSO copy
3) Delete data from DSO original
4) Migrate the adding new field changes
5) Activate the DSO using program : RSDG_ODSO_ACTIVATE


6) Reload back data to DSO

If you're having the same issue with Infocube, this solution applies to that as well.