Inserting, updating, and deleting data in a federated system

During the development of your federated environment, whether you modify remote information or move data among data sources, you must insert, update, and delete data on your data sources.

Before you modify data on a remote data source, ensure that you have the appropriate authorization privileges to issue the INSERT, UPDATE and DELETE statements on the nickname. You should also have an understanding of referential integrity, preserving statement atomicity, and assignment semantics.