Conversion of Characteristic Values to SIDs is taking long time

[Former Member]

Hi Experts,

Cube load is taking more than 7 hrs to complete for 6 million records. Max time is at Conversion of Characteristic Values to SIDs. Cube consists of 500 fields. Load is from DSO to Cube. DSO has 10 fileds with no SID flag check for activation. Remaining fields in the CUBE are pouplated looking in to other DSO's. Start and End routines are executing very fast. How to fasten Conversion of Characteristic Values to SIDs step. I need to load 15 million records daily as part of delta. any suggestions.

Thanks

Sunil

[Former Member · Accepted solution]

Hi Sunil,

Go through the below link, it will be useful

http://aq33.com/business-warehouse/Articles-05269.html

Regards,

Marasa.

[Former Member · Accepted solution]

Hi Marsa,

Thanks for your response. I tried various options like deleting indexes, running the DB stats etc..Still I am seeing the Conversion of Characteristic Values to SIDs is taking long time.

Sunil