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

safety interval limit in generic extraction

Posted on Jan 08, 2007 at 09:28 AM 118 Views

hi

can anybody explain what is the difference b/n safety interval upperlimit &lower limit in generic extraction.as per my knowledge upper limit 1 &lower limit 0. and what is field name.

if we didnot provide safety interval how it works.

can anybody in detail view with Example pl

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2007 at 09:34 AM
    0

    Hi

    See this

    doubt-on-generic-datasource

    Assign points if useful

    Thanks

    N Ganesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Ravi Ramasamy
    Ravi Ramasamy
    Posted on Jan 08, 2007 at 09:44 AM
    0

    Hi Venu,

    <u>From How to create Generic delta doc:</u>

    If delta field is Date (Record Create Date or change date), then use Upper Limit of 1 day & leave Lower limit blank.This will load Delta in BW as of yesterday.

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

    If delta field is a Numeric Pointer i.e. generated record # like in GLPCA table, then use Lower Limit. Use count 10-100. Leave upper limit blank. If value 10 is used then last 10 records will be loaded again. If a record is created when load was running, those records 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 once; therefore, be sure this DataSources is only feeding an ODS Object already extracted to be extracted in the next run last extraction today

    Check this doc for more

    http://www.ko-india.com/content/weblogs/generic_delta_explained.pdf

    Regards,

    R.Ravi

    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.