Range look up for timestamp fields.

[kollurianu]

Hi all,

I am trying to range look up..on the reference link..

My input source column is updatetimestamp field looking up between mintimestamp and maxtimstamp fields in the reference getting the datadate value..

Range expression is as below.. the job is running but not correctly the datadate value is same for all input.updatetimestamp field values..

input.updatetimestamp >= ref.mintimestamp and
input.updatetimestamp < ref.maxtimestamp

did put peek stage and in the peek output input value is changing for rows but the ref values mintime and maxtime is same for all the rows.. so we are getting one datadate values for all the rows..

Anythoughts.. , please

[kollurianu]

Below is peek o/p

Peek_422,0: MINIMUM_TIMESTAMP:2004-01-18 15:12:37 MAXIMUM_TIMESTAMP:2004-01-21 11:58:13 UPDATE_TIMESTAMP:2013-07-02 01:51:08.028874
Peek_422,1: MINIMUM_TIMESTAMP:2004-01-18 15:12:37 MAXIMUM_TIMESTAMP:2004-01-21 11:58:13 UPDATE_TIMESTAMP:2013-07-02 01:51:08.028874
Peek_422,0: MINIMUM_TIMESTAMP:2004-01-18 15:12:37 MAXIMUM_TIMESTAMP:2004-01-21 11:58:13 UPDATE_TIMESTAMP:2013-07-13 04:26:58.472317
Peek_422,0: MINIMUM_TIMESTAMP:2004-01-18 15:12:37 MAXIMUM_TIMESTAMP:2004-01-21 11:58:13 UPDATE_TIMESTAMP:2013-07-13 04:26:58.472317

[ray.wurlod]

What did you expect to get?

[kollurianu]

Thanks Ray..

Update timestamp should be in min and max times range..