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

Impact of loading two targets from same DSO

Hi all,

very quick question on the implications of loading data from one DSO to another DSO and InfoCube in parallel,

will this have negative performance impacts or cause locking issues on the source etc???

Points awarded,

Thanks,

Shane.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 07, 2012 at 04:10 PM

    Hi Shane,

    There will not be any impact you can read data from same DSO at a time using two different transformation.

    There will be some impact on performance, but not major.

    Regards,

    Ganesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 07, 2012 at 06:40 PM

    I believe basis has configured a balance between background and dialog users.

    So in that case this task will run parallely with multiple background users which are relatively free if huge data loading activities are not going on.

    You can go check in SM51 and you can see multiple processes running while you do the load and there will be free background processes too which will tell you your system is fine.

    Cheers!

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 07, 2012 at 09:16 PM

    Hi,

    It is a usual practice to have logical partitioning for performance reasons. The partitioned cubes are loaded from the same source, usually a DSO, using multiple DTP's that are kicked at the same time. Hence, it is safe to load two targets from the same DSO at the same time. Make sure that you have enough processes available.

    Thanks,

    Ranga.

    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.