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

Why safety intravel limits, time stap and Numaric operator

Hi all,

when we r extracting genaric datasource what is purpose to set safety intavel upper limit and lower limit, when we r using time stamp and numaric operator.

what is the meaning for check Aditive delta

Thankx in advance

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jul 12, 2007 at 09:35 AM

    HI Nag,

    Select Delta type:

    New status for changed records (I.e.

    after-image); This can be used with

    Data target ODS (AIE).

    Additive Delta (<b>I.e. aggregated data

    records) (ADD)</b>

    Specify a safety interval.

    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.

    If delta field is Date (Record Create Date or change date), then use Upper Limit o

    This will load Delta in BW as of yesterday. Leave Lower limit blank.

    2. If delta field is Time Stamp, then use Upper Limit of equal to 1800 Seconds (30 m.This will load Delta in BW as of 30 minutes old. Leave Lower limit blank.

    3. If delta field is a Numeric Pointer i.e. generated record # like in GLPCA table, then Lower Limit. Use count 10-100. Leave upper limit blank. If value 10 is used then last records will be loaded again. If a record is created when load was running, those r may get lost. To prevent this situation, lower limit can be used to backup the starting sequence number. This may result in some records being processed more than 0 therefore, be sure this DataSources is only feeding an ODS Object .

    Check this doc for good understanding,

    Check this thread also,

    Generic extraction

    Hope this helps...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 12, 2007 at 09:44 AM

    Hai Nag,

    Go through it...........

    Safety Interval Lower Limit

    This field contains the value taken from the highest value of the previous delta extraction to determine the lowest value of the time stamp for the next delta extraction.

    For example: A time stamp is used to determine a delta. The extracted data is master data: The system only transfers after-images that overwrite the status in the BW. Therefore, a record can be extracted into the BW for such data without any problems.

    Taking this into account, the current time stamp can always be used as the upper limit when extracting: The lower limit of the next extraction is not seamlessly joined to the upper limit of the last extraction. Instead, its value is the same as this upper limit minus a safety margin. This safety margin needs to be big enough to contain all values in the extraction which already had a time stamp when the last extraction was carried out but which were not read. Not surprisingly, records can be transferred twice. However, for the reasons above, this is unavoidable.

    these are used to determining the delta in a datasource:

    1. Time stamp - The field is a DEC15 field which always contains the time stamp of the last change to a record in the local time format.

    2. Calendar day - The field is a DATS8 field which always contains the day of the last change.

    3. Numerical pointer - The field contains another numerical pointer that appears with each new record .

    This field is used by DataSources that determine their delta generically using a repetitively-increasing field in the extract structure.

    The field contains the discrepancy between the current maximum when the delta or delta init extraction took place and the data that has actually been read.

    Leaving the value blank increases the risk that the system could not extract records arising during extraction.

    Example: A time stamp is used to determine the delta. The time stamp that was last read is 12:00:00. The next delta extraction begins at 12:40:00. In this case, the selection interval is 12:00:00 to 12:40:00. At the end of extraction, the pointer is set to 12:40:00.

    A record - for example, a document- is created at 12:40 but not saved until 12:40. It is not contained in the extracted data but, because of its time stamp, is not extracted the next time either.

    For this reason, the safety margin between read and transferred data must always be larger than the maximum length of time that it takes to create a record for this DataSource (with a time stamp delta), or it must display an interval that is sufficiently large (for determining delta using a serial number).

    ****************Thanks inSDN====Asign points***********************************



    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.