Newbie question

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

Newbie question

Postby joeybagdnts » Thu Apr 14, 2011 6:26 pm

Hi

Love your products! Have a question about generating data
I have 3 fields in a table I wish to populate with data

FK to another table --> will use the fk generator generating the value 1 - 20 times (there are at least 5000 rows in the referenced table)
YEAR --> value must be between 0 and 9
AMT

There is a unique contraint on the the combination of the FK and the YEAR fields. I want to generate 5000 rows. When I use the int generator and give it the values between 0 and 9, I will only end up with 10? rows in my table. Is there a way to get Data Generator to generate this?


The results should look similar to :

    BI_ID YR AMT
    10082 0 220
    10083 0 700
    10084 0 555
    10081 0 125
    10085 0 325
    10086 0 425
    10087 0 525
    10088 0 625
    10089 0 333
    10090 0 103
    10096 0 8
    10012 0 0
    10016 0 0
    10081 1 150
    10085 1 350
    10086 1 450
    10087 1 550
    10088 1 650
    10089 1 333
    10090 1 105
    10091 1 1016
    10092 1 1382
    10093 1 529
    10094 1 203
    10095 1 203
    10096 1 8
    10013 1 0
    10012 1 0
    10016 1 0
    10019 1 0
    10082 2 275
    10083 2 700
    10084 2 555
    10081 2 175
    10085 2 375
    10086 2 475
    10087 2 575
    10088 2 675
    10089 2 333
    10090 2 107
    10091 2 1368
    10092 2 1856
    10093 2 635
    10094 2 196
    10095 2 195
    10096 2 25
    10100 2 2
    10101 2 0
    10082 3 275
    10083 3 700
    10084 3 555
    10081 3 175
    10085 3 375
    10086 3 475
    10087 3 575
    10088 3 675
    10089 3 333
    10090 3 107
    10091 3 1468
    10092 3 1956
    10093 3 735
    10094 3 296
    10095 3 295
    10096 3 8
    10097 3 105
    10098 3 100
    10100 3 2
    10001 3 0
    10321 3 0
    10322 3 0
    10082 4 250
    10083 4 700
    10084 4 555
    10081 4 150
    10085 4 350
    10086 4 450
    10087 4 550
    10088 4 650
    10016 4 0
    10019 4 0
    10020 4 0
    10082 5 220
    10083 5 700
    10084 5 555
    10081 5 125
    10085 5 325
    10092 5 789
    10093 5 342
    10094 5 184
    10095 5 132
    10096 5 8
    10012 5 0
    10016 5 0
    10019 5 0
    10325 5 0
    10321 5 0
    10322 5 0
    10081 6 100
    10085 6 300
    10086 6 400
    10087 6 500
    10088 6 600
    10089 6 333
    10090 6 101
    10091 6 423
    10092 6 549
    10096 7 0
    10012 7 0
    10322 7 0
    10020 8 0
    10313 8 0
    10316 8 0
    10315 8 0
    10317 8 0
    10321 8 0
    10322 8 0
    10321 9 0
    10322 9 0
joeybagdnts
 
Posts: 6
Joined: Thu Apr 14, 2011 6:13 pm

Postby james.billings » Mon Apr 18, 2011 3:08 pm

I've had a little play around with this and sort of got it to work - for my FK column it's set to repeat the values between 1 and 10 times (I have 5000 rows in the related table, and I'm wanting to generate 1000 rows for the table in question).
For the YR column it's set to INT, min value of 0, max of 9, and "Set Unique" OFF. The Distribution is "Sequential".

This generates 1000 rows with each BI_ID repeated while the YR goes up 0 > 9, then it moves on to the next BI_ID value and so on.

I wasn't sure you could get it to do it more randomly, but as a quick test, I changed the FK option to repeat key values at random, and it still seemed to generate 1000 rows OK.

If you're still having trouble, perhaps you could post (or mail to support with F006889 in the subject line) a create script for the table (along with the related ones) and I can look into it a little more.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests