Data Generator: Populating multiple tables with same values
-
- Posts: 1
- Joined: Mon 23 Jan 2017 16:32
Data Generator: Populating multiple tables with same values
I need to generate the same key column data for each of three tables. These four key columns are used to join all three tables. How can I get Data Generator to populate the same key values for all three tables in the same generation load?
Re: Data Generator: Populating multiple tables with same values
If the tables are linked with a foreign key, you have to select a needed generator for the parent table, whereas the 'Foreign Key' generator for the referencing tables.
If the tables are not linked between each other, you have to select the same generator for all key columns
and specify identical values for the "Random by Seed" field, for example, =1, for the generators in key columns.
If the tables are not linked between each other, you have to select the same generator for all key columns
and specify identical values for the "Random by Seed" field, for example, =1, for the generators in key columns.