Alternative to ODBC stage while doing reference lookup
Posted: Wed Aug 31, 2005 1:20 am
Hi
While doing lookup using ODBC stage, we have defined primary SQL something like select a, b, c from tbl
and the reference SQL is something like select * from (select a,b,max(c) from tbl where a=? and b=? and c < ? group by a,b) where rownum < 2
We are facing with performance issue (sometime back we got mutex error too). We are finding an alternative to replace the ODBC stage to overcome the performance issue. Let us know how can we go about it.
We are using SQL Server database.
Thanks
Ahmed Iftikhar
While doing lookup using ODBC stage, we have defined primary SQL something like select a, b, c from tbl
and the reference SQL is something like select * from (select a,b,max(c) from tbl where a=? and b=? and c < ? group by a,b) where rownum < 2
We are facing with performance issue (sometime back we got mutex error too). We are finding an alternative to replace the ODBC stage to overcome the performance issue. Let us know how can we go about it.
We are using SQL Server database.
Thanks
Ahmed Iftikhar