Search found 3 matches

by pprakash
Fri Oct 26, 2012 6:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to remove leading zeros for decimal values
Replies: 5
Views: 5850

Re: how to remove leading zeros for decimal values

For the posted example: value 0000001.00000009 If we want the output as 1.00000009 the solution is given below with the logic; USE THE LOCIG AS BELOW: (By using String function DecimalToString we can get the solution) Field(DecimalToString(InputLink.xyz,"suppress_zero"),".",1):&q...
by pprakash
Mon Sep 03, 2012 2:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: generating seq nos
Replies: 10
Views: 6316

[quote="Scope"]Try this.
by pprakash
Mon Sep 03, 2012 1:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate key using only one instance.
Replies: 4
Views: 4302

Just want to add, how "Round Robin Partition" works with the logic below; This will work! @PARTITIONNUM + (@NUMPARTITIONS * (@INROWNUM - 1)) + 1 i tried with 3 nodes by with 'Round Robin Partitioning'(there are 9 records). Please find the detailed below; ====> @PARTITIONNUM + (@NUMPARTITIO...