When you create an entity, the entity creation process creates the data model based on the constraints you enable. If the constraints are not correctly enabled, then the data in the entity might not be archived correctly. For example, you archive an entity with a table that contains multiple paths to the driving table. When you archive the entity, you might encounter the following issues:

The archive job archives records more than once.
The Delete from Source step fails.

To avoid these issues, verify that the constraints for each table you plan to include in the entity are correct. If you have a child table related to more than one parent table, you must define the constraint conditions to specify the rows that belong to that relationship. After you verify that the constraints are correct, create the entity.