Range look up for timestamp fields.
Posted: Mon Nov 18, 2013 10:44 am
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
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