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

Problem with delta

Hi Experts,

I have a custom master attribute datasource which is build on function module (generic datasource). Delta-Specific Field for DataSource is calendar day (AEDAT - Last changed on) and setting is Safety Interval Lower Limit - 1 (calendar days).

Now my problem is I am missing some records.

I have scenario (but I am not sure)

Exmaple : A record was created on 13th May 2008 (Monday) and this records is successfuly pikced into BW from R3 in the 14th May 2008 (Tuesday) data load and the same record was changed after the data load on 16th May 2008 (Friday). The changes are not picked into on 20th May 2008 (Monday) data load.

  • Theere are no loads happened on 18th and 19th May 2008 (saturday and sunday)

I presume that the safety Interval Lower Limit - 1 (calendar days), if we have done a data load on 18th May 2008 (saturday) may be these changes will be picked into BW from R3.

Can anybody explain me, how I am missings these reocrds

Thanks in advance

Narendra.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 22, 2008 at 09:55 AM

    Hi Narendra,

    I dont think, this might be a case with safety delta, but with the delta specific feild.

    As per your example, its picking up, if we have a change in creation date feild, but not when we have a change in changed on feild.

    may be you should reconsider the decision of going with current delta identifier feild.

    Naveen.A

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 26, 2008 at 11:39 PM

    Are you sure that your extractor pick the modified records in that cases?Maybe theres a code problem for certain situations....

    regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 27, 2008 at 06:03 AM

    Hi Narendra

    Ur ex is correct

    Since u gave only 1 lower limit on monday ,it will catch the saturday

    records also butnot friday changed records

    But U can solve this problem by loading it dialy thru PC,irrespective of working day or not so that dialy it will do loading and u get all changes

    If u still not satisfy ,U have to increase ur lower limit,since any way u r loding to ODS

    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.