Conversion of Characteristic Values to SIDs taking more time
Data load from DSO to Cube is taking 2 hours for loading 2 Lakhs records.While checking the monitoring screen, Conversion of Characteristic Values to SIDs is taking more time. Right now, SID Generation is checked in DSO. While checking the SAP_INFOCUBE_DESIGNS, one the dimension is showing more records than Fact table. Right now we are facing this issue in Production, Can you please suggest how to minimise the data loading time from DSO to Info Cube.