on 04-23-2012 4:40 PM
Hi Experts,
I have to run a full update on a DSO, which contains about 2 million+ records because of data inconsistency. Will deleting the existing data in the DSO and then doing the full load give better load performance, than doing a full update on DSO without deleting the data? Also, if there is a faster way of doing it, please let me know.
Thanks and Regards,
Ajay
HI
Better to run the DTP with different data selection based on the key fields . and increase the batch manager setting from 3 to 5 .
This will decrease loading time . If u lost any time during deletion , then it may create some problem so better to perform the above action.
Hope u got it,
Regards,
RaviChandra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Loading data into DSO in either of the cases you mentioned would not have any difference in terms of performance.
But during the DSO activation, yes it would be faster if the DSO is empty since it will not check for existing records for overwriting.
Again if you have SID generation active, then if you delete data then it will be time consuming if you delete the whole data as the system will have to generate SIDs.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Better to take back of data when u r deleting first.
And split the data into two parts and get the full data into DSO based on Fiscal period / some key filed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.