Skip to Content

how to initialize delta update in flat file extraction

hi friends,

I have done flat file extraction ,now i have updated my flat file but i don't know how to initialize delta update for this??

There is only on option that is of full update in infopackage.

can any body guide me for this.

thanks,

ravi

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    Posted on Jun 09, 2012 at 08:53 AM

    Hi Ravi,

    If you want to capture delta from Flat file, you can achieve through Delta mode of DTP between DSO & IC.

    Assaign semantic keys and update data to IC.

    You can also use Routines as mentioned above.

    Regards,

    rvc

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 08, 2012 at 01:56 PM

    Hi,

    Delta load is not possible for flat file.

    Use alternate method to do delta load from flat file by writing routines in infopackage.

    check this doc..

    Making Flat File Data Sources Delta Capable by Using Routine in Infopackage Selection

    It is only possible in BI 7.3.

    Regards,

    Aravind.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2012 at 01:53 PM

    why would you want to do delta extraction with a flat file?

    I mean, remove the old file and extract the whole new file.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2012 at 01:58 PM

    Hi Ravi,

    You need to find out the delta field in your flat file and implement routine for the same field to indentify the delta records.

    Check the below doc for step by step procedure.

    Making Flat File Data Sources Delta Capable by Using Routine in Infopackage Selection

    Regards,

    Venkatesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 09, 2012 at 08:37 AM

    Hi Ravi,

    Delta from Flat file 🤯

    Find out the fields which needs to be loaded as delta from the flat file.

    A routine needs to be used to do furhter as provided in above links.

    BR,

    Arpit

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 08, 2012 at 01:53 PM

    HI ravi ,

    If ur source system is flat file then there is no initialization option will be there , u have to load the data vial full update only..

    Thanx & Regards,

    RaviChandra

    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.