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

ODS data loading

Hi experts,

We have an init request and many delta requests in ODS. When I want to do an init data loading again. Do I need to delete the existing requests in ODS? Why? Thank you.

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 30, 2007 at 06:28 AM

    Hi KISHORE M REDDY,

    You mean I just need to delete init-flag for datasource , instead of requests, Right?

    Thank you.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Gavin,

      Deleting the requests in the ODS and then doing an init load with data transfer is the better idea. But in case you really have to keep the old requests for some reasons, you may perform first a "full repair" load before you do a init without data transfer. This helps ensuring data consistency between your ods and the source before initializing it again.

      Hope this helps.

      Regards,

      Randy

  • author's profile photo Former Member
    Former Member
    Posted on Aug 30, 2007 at 06:05 AM

    It is not possible to do init once more after running Deltas.

    If you want to do the init request you have to delete the existing requests because once you had run Delta load it won't accept to run Re-init.

    Hope it will helps you......

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 30, 2007 at 06:09 AM

    Hi Gavin,

    Yes , if you want to do Init again means.. you need to delete the data.. but.. once you load the deltas.. after init is not suggestable.. that's why it wont support..

    you shold delete the data and do INIT.... becaus ethe name itself.. INIT means ..Initially we are doing this step..

    regards

    @jay

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 30, 2007 at 06:10 AM

    Yes you have to delete the requests as the Initialization is set once & deltas were loaded.

    Also you have to delete the "Initiazation in the Source System" - Infopackage - Scheduler to do Init again.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 30, 2007 at 06:15 AM

    Hi Gavin Gu

    You should delete the init Y bcz its a source system specific.

    If already delats are running then u can just delete the existing init req and then do

    an init w/o data transfer.So that from next load onwords it will set up the delat w/o

    any struck ups.

    Hope itz Helps..!

    Regards

    KISHORE M REDDY

    **Winners Don't Do Different things,They Do things Differently...!**

    > Hi experts,

    >

    > We have an init request and many delta requests in

    > ODS. When I want to do an init data loading again. Do

    > I need to delete the existing requests in ODS? Why?

    > Thank you.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 30, 2007 at 06:33 AM

    You have two options if you delete the delta init (in the infopackage) but not the request, then you can do a init without data records and next the delta would be working...or you can delete all the data of the ODS and reload all...

    In both cases you must delete the init delta

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 30, 2007 at 07:00 AM

    Gavin,

    It is not possible to run the INIT once after you run the delta loads, but i dont know why you are looking for INIT run when the system is running with the delta loads. If you really wnat to run INIt then you need to delete the data and then you need to delete the INIT request in IP screen, then once again you can run the INIT.

    Assign Points if it helps..

    Thanks,

    Gattu.

    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.