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

Delta Update

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • Posted on May 27, 2008 at 08:37 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 27, 2008 at 08:49 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      The initialisation run & delta for ODS 2 are working fine.

      After the initialisation run, the data is updated in ODS1 change log as well.

      After the delta run, the data is updated in ODS1 change log as well.

      what could be the reason for this?

  • author's profile photo Former Member
    Former Member
    Posted on May 27, 2008 at 08:52 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 27, 2008 at 08:53 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 27, 2008 at 09:08 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 27, 2008 at 09:12 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 29, 2008 at 03:45 PM

    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)

    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.