DSXchange

Hi,
Right now i am using Currenttimestamp() in transformer for date i need to change that to current date + different second for each row, stating at 00:00:00

example: 500 records created, TimeStamp content would be :
2012-01-15 00:00:00
2012-01-15 00:00:01
2012-01-15 00:00:02
2012-01-15 00:00:03
....
2012-01-15 00:08:20

who can i modify Currenttimestamp() to do that.

Thanks

Use "DSJobStartTimestamp", which remains the same for each row.
Derive the new timestamp with the formula Note that if the value has to be unique then, if you run on more than one node, you will have to adjust the algorithm.

Don't like TimeOffsetBySeconds(DSJobStartTimestamp,1) in transformer

You probably don't like CurrentTimestamp() either, because it returns the current timestamp (that is, "now") whether or not another record is being processed.

I have some DataStage jobs processing over a quarter of a million rows per second on a two-node configuration. "Now" will be the same for each quarter of a million rows, with "second" as the granularity of the current timestamp.

Even setting the granularity to microseconds isn't going to help; "now" will be the same for more than one record. And that assumes that the underlying operating system can deliver quanta as short as 0.000001 second. Most cannot.

Arnd's response was, to me, perfectly sensible. If you don't like that, you're going to have to write your own function, and reinvent the meaning of "now".

My mistake, instead of "1" use "@INROWNUM" - sorry.

Irrespective of the real writing time, do you need to increase 1 sec for each row?

Yes

Then use Arnd's solution. Job start timestamp + @INROWNUM seconds. It will give you exactly what you've specified whether or not you happen to like it.

Transformer didn't likeTimeOffsetBySeconds(DSJobStartTimestamp,@INROWNUM) i don't see
function TimeOffsetBySeconds under date&time can that be issue

Look for similarly-named functions, maybe TimestampSinceFromSeconds(). We often post without access to the software; at the moment I'm in a hotel room.

TimeOffsetBySeconds() is perfectly valid. What exact version are you on?

Below logic gives me results like below so in some cases i am getting same timestamp and some cases its unique.


"01/29/2013 21:51:20",
"01/29/2013 21:51:21"
"01/29/2013 21:51:22",
"01/29/2013 21:51:20",

TimestampToString(TimestampFromSecondsSince(@INROWNUM,DSJobStartTimestamp),"%mm/%dd/%yyyy %hh:%nn:%ss")

Since the job runs in parallel @INROWNUM can have same rownumber on each node.Probably this is the reason.Not sure.

any idea what can i do to make it unique

Run on a single node, or generate numbers that are unique across the domain. Search DSXchange for techniques and formulae.