Page 2 of 2
Posted: Fri Feb 01, 2013 3:30 am
by srinivas.nettalam
times29 wrote:
any idea what can i do to make it unique
To get unique sequence number across, the formula is
Code: Select all
[@PARTITIONNUM + (@INROWNUM-1)*@NUMPARTITIONS]+1
Posted: Fri Feb 01, 2013 4:27 am
by ray.wurlod
"a" formula (not "the" formula)
Square brackets are not supported in expressions in DataStage, though your intent is clear.
Posted: Fri Feb 08, 2013 7:23 am
by william1111
Hi,
To maintain Unique values, You should run your transformer in Sequential mode. Change Parallel to Sequential mode for only Transformer in Your Job.
Thanks,
William
Posted: Sat Feb 09, 2013 3:56 am
by ray.wurlod
Welcome aboard. The formula using system variables is guaranteed to generate unique numbers irrespective of the number of nodes.
You could even add a job parameter with the starting value.
Posted: Sun Feb 10, 2013 11:34 am
by 123gopal
in ds7.5 transformer can be use seconds from time(time) functions and date and time funtions are available