How does OWB handle incremental data loads?
In a mapping each target object can be configured separately with its own incremental data load strategy. The user can choose between a variety of strategies, which include INSERT , UPDATE and INSERT/UPDATE. The latter will first try to insert a record, and if that fails it will update the record. This is done by OWB if the user chooses this strategy. No additional actions are required. In addition to that OWB lets the user configure individual attributes to participate in an update or insert action. This gives the user the flexibility to specify update clauses using any attribute available, without creation of additional constraints.
