on 07-08-2010 3:35 PM
How can i create Delta for a heneric DataSource?
Hi iSeeemy
In RSO2 transaction , click "Generic Delta" and a new window will open.
Here you have to choose any field from your DS which is increases monotonously. It can be TImestamp, CalenderDay or Pointer.
THis is needed by the system to check which records have been added since last extraction ( characterised by the criteria you have choosen).
I would suggest you to create delta on the basis of any time stamp field in the data source.
Cheers
Pradeep
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
IN Tcode rso2; select your data source: edit, choose generic delta button, give the delta specific field,and followed by
any one of delta options UTC time stamp or date or time or numeric pointer field, use safety intervals either upper or lower, save the data source,replicate the structure.
Delta mechanisms : Calday,TimeStamp,Numeric Pointer
We can go for any of these depending on the requirement.
Generally We go for Calday when we want to load the Delta daily or weekly.
Numeric Pointer :If we have a suitable requirement.(Eg: When we don't want to change the existing records and we have a field which holds Unique and Increasing value)
TimeStamp: If we have to do delta more than once in a day.
Safety Interval Upper Limit of Delta Selection
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.
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.
also download Generic Delta doc
Regards
KP
Edited by: prashanthk on Jul 9, 2010 8:05 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi iSeemey:
Please refer to this paper.
"How tou2026 Create Generic Delta"
Regards,
Francisco Milán.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.