Delta in Generic data extraction

[Former Member]

Hi all,

I have a doubt here,

What is the delta in Generic Data extraction?

What are the types?

and what are their significances?

Please give reply.

Thanks

Surya.

[Former Member · Accepted solution]

Hi Nitin,

Thanks for your reply.

I heard that, delta in Generic data extraction is possible in 3 ways.

But i don't know what are those.

If you know that please explain me.

Hi Roberto,

Thanks for sending me that doc. But i already have that with me.

Please clarify my above said doubt.

If possible with some other documents related to that.

Waiting for your reply.

Thank

Surya.

[Former Member · Accepted solution]

Hi Surya,

If a field (date, progressive document number, timestamp) exists in the extract structure of a DataSource that contains values which increase monotonously over time, you can define delta capability for this DataSource. If such a delta-relevant field exists in the extract structure, such as a timestamp, the system determines the data volume transferred in the delta method by comparing the maximum value transferred with the last load with the amount of data that has since entered the system. Only the data that has newly arrived is transferred.

To get the delta, generic delta management translates the update mode into a selection criterion. The selection of the request is enhanced with an interval for the delta-relevant field. The lower limit of the interval is known from the previous extraction. The upper limit is taken from the current value, such as the timestamp or the time of extraction. You can use security intervals to ensure that all data is taken into consideration in the extractions (The purpose of a security interval is to make the system take into consideration records that appear during the extraction process but which remain unextracted -since they have yet to be saved- during the next extraction; you have the option of adding a security interval to the upper limit/lower limit of the interval).

After the data request was transferred to the extractor, and the data was extracted, the extractor then informs generic delta management that the pointer can be set to the upper limit of the previously returned interval.

Hope now is clearer...

Bye,

Roberto

[Former Member · Accepted solution]

Hi Negro

I read your answer about the generic data extraction, want to go in more details (If particular table is not having any Date, Time and Running number fields) and was wondering about the file that you sent to Surya. Can you please send the same document my email address

santoshrvarma@yahoo.com

Thanks,

Varma.

[Former Member]

Hi Surya,

Click on the generic delta tab when you create a generic data extractor. Things will be pretty clear. As i had said in my earlier post you can either create a delta using time stamp,Numeric pointer or Calender day.

Rest as Roberto said.

please don't forget to reward the answers to your questions by clickin'on the yellow stars and assigning points...it's a way to say thanks !!!

[Former Member]

Hi Nitin,

Thanks a lot.

I have already assigned points to both of you.

Hope you are happy with that.

Bye,

Surya.

[Former Member]

Hi Surya,

I'm sending to you an e-mail with a useful how-to document !

Let me know if you need something else...

Bye,

Roberto

[Former Member]

Hi Negro

I read your answer about the generic data extraction and was wondering about the file that you sent to Surya. Can you please send the same document to the below email address

s_marcado@yahoo.com

Thanks,

Sabrina.

[Former Member]

Hi Roberto,

Pls send me document on Delta in Generic Extraction,

My emailid bhima.chandrasekharg@gmail.com

[Former Member]

I think that all of you have already this doc !

www.service.sap.com/bi -> SAP BW Infoindex (How to create generic delta)

Bye,

Roberto

[Former Member]

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).