change current date + different second for each row

[srinivas.nettalam]

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

[ray.wurlod]

"a" formula (not "the" formula)

Square brackets are not supported in expressions in DataStage, though your intent is clear.

[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

[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.

[123gopal]

in ds7.5 transformer can be use seconds from time(time) functions and date and time funtions are available