Radha

• Sep 7th, 2006

 

Oracle OCI:       

?         We can write the source query in this stage but we can?t write lookup query in this stage instead of this we are using hash file stage for the lookup.

?         We are having the facility to write multiple queries before (Oracle OCI/Output/SQL/Before) or after (Oracle OCI/Output/SQL/After) executing the actual query (Oracle OCI/Output/SQL/Before)

?         We don?t have multi-row lookup facility in this stage.

 

ODBC:             

?         We can write both source query as well as lookup query in this stage itself

?         We are not having the facility to write multiple queries in this stage.

?         We are having the multi-row lookup facility in this stage.