Red Gate forums :: View topic - Existing Data Source - Specify number of rows
Return to www.red-gate.com RSS Feed Available

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

Existing Data Source - Specify number of rows

Search in SQL Data Generator 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
lvdancerdave



Joined: 12 Dec 2013
Posts: 2

PostPosted: Thu Dec 12, 2013 8:30 pm    Post subject: Existing Data Source - Specify number of rows Reply with quote

Still new to this tool. When setting up an existing data source for a table, there is the option "Specifiy number of rows by:" with several options, but I am having trouble finding documentation on the behavior of these values. If you select Numeric Value=1000, would you get the first 1000 rows of the source table or a random sampling? How does Proportion of Table work?
_________________
David Burt
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 925
Location: Red Gate Software

PostPosted: Mon Dec 16, 2013 3:23 pm    Post subject: Reply with quote

Thank you for your forum post.

You ask an excellent question and our documentation does not have any information on this. To answer your questions:

Quote:

If you select Numeric Value=1000, would you get the first 1000 rows of the source table or a random sampling?

It is my belief that the product would select the first 1000 rows if there are over 1000 rows of data in the table selected as the data source.

Quote:

How does Proportion of Table work?


The tool tip help contains this information:
Quote:

If you have selected Proportion of table to define the number of rows to be generated, SQL Data Generator counts the number of rows in the table of reference, and then calculates the specified percentage of this count.

For example, if your specified table of reference contains 1000 rows, and you specify a percentage value of 75, SQL Data Generator will generate 750 rows for the table that is being populated.


I believe that the product using the example in the tool tip help would select the first 750 rows of data.

I will submit a request request to improve the documentation with regards to your questions and obtain confirmation of my answer.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Brian Donahue



Joined: 23 Aug 2004
Posts: 6649

PostPosted: Mon Dec 16, 2013 3:25 pm    Post subject: Reply with quote

Hello David,

It looks pretty simple - when you select a potion from another table, it simply selects the top x number of records. If it needs to randomize the results it does so in memory - the SQL Profiler trace clearly shows it's getting the top x from the other table.

Proportion of table just lets you choose a second (reference) table, counts the number of records from it, and does a percentage on that and selects the top x records from the source table again (where x is the row count from the reference table divided by the percentage you had specified).
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 925
Location: Red Gate Software

PostPosted: Mon Dec 16, 2013 4:12 pm    Post subject: Reply with quote

Hi David

I have submitted Feature Request SDG-1046 for the Product Manager and Development Team to consider, for adding additional information to our help documentation. In particular when selecting an existing data source for the Specifying number of rows option and the drop down selections:

Numeric value
Proportion of table
Generation Time
Same as mapped data

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
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