Saturday, November 17, 2007

NEXTVAL port of a Sequence Generator

Can the NEXTVAL port of a Sequence Generator transformation be connected to the PRIMARY KEY column of two different target table definitions in a mapping? Assume that the two definitions represent different physical tables on the database server.

Choose Answer

Yes, always.
Yes, but only if the two tables share a primary - foreign key (referential integrity) relationship.
No, because the Sequence Generator produces unique values (within the selected range) and this would result in a unique constraint error (duplicate key values) in one or both of the tables.
No, this is not allowed in the Mapping Designer.