Hi,
Could do this in sql update statment as per below but owb generates merge for updates and cannot match on key and update at same time.
Using oracle 11.2.0.3
UPdate table
set columna = to_date('20/05/2009','DD/MM/YYYY')
where columna = to_date('19/05/2009','DD/MM/YYYY')
What is best way to do this in owb mapping?
Mereg statemnet cannot be generated because column is used for both matching and update
Thanks