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