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

DTP Process!

Hello Gurus,

Need suggestions on this - (I searched in the forums before posting this but could not find answers to my questions.)

I know how DTP works and how to deal with error stack but I want to know how it behaves?

1.What happens if I am doing a full load (1st Day) and some records came into error stack. 2nd Day, again my full load started and I have not cleared my error stack of 1st Day and some more records from 2nd Day came into my error stack? What needs to be resolved first before my 3rd Day full load starts or next full load starts? How does DTP behaves on this? Will it recognize my Day1, Day2 error records separately when I correct them or will it push all of then at a time.

What steps needs to be followed before my next full load starts? How to resolve this problem?

2. What happens if I am doing two subsequent delta loads into one data target and my first process is not yet finished? I know that delta capabilities in DTP will load both of them but if both the delta request has the same keys for update, will my load fails? or will it be successful?

How does DTP behaves and how do we need to handle this kind of situation?

3. Is it compulsory in both the cases that either full or delta but first set of request or load needs to be activated before next one processed or not necessarily required?

Thanks in Advance,

Liza.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 12, 2007 at 03:18 PM

    I put my thoughts in here..you may wait for Gurus for their comments

    <b>1.What happens if I am doing a full load (1st Day) and some records came into error stack. 2nd Day, again my full load started and I have not cleared my error stack of 1st Day and some more records from 2nd Day came into my error stack? What needs to be resolved first before my 3rd Day full load starts or next full load starts? How does DTP behaves on this? Will it recognize my Day1, Day2 error records separately when I correct them or will it push all of then at a time.</b>

    I presume all your errors will summed up

    Day 1- 5 erroneous records and you didnt correct

    Day 2- 5 (from Day 1) + 2 NEW erroneous records and and you didnt correct

    Day 3 - 5 (from Day 1) + 2(from Day 2) + 3 NEW erroneous records and and you didnt correct

    total on day 3 you should see 10 erroneous records which you need to correct and push forward.

    In principle all your erroneous records should get accumulated as you move ahead.

    <b>

    What steps needs to be followed before my next full load starts? How to resolve this problem?</b>

    <b>2. What happens if I am doing two subsequent delta loads into one data target and my first process is not yet finished? I know that delta capabilities in DTP will load both of them but if both the delta request has the same keys for update, will my load fails? or will it be successful?</b>

    Technically you can schedule parallel DTP's for same data targets ;however you have to make sure you have enough parallel

    process in your system to handle them and so as not to fail .

    In case of data target as DSO i reminisce discrepancies of data in ACTIVE table when loaded in parallel;however it was 3.1C and can say more of exception than rule and with nw2004s am sure DSO matured pretty much by now.

    Infocubes should have no problems with parallel DTP'S.

    PS - if you are sp< 11 you might get locking issues with DTP when scheduled in parallel.

    Note 998093 - P11:DTP:PC:Parallel DTPs that update the same data target

    for write optimized DSO you can do paralle DTP's with SP 12

    Note 1007769 - Parallel updating in write-optimized DataStore objects

    <b>How does DTP behaves and how do we need to handle this kind of situation?</b>

    3. Is it compulsory in both the cases that either full or delta but first set of request or load needs to be activated before next one processed or not necessarily required?

    Its not Imperative as aforementioned.

    Hope it Helps

    Chetan

    @CP..

    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.