Hi
a stored procedure in sybase returns a result set. when u take Sp as ur datasource, u have to map the result set to the columns in teh datawindow. Rest all is taken care by the DW.
if anyone knows how to use a SP as a data source in Oracle, Kindly do let me know.