Parallel loading in DTP

[Former Member]

Hi,

I have a doubt. I have 2 dso in the source and one infocube in the target. Now I have two different DTP o load data from two diff DSO to that infocube. Now my query is can I run both the DTP at the sametime as because each of DTP load is taking huge time and this is one time activity.

One more doubt if its possible to run both the dtp at the some time for infocube, does it true for DSO i.e i mean to say I m loading data to a particular DSO from two diff DSO.

My understanding is as I am loading data to a DSO/infocube that means to a particular table corresponding to that DSO/infocube so exclusive lock of that table is required. simultaneously two request can't take the exclusive lock of a table. Please correct me.

Thanks in advance

Snehasish

[Former Member · Accepted solution]

Hi,

The fact table is partitioned by request, so parallel loads will not attempt to update the same rows.

So loading an InfoCube parellaly doesn't have any impact you can goahead.

Thanks,

Vishnu

[Former Member · Accepted solution]

Thanks Vishnu, llmjmy,Rahul. Points awared to all of you.

@Vishnu : As you have mentioned that fact table is partitioned by request.

Does the DSO's underlying table is partitioned.If not then how both the requests will be able to insert data into that particular table. as exclusive lock cant be given to 2 diff req at the same time.

@Rahul : Yeah it can be done thru process chain or serial loading but i want to know whether parallel loading is possible or not ? if yes then how the locking mechanism is happening here. As my knowledge says the new table for any dso is a flat table not partitioned table.

[Former Member]

Dear Snehasish,

You can definetely load the data from two diff DSO's to a single cube(it can be done easily with the help of a process chain) making the two DTP's run in parallel. You'll not face any locking issue in this case as the two diff DSO's has diff diff table which will not create ant locking issue while loading the data.

Same is the case when you are trying to load the data from two DSO's to a DSO.

Hope this explanation helps!

Regards,

Rahul.

Edited by: Rahul on Apr 25, 2011 10:19 AM

[Former Member]

You can load 2 DTPs to infocube at the same time. Dont worry on the locking issue.

This applies to DSO as well, i.e. 2 DTPs load to DSO at the same time, as long as you dont kick in the request activation in DSO then you should be fine.