Red Gate forums :: View topic - SQL Data Generator 3 not generating random data
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 3
SQL Data Generator 3 forum

SQL Data Generator 3 not generating random data

Search in SQL Data Generator 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
sbendayan



Joined: 20 Feb 2014
Posts: 1

PostPosted: Thu Feb 20, 2014 10:58 pm    Post subject: SQL Data Generator 3 not generating random data Reply with quote

Greetings,

I was trying to generate some random test data for a BI solution (star schema) which had 1 fact table and about 7 dimensions. The generator was generating random data for all but 2 of the dimensions; those 2 dimensions were getting the same single value over the entire generated data set.

I tried playing with the randomization settings but no matter which setting I used ("All key values unique", "Repeat key values between 1 and 10 times", "Repeat key values at random") I would always only get a single value for these 2 dimensions.

Is there a way to get around this so that we get random values for all the dimensions?

Thanks,

SB
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6641

PostPosted: Mon Feb 24, 2014 9:59 am    Post subject: Reply with quote

Hi,

I am not exactly sure what outcome you are getting based on the way you describe the problem, but maybe it helps to know that when you use an int generator you will get the same sequence of numbers every time, unless you change the seed setting for that columns's int generator. Computers don't really have a concept of random numbers and changing the random seed is the way to change the sequence.

It may also be an FK issue - you have a primary key with 10 values and the dependent FK column has to repeat those values over and over again.

We really need a description of what you are seeing, what you expect, and a rough idea of the schema to get it doing what you want.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group