cancel
Showing results for 
Search instead for 
Did you mean: 

Full Upload DataSources work as Delta

Former Member
0 Kudos

Hello friends

I have been provided with R/3 datasources that seems to be Full Update mode (If not wrong infopackage tells me whether DS is Full or Delta isnt ? well I have only the full option with the DS).

How can I do to load delta with this same DS ?

prompt reply appreciated!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

if you don't have the option "delta" in your IPack, it means that delta loads aren't supported for this DSource.

What kind of datasource is this? Generic? Business Content?Master/Texts/Transactional? Depending on this you there could be several solutions....

hope this helps...

Olivier.

Former Member
0 Kudos

Olivier

sorry I did not see this reply.

How can I know which type of DS I have ?

I have some for master data text load other for its attributes and another for pairing x product with its valid attributes. All of them have been defined based on original Ds (x eje: 0material_attr --> zmat2_attr sort adding missing fields).

I have a hierarchy one which I decompose to load some attributes and a transaccional for loading sales history...

Former Member
0 Kudos

Hi,

as you have answered, it is a generic datasource, based upon a table/view or a function module?

If you want to delta enable, you'll have to find a suitable field (e.g. update date or timestamp) and maintain the delta settings in the datasource definition in RSO2....

is your transactional load DS also a custom DS (generic)?

But enabling a datsource for delta is not done just "snapping the fingers"

hope this helps...

Olivier.

Former Member
0 Kudos

Olivier

How can I know on which field to select as key for Delta update ?

For example one data source (sort of master) gives me Product - geozone - productCategory

I dont understand well how delta works but If I need to choose product as my key any changes on the productCategory field for an X product will not be reflected as this field is not the key??

For transaccional data is the same?

Former Member
0 Kudos

Hello KCA,

Usually, the timestamp fields are the best. The timestamp fields in the table should be updated according to the system time. COnsider below example.

Doc 1 Qty 10 Timestamp 1000

Doc 2 Qty 20 Tiemstamp 1200

When you extract at 1250 timestamp (System time), all the records which are created before 1250 gets extracted. Now if you make the changes to doc 1, it will be posted as per the new timestamps

Doc1 Qty 15 Timestamp 1500.

Since the last extraction happened at 1250, this record is captured in the delta.

The problem with cal day extraction is, if the document is changed in the same day, it will not be identified in the delta. The same is with numeric pointer as well. So the best way to extract deltas is with time stamps.

regards

Sriram

Former Member
0 Kudos

Sriram

very useful info! thanks. One thing: If my updates are nigthly would be OK the calday() as probabiliies that something got updated at that time will be almost null isnt ?

But this calday() only works for transactional datasources isnt? or do they apply for Master / attribute data as well...?

About the timestamp do I need to include it in the custom Datasources as an aditional field ? or it is an automatic value I can capture ? your details would be highly useful

Former Member
0 Kudos

Hello KCA,

I think u still have some confusions about the deltas.

Even if the updates are nightly, if you mention calday as the delta extraction on one day field, if the record changes in the same day, then that record would not be captured in for the delta. What i mean is, suppose you have a record in the table as below

Record 1, qty 15, Date posted 10.09.07 and then you extract it on 10.09.07. Now on the same day, the record is been changed to qty 20. Now if you extract the data on 11.09.07, the changes will not be coming in for the delta. In this case, the delta field name will be the date posted and the Type of Delta-Relevant Field is cal day.

Regarding the timestamp extraction, this field should be present in the base table from which you are extracting. This field should be updating with the current system time, whenever a record is updated. Then only you can use this field in the delta specific field under Type of Delta-Relevant Field -> timestamp. If this is not present in the table, then you cannot extract delta by timestamps.

Regards

Sriram

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

You can get the deltas, following the guidelines given by Olivier. But if that is not working you can go for Pseudo delta methodolgy. This methodolgy is also useful for those datasources which dont have delta capability and we want to get the deltas.

<b>Pseudo delta:</b>

(this will only work for update mode overwrite)

1. What you'll have to do is find a particular field like 0calmonth or similar (0calday) and make it available for selection in IP.

2. When giving the selections in IP, use standard variable for getting current month data and assign it to that field (0calmonth or 0calday).

3. What happens is every time you run that IP it'll pick current month (or day) data only, not the whole data. As its in overwrite mode, it works fine.

When this month is over, when next month starts, the prevoius data will be like final you cannot change it through your new delta. Only through current months deltas we can load any updations or changes.

Hope this was clear.

Regards,

Habeeb

Former Member
0 Kudos

Hi KCA

Delta is a property of data source...infosource has option to choose delta or full load..but if DS doesn't support u cant do it...you should create a generic data source and define the delta field

Thanks

Tripple k

Former Member
0 Kudos

Hi Tripple

allow me 2 questions regarding your reply...

1) How can be sure that my DS are delta enable or not ? These are customized based on standard 0Mat.... datasources

2) How can the Infosource controls the delta or full load ?

thanks

Former Member
0 Kudos

Hi,

in R3, call tran RSA2 with your DS; under "Delta Process" you'll see the kind of delta.... (<empty> means no delta; full only)

hope this helps....

Olivier.