Skip to Content
avatar image
Former Member

Initialization of data source

I must initialize the 0FC_BP_ITEMS. The problem is that according to the number of entries from the SE16 for table DFKKOP, it will be over 83 million records. I estimate it will take about 11 days. Is there a way to break the process into 5 day maximum? Can we establish a date stamp for the process?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    May 29, 2015 at 08:41 AM

    Hi Bruce,

    Seems like you need to load existed data. mean full load.

    So better to load full load with selections where there is no burden(weekends) on bw server.

    During extraction keep on eye on SM58 and SM50.

    in deltas, if you want load certain data only then you can do the multiple inits with multiple selections(which are not to overwrite with other selections) without data transfer and set delta pointer.

    From PSA to targets connected delta dtp will load all requests.

    You can do init in any way.

    Method 1:

    init with data - use proper selections(multiple info packs) to speed up the load.

    Method 2:

    Run multiple full load info packs with proper selections. later you can run inits(needed, use proper selections) with out data transfer.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • May 28, 2015 at 03:13 AM

    HI,

    can you load the data based on the calyear- it will load year wise.

    prepare the plan and load it into BW system.

    Thanks,

    Phani.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Raf Boudewijns

      Hi,

      Create multiple selections for the Year filed in the Info Package and load as Full in Parallel. For the Most recent data try to load as INIT. This will reduce the efforts.

      Hope this helps your answer.

      Thanks and Regards,

      Mahesh

  • avatar image
    Former Member
    May 29, 2015 at 02:38 PM

    Thank you all for your replies. They were very helpful. The date selection unfortunately for my situation is not possible becasue we did a conversion in Nov 2014 and over 80% of the data is there. We will try another selector. Thanks again.

    Add comment
    10|10000 characters needed characters exceeded