DSXchange

Hi,

Iam using the DRS stage for delete and insert process to oracle table with update action as "Insert New rows Only" .In before tab , i need to delete based upon the incoming values . Is it possible in DRS stage. When i mention harcoded values ,it works properly.Please let me know how to delete based upon incoming values.

It is not possible to leverage any incoming row data in the 'before' or 'after' SQL tabs.

You would need two jobs to achieve this or, perhaps, user-defined SQL to call a stored procedure.

Thanks ray..

It's important to understand here that those areas are only executed once, not per row - hence their name and the problem.