Scribd Logo
Upload

Welcome to Scribd!

  • 150 views

    Delta Mechanism For Generic Extractors - SCN PDF

    Uploaded by

    vramkoti818
    The document discusses different types of delta mechanisms that can be used for generic extractors including CALDAY, timestamp, and numeric point. It explains how each works and provides examples. CALDAY based delta uses a date field to identify new or changed records since the last extraction, but only allows for one delta run per day. Timestamp delta allows for multiple runs per day by using a timestamp field. Numeric point only identifies new records. It also provides tips on setting safety intervals to avoid missing any records.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Delta Mechanism For Generic Extractors - SCN PDF

    Uploaded by

    vramkoti818
    150 views2 pages
    The document discusses different types of delta mechanisms that can be used for generic extractors including CALDAY, timestamp, and numeric point. It explains how each works and provides examples. CALDAY based delta uses a date field to identify new or changed records since the last extraction, but only allows for one delta run per day. Timestamp delta allows for multiple runs per day by using a timestamp field. Numeric point only identifies new records. It also provides tips on setting safety intervals to avoid missing any records.

    Original Title

    Delta Mechanism for Generic Extractors _ SCN.pdf

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document discusses different types of delta mechanisms that can be used for generic extractors including CALDAY, timestamp, and numeric point. It explains how each works and provides examples. CALDAY based delta uses a date field to identify new or changed records since the last extraction, but only allows for one delta run per day. Timestamp delta allows for multiple runs per day by using a timestamp field. Numeric point only identifies new records. It also provides tips on setting safety intervals to avoid missing any records.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    150 views2 pages

    Delta Mechanism For Generic Extractors - SCN PDF

    Uploaded by

    vramkoti818
    The document discusses different types of delta mechanisms that can be used for generic extractors including CALDAY, timestamp, and numeric point. It explains how each works and provides examples. CALDAY based delta uses a date field to identify new or changed records since the last extraction, but only allows for one delta run per day. Timestamp delta allows for multiple runs per day by using a timestamp field. Numeric point only identifies new records. It also provides tips on setting safety intervals to avoid missing any records.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 2

    08/11/2014

    Delta Mechanism for Generic Extractors | SCN

    Hi, Guest

    Log On

    Join Us

    Products

    Services & Support

    About SCN

    Downloads

    Industries

    Training & Education

    Partnership

    Developer Center

    Activity

    Lines of Business

    University Alliances

    Events & Webinars

    Innovation

    Browse

    Communications

    Actions

    Data Warehousing

    Delta Mechanism for Generic Extractors


    Posted by Anil Kumar Thalada in Data Warehousing on 23-Aug-2013 11:49:42
    Share

    Previous
    Next

    Tweet

    How to enable Delta Mechanism for Generic Extractors


    3 Types of Delta Mechanism for Generic Extraction
    1. CALDAY 2. Time Stamp 3.Numaric Point
    Delta Mechanism with CALDAY: I have a table VBAK VBELN, ERDAT,
    AUDAT, NETWR
    We can set up delta mechanism based on CALDAY (Data Source

    postpost

    Capability) when we have changed Date filed in data source


    AUDAT will give latest changed date

    VBELN

    ERDAT

    AUDAT

    NETWR

    4965

    01.01.2006

    01.01.2006

    5000

    4966

    02.01.2006

    02.01.2006

    1000

    4967

    05.02.2006

    05.02.2006

    15000

    4968

    06.07.2007

    06.07.2007

    20000

    4965

    01.01.2006

    09.07.2007

    9000

    If we run Initialization Delta on 03.01.2006 It will Pick 4965 & 4966


    If we run Delta on 05.02.2006 at night 12o clock it will Pick 4967 records
    (previously loaded records date >& TILL 05.02.2006 date)
    If we run Delta on 10.07.2007 It will Pick 4968 & 4965
    Limitations of Delta Mechanism with CALDAY: Multiple Deltas cannot be run
    on same day because it will not consider time factor. If the Delta Mechanism
    set up with CALDAY we can run delta only once per day at the end of day
    2. Delta Mechanism with Time Stamp: Since Delta is Time stamp; we can
    run the delta number of times. If you setup Delta with Time Stamp we need to
    have Time Stamp Field in the source (UPD_TMSTMP)
    3.Delta Mechanism with Numeric Point: If we set the delta based on
    numeric Point, it can only recognizes the newly added records but not the
    modified records
    Safety Interval: Lets assume your delta run on Sunday, Thursday and
    Saturday. And you last run was on Sunday and next Run is on Thursday.
    In this case if you have set the lower limit to 1, the delta run of Thursday will
    fetch data from Saturday till Thursday.
    http://scn.sap.com/community/data-warehousing/blog/2013/08/23/delta-mechanism-for-generic-extractors

    1/2

    08/11/2014

    Delta Mechanism for Generic Extractors | SCN

    "Delta management can take the lower limit from the last extraction.
    The lower limit for safety interval contains the value that needs to be taken
    from the highest value of the previous extraction to obtain the lowest value of
    the following extraction." E.g: You can say Lower limit = Highest value of last
    extraction- safety interval.
    Example: Lower Limit = 2, Upper Limit = 1
    Example: Lower Limit = 0, Upper Limit = 0
    Tips:
    If delta field is Date (Record Create Date or change date), then use Upper
    Limit of 1 day. This will load Delta in BI as of yesterday. Leave Lower limit
    blank.
    If delta field is Time Stamp, then use Upper Limit of equal to 1800 Seconds
    (30 minutes). This will load Delta in BI as of 30 minutes old. Leave Lower limit
    blank.
    NOTE: Safety interval should be set so that no document is missed even if
    it was not stored in the DB table when the extraction took place.
    Select Delta type:
    New status for changed records (I.e. after-image); this can be used with
    Data target DSO (AIE).
    Additive Delta (I.e. aggregated data records) (ADD); Compatible with Info
    cube & DSO

    3567 Views

    Share

    Tweet

    2 Comments

    Follow SCN

    http://scn.sap.com/community/data-warehousing/blog/2013/08/23/delta-mechanism-for-generic-extractors

    2/2

    You might also like