Target <target name> Warning: Primary key table for Foreign key <foreign key port name> is not from the same active source or transaction generator. This constraint will not be enforced; as a result, the session may hang because of potential deadlock.
The mapping writes to target tables that have a primary key-foreign key relationship, but the targets receive data from different transaction generators, such as a Transaction Control transformation, or active sources. The Integration Service cannot enforce the primary key-foreign key relationship. The session might hang depending on the source data.
If the session hangs, design the mapping to enforce constraint-based loading. Or, remove the primary key-foreign key relationship between the targets in the target database.
