Red Gate forums :: View topic - Idea: Generate from column
Return to www.red-gate.com RSS Feed Available

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

Idea: Generate from column

Search in SQL Data Generator 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
danfountain



Joined: 25 Jun 2012
Posts: 7

PostPosted: Tue Oct 22, 2013 10:12 am    Post subject: Idea: Generate from column Reply with quote

Hi,

I have some tables that are not normalised correctly due to being denormalised for OLAP reasons.

So basically i would like to see a way that you can generate for instance a company name, but base it on the data already in the column. Some from of obfuscation. That way the column will still match for all the instances of the same thing.

Many thanks for your products.

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



Joined: 23 Aug 2004
Posts: 6589

PostPosted: Wed Oct 23, 2013 12:07 pm    Post subject: Reply with quote

Hi Dan,
This should be possible in the next data generator release (v3?). It's been a very popular suggestion to base data in one column from another generated column. For this you will be able to use a CSV of existing data or a Python script for data manipulation. Version 2 introduced Python scripts for manipulating generated data but the ability to retrieve data from another column of generated data does not exist in that version. The only immediate workaround is to compile and add a very complicated Ruby generator to SDG.

Unfortunately I don't have a firm release date for the next version as yet.
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