Considerations for Deleting Data

Keep the following in mind when you delete data in Data 360.

• You can delete a streaming data transform at any time.
• Deleting a streaming data transform doesn’t affect its source or target objects. Data that was written to the target object remains in the target object.
• If multiple streaming data transforms read from the same source and write to the same target, filtering conditions can be overridden. If a transform contains a WHERE clause and others don’t, the unfiltered source data enters the target. If the data source updates and there are changes to corresponding rows in the target that no longer meet the transform’s WHERE criteria, then the results from the earlier transforms are removed from the target.
• You can delete ingested data in a source object by submitting the records to delete through the data stream. For more information, see Delete Ingested Records in Data 360.
• If an existing record in a source object is updated so that it no longer matches the WHERE filter, that record is deleted from the target object.
• When multiple data transforms write to the same target object, a record isn’t deleted until all data in fields other than the primary key field is deleted. When only the primary key remains, the record is deleted.
• Duplicate primary keys in the source object cause unexpected behavior.