Range lookups in PX

rkacham_DSX · Post by **rkacham_DSX** » Thu Mar 01, 2007 9:22 am

Hi,

as we can do range lookups in server job using odbc/oracle stage can we do range lookups in px.how is the performance.

select col1 where col2 >=? and co3<=? ?* this in server*/
is there any suggestion to do range lookups in datastge px,

thanks for the help

us1aslam1us · Post by **us1aslam1us** » Thu Mar 01, 2007 11:36 am

Range lookup is not available in your version but there are some alternative methods which have been disscussed here before. Do an exact search on "Range Lookup" you might get some

's

pbatchu · Post by **pbatchu** » Thu Mar 01, 2007 12:22 pm

Range Lookup is available in Datastage 8 (aka HAWK release)

DSguru2B · Post by **DSguru2B** » Thu Mar 01, 2007 4:59 pm

Range lookups are not present even in server jobs. What you are referring to is doing range lookup against a database table. That is possible anywhere you can run a sql query. Hence it is possible in px as well. As noted, in 8.0, there is a seperate stage to do that, even when the data is not in a database table.