Skip to Content
author's profile photo Former Member
Former Member

Full update on DSO

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 23, 2012 at 03:58 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 23, 2012 at 06:06 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 23, 2012 at 06:55 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.