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

delta extraction understanding

Hi All, Can anyone tell me whatz the difference between the generic delta in a Generic datasource and the delta in the Lo Cockpit.

Thanks,

Simmi

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

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

    Hi simmi,

    The delta in generic datasource is actually pseudo delta

    which is determined by the extractor. It can use a date field, a timestamp or a incrementing number as the delta field. But the delta in LO cockpit is application delta, ie the delta records (afterimage/before images) are created at the time of the transaction or bulk statistical update (V3 job).

    Hope this helps

    Anoop CM

    Add a comment
    10|10000 characters needed characters exceeded

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

    Thank you all for your helpful answers. I have allotted the points to you all.

    Thanks again

    simmi

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi simmi,

      Well, you can also load the generic delta to Cube also provided you only need new records created and is not intrested in records that have changed during the delta period.

      If you need real delta, or the set of new as well as changed records during the delta period then you will have to use the ODS using (AIE) (New status for changed records) method.

      The architechture of ODS is so helpful that when you activate the data in ODS, it will automatically create the before/after images for us and fill it in the ChangeLog table. From there it can be transfered to the required datatargets using update rules.

      But as everybody will warn you, when you delete records generic delta is rather helpless and you may have to write your own logic using Function modules to accomodate that.

      Hope this clears your doubt.

      regs

      Anoop C M

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

    Hi Simmi,

    some additional info to what Anoop posted.

    The delta in the Lo cockpit can be posted directly to a cube, whereas the generic delta has to go to a ODS first, in order to get the 'real delta'.

    regards

    Siggi

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      This depends on the table contents. You could load a generic delta directly into a cube if the application writes deltas directly into the table. If you load the data into an ODS be careful of the key definition.

      And finally don't forget that deleting records in the table always confuses nearly any kind of extractor.

      Best regards

      Dirk

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.