Table Lookups

The Table Lookup faker allows you to search for and use existing values from another table or virtual table.

Faker Configuration

• Value Source Column: Select the source column from which to fetch values (e.g., BusinessEntityID).

• Reference Lookup Column: Define the reference column used for lookup (optional).

• 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.

Source Selection Options

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

• Table Name: Choose the table from which to fetch the lookup values.

• Value Lookup (Mapping): Select the column used for value lookup.

• Value Reference (Display): Select the display column that references the value.

Example Configuration

1. Faker Configuration:

   • Type: int

   • Faker: Table Lookup

   • Value Source Column: BusinessEntityID

   • Reference Lookup Column: Optional, set to N/A if not used.

   • Add Suffix: Optional

   • Replace only if Non-Null: Based on your requirement

2. Source Selection:

   • Source Type: SQL Table

   • Table Name: Select the appropriate table (e.g., Person).

   • Value Lookup (Mapping): Choose the column for value lookup.

   • Value Reference (Display): Choose the column for display reference.

By configuring these options, the Table Lookup faker will search for an existing value using display/value members from another table or virtual table, ensuring data consistency and integrity within your DataFakery Studio project.