how to avoid updating rows that have not changed?
487441Jan 24 2007 — edited Jan 25 2007Hi,
I am newbie to OWB.
In my project, most data sources tables don't have reliable timestamp like 'last_update_date' to indicate row changes. So I have to compare the columns in a row to determine if there is a change. If there is no change, I don't want update the row in the target table.
In OWB 10.2, I used "INSERT UPDATE", row-based to update target table. It looks to me that
OWB update all the rows without checking values of columns. When the table is big, it is really time consuming.
In OWB, what's the best way to avoid updating rows that have not actually changed?
Regards,
Haijun