Page 1 of 1

Row Generator Stage

Posted: Fri Jun 14, 2013 12:43 pm
by nvalia
Hi All.
We are on DS 8.7 on Windows 2008 R2

If we use a Row Generator in a 2 Node Configuration setting and set the Number of Records =1, will it generate 1 record per partition (i.e total 2) or only 1 record on any 1 partition, sequential execution?

Thanks,
NV

Posted: Fri Jun 14, 2013 1:13 pm
by jwiles
The number of rows you provide is per-node.

Total Rows Generated = Number of Rows Requested * Number of Nodes that RG executes on.

If RG is sequential (which is the default):
1 * 1 = 1

Regards,

Posted: Fri Jun 14, 2013 1:14 pm
by jwiles
The number of rows you provide is per-node.

Total Rows Generated = Number of Rows Requested * Number of Nodes that RG executes on.

If RG is sequential (which is the default):
1 * 1 = 1

Regards,

Posted: Fri Jun 14, 2013 1:24 pm
by nvalia
So in a 2 Node Config RG executed Sequentially by Default will still generate 2 Rows even if the Number of Records = 1

1 * 2 = 2 ?

Posted: Fri Jun 14, 2013 1:28 pm
by jwiles
No. If RG is executing sequentially, that means that it is executing on ONE node.

1 row * 1 node = 1 total rows