on 05-27-2008 9:30 AM
Hi Friends,
I would like to know whether we can do a delta update using flat files.
Does flat files support delta loads?
If so, please explain how to go about it in case of an ODS obkect.
Thanks & Regards,
Vijaya Krishna BK
k here is the deal with ODS, it only DOES FULL UPDATES, so even if you want to laod delta on ODs it will always be a full update, unless you have a cube on top of the ods then you can do delta updates. from ODS to CUBE but file to ODS will only be full updates as ODS is overwrite only and dnoesnt support delta's or new files,, it doesnt archive records.
hope that helps
Dante(Devils never cry)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You have to select a suitable update mode in transfer structure maintenance so that the system uses the correct update type.
· Full upload (ODS Object, InfoCube, InfoObject)
The DataSource does not support delta updates. With this procedure, a file is always copied in its entirety. You can use this procedure for ODS objects, InfoCubes and also InfoObjects.
· Latest status of changed records (ODS objects only)
The DataSource supports both full updates and delta updates. Every record to be loaded defines the new status for all key figures and characteristics. This procedure should only be used when you load into ODS objects.
· Additive delta (ODS object and InfoCube)
The DataSource supports both full updates and additive delta updates. The record to be loaded only provides the change in the key figure for key figures that can be added. You can use this procedure for ODS objects and for InfoCubes.
Refer
http://help.sap.com/saphelp_nw04/helpdata/en/57/e537373aedaf43e10000009b38f839/content.htm
Thanks,
JituK
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
For flat files, delta transfer in the case of flexible updating is supported. You can establish if and which delta processes are supported during maintenance of the transfer structure. With additive deltas, the extracted data is added in BW. DataSources with this delta process type can supply both ODS objects and InfoCubes with data. During transfer of the new status for modified records, the values are overwritten in BW. DataSources with this delta process type can write the data into ODS objects and master data tables. You can find additional information under InfoSources with Flexible Updating of Flat Files.
Refer
http://help.sap.com/saphelp_nw04/helpdata/en/8e/dbe92341c84242be2c7d3917f1c197/frameset.htm
http://help.sap.com/saphelp_nw04/helpdata/en/9a/e92637c2cbf357e10000009b38f936/content.htm
http://help.sap.com/saphelp_nw04/helpdata/en/57/e537373aedaf43e10000009b38f839/content.htm
Thanks,
JituK
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If the intention is keep on loading and not to delete the data previously loaded, then an ODS can help us doing this.
Load full update from the file.
We can set the update mode of an ODS update rule for all the keyfigures to Overwrite, so that although the same set of records everyday, even then ODS hold them only once.
If a new record is encountered then this is stored as it is.
So using this ODS, we can set the further update as delta to the next target.
Naveen.A
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
yes it is possible to have delta loads from flat files.
if you are in 3.X
while creating the infsource transfer structure u can see the update option there u can find full upload,delta for ods and cube,delta for ods only.
if u choose the delta option there u can have init and delta loads for the flat bfile datasource.
Ramesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Flat file do not support delta load, if you want to run delta, first load full to ODS and then load delta to cube/ODS.
Cheers,
Malli.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Malli,
I would like to thank you for your feedback and of course others as well who have contributed their suggestions.
The method you suggested is working except for a small problem.
I have done a full update for ODS1. I have activated the data in the ODS1 making them available in the Active & Change log tables.
I have generated export datasource of ODS1 and created the infopackage for the corresponding infosource available in DM under unassigned nodes.
Using the above infopackage, i did a initialisation with data transfer to transfer data from ODS1 to ODS2.
The data is available in the New Data table of ODS2. So far things are fine.
However now if i check the Change log table of ODS1, i am seeing the first full update data(say 10 records) and also one more set of same data(same 10 records again).
Please tell me what could be the reason for this?
Thanks in Advance,
Vijay
hi,
also do chk in the 0recordmode filed in change log you could find different images for the two sets also chk the key figure values, u could see negative values.
Properly compare the records in changes log.
hope if u have done 2 times and changing the data field infobject values you could see different images in the changelog 0recordmode field.
Ramesh
Flat file doesn't support delta. It always acts as a full load.
When you use R3 datasource which supports delta, it maintains a field called storno or rocancel. It gives the delta changes.
these changes are updated in Bw using 0recordmode field in ODS.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.