I need to publish a subset (on a Sybase ASE environment...).
Normaly, i use a "truncate" action on the target table, before publishing to avoid trouble on duplicate keys...
But, on a new case; i can´t delete the data on target table, because it´s a domain table that other systems look at.
How can i just insert the new data from source, avoiding the usual "delete and insert" actions?
Is there any way to do that?
While publishing the data, you can select the option on what you want to do if you encounter duplicates in the data target, you can choose to update the value if it already exists or just continue without updating.
I will try that!!!