You can change the seed value for a column to produce repeatable results if the same source value occurs in a different column. Configure repeatable results when you want to maintain a primary key-foreign key relationship between two tables. In each rule, enter the same seed value for the primary-key column as the seed value for the foreign-key column. The
PowerCenter Integration Service
produces deterministic results for the same numeric values. The referential integrity is maintained between the tables.