Row Generator Stage

nvalia · Post by **nvalia** » Fri Jun 14, 2013 12:43 pm

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

jwiles · Post by **jwiles** » Fri Jun 14, 2013 1:13 pm

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,

jwiles · Post by **jwiles** » Fri Jun 14, 2013 1:14 pm

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,

nvalia · Post by **nvalia** » Fri Jun 14, 2013 1:24 pm

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 ?

jwiles · Post by **jwiles** » Fri Jun 14, 2013 1:28 pm

No. If RG is executing sequentially, that means that it is executing on ONE node.

1 row * 1 node = 1 total rows