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

data extraction via combination of full + init updates

in order to reduce performance problems we're currently experiencing, as well as to spread out the resource drain of data extraction, i'm planning to perform full updates for infoproviders on a per month basis (based on document date), and then perform an init delta on the last month.

what possible problems might i encounter if i setup my processing this way, besides not being able to track any changes that were processed in full update?

thanks.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2004 at 08:53 AM

    If I understand you right you want to do the initial upload by doing a delta init based on document date for the last month and upload the previous months in full upload. The biggest problem you might have is that you may not get changes on older line items, e.g. cancellation of old documents that often doesn't change the document date. If this cannot happen at your installation you could go with it. An alternative is to do an initial upload without data transfer for the last two years and then do a full upload on a monthly basis including the current month. You need to make sure that noone is able to post in the system during this procedure.

    Best regards

    Dirk

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 07, 2004 at 12:41 AM

    thanks a lot - i'll keep your suggestion/s in mind. =)

    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.