No of parallelism if we set to 2 what happens

[Former Member]

what is teh advantage of no of paralellism and if we set it to 2 what happens.

thank you very muchf or the helpful info.

[Former Member]

Hi cplusplus1 ,

the parallelism is a performance activity , the advantage of paralellism is it improve performace like instead of scheduling the data in a single sequence it will split the process into 2 or more depending upon the settings which you have given.it will process parallelly and it will reduce the total time of job execution

Thanks

Fasi

[Former Member]

Hi ,

The basic point is that when the no of process increases , jobs will run more efficiently becoz the processes to support these jobs have been increased now.

Complete mechanism is available here ::

http://wiki.sdn.sap.com/wiki/display/BOBJ/DegreeofParallelism

Regards,

Arpit

[Former Member]

Each Data Flow will initiate threads depending on the number of objects used inside. DOP helps each thread to process on a different CPU in the computer. If you set DOP = 2, a query transform used inside the Data Flow will be split into two logically while running and will be processed parallely. This makes the transformation / data flow faster. You have to take care of other parameters like source/target table partitioning and parallelism of functions to make use of this feature effectively.