Issue in insert or update process

[xch2005]

Hi,

I am using DRS stage in the target and source is Sybase. The process used in the DRS is insert or update.
Update action (in DRS stage) : Insert new rows or update existing
Design: source -> trn -> target (it is just column to column mapping)

The key columns are selected in target and source but when I run the modified records is inserted in to the table and update does not happen.

The target table (in Oracle) does not have primary keys defined. Does this really need to have the keys defined?

Appericiate your help on this.

Thanks

[chulett]

No, you don't need a "primary key" - what you need is a unique constraint in order for this to work. That constraint could be from a primary key or a unique index and causes the insert to fail which is what triggers the update.