Best Practice on Specify Copies vs Distribute Rows to two similar shapes?

[zoomingrocket]

Hi Team,

Usecase: Oracle table insert, to increase throughput, we were wondering if we can increase copies to 2 of insert table shape, and the incoming stream of rows will be distributed across 2 threads, or should we copy the shape on canvas and create a hop to both from prior shape with distribute rows as the hop option?

Is there any difference, first of all, between specify copies vs distrbution approach, and if not, is one preferred over the other?

Thanks in advance!

[bamaer]

The result of multiple copies with distribute rows vs specfy copies will be the same, so the specify copies option is cleaner.
Whether that works or not with table output depends on the databaae and JDBC driver. It's been ages since I used Oracle, don't remember if that works or not, just give it a try.