Need to find sum(sal) for all the active employees

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

jwiles
Premium Member
Premium Member
Posts: 1274
Joined: Sun Nov 14, 2004 8:50 pm
Contact:

Post by jwiles »

Once in a while sounds about right :)
- james wiles


All generalizations are false, including this one - Mark Twain.
praveenk
Participant
Posts: 18
Joined: Sat Jan 15, 2011 11:31 am
Location: HYDERABAD

Post by praveenk »

jwiles wrote:Click on the Output->Columns, then right-click on the generated column select Edit Row...

Generator->Algorithm

Choose your type. The algorithm types available vary depending on data type. For char/varchar and this job, I would choose Cycle and give it only one value to cycle through. The other type is Alphabet and you provide a string of characters for it to cycle through (again, for this job just enter one character). Other data types should be self-explanatory.

Regards,
Thanks james i got it
Praveen
Post Reply