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

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
dsfan
Participant
Posts: 17
Joined: Tue Nov 16, 2004 11:16 pm
Location: chicago

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

Post 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
T42
Participant
Posts: 499
Joined: Thu Nov 11, 2004 6:45 pm

Post 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.
Post Reply