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 lookups in PX
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 27
- Joined: Tue Nov 02, 2004 5:34 pm
Range lookups in PX
Thanks,
Ramesh
Ramesh
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.