Page 1 of 1

how to add a row as a last row for each partition

Posted: Mon Nov 22, 2004 6:04 pm
by dsfan
hi guys,
iam working on a parallel job in which i have to add a row generated using row generator to each partition of n records. i have developed using the following stages.
rows
--------> funnel <---------- row generator. i have to add the row generated using the row generator to the last row of each partition of rows coming to the funnel stage.
thanx in advance,
r.k

Posted: Mon Nov 29, 2004 9:55 pm
by T42
Here is what I think you are trying to do: You are attempting to generate a record for each DataStage EE's partition.

I'm sorry but you can not do that as easily as you think you could.

Hypothetically, it could be done with a custom stage, but that would require some extensive research (or some high paying consultants with a lot of time on their hands) to arrange.

What is your business objective? Once we know that, we could probably propose a better alternative.