Seeds don't generate the same data when used with different Repeating Keys

TrishTrish Posts: 3 New member
edited March 22, 2018 10:18AM in SQL Data Generator
Hello,

I'm hoping you can explain to me what I'm doing wrong.  This my setup:

5000 rows are being generated for Table A
1000 rows are being generated for Table B, which has a foreign key to Table A
2000 rows are being generated for Table C, which also has a foreign key to Table A

If any of the 2000 rows in Table C reference a row in Table A which isn't also referenced in Table B - I get an exception.  N.B. Why Table C doesn't just have a reference to Table B I don't know and I can't change.

So I set it up so:
Table B generates references to Table A using a seed and set it to Repeat Key values between 1 and 1 times.
Table C generates references to Table A using the same seed and set it to Repeat Key values between 2 and 2 times.  This isn't perfect in terms of distribution of data (I'd like between 1 and 4 references to table A) but it would do.

I would expect (as I'm using the same seed) the data to be generated as:

Table B - 5, 12, 46, 34, 17....
Table C - 5, 5, 12, 12, 46, 46, 34, 34, 17, 17....

Except what I actually get is two completely different sets!  If I set both to Repeat Key values between 1 and 1 times (so I only generate 2000 rows for Table C) then the sets are the same.

What do I need to do?

Thanks,
Trish
Sign In or Register to comment.