DSXchange

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

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

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

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.