Foreign Keys Generator

Uses an existing primary key of a table or virtual table

Faker Configuration

• Source: Define the source of the foreign key values. In this example:

  • Source Type: Select the type of source (e.g., SQL Table).

  • Table Name: Choose the table from which to fetch the foreign key values (e.g., Person).

  • Value Lookup (Mapping): Select the column used for value lookup and mapping (e.g., FirstName).

• Add Suffix: Enter any additional suffix to append to the generated data (optional).

• Replace only if Non-Null: Check this box to ensure that the faker only replaces non-null values in the column. If unchecked, it will replace all values, including nulls.