Computed columns

The simplest way to populate your database with test data.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Michelle Taylor, Lionel, Emma A, sherr

Computed columns

Postby HugoKornelis » Fri Aug 02, 2013 11:15 pm

Hi all,

I'm trying to use SQL Data Generator (version 2.0.3.1) to generate extra data for the FactResellerSales table in the AdventureWorksDW2012 sample database. But in order to make it match the pattern of the rest, I find that some features are missing from Data Generator.

One of them is for generating columns that would have been a computed column in an OLTP database. In a datawarehouse, such columns are usually stored as regular columns to get the best possible performance on DW queries.

An example in the table mentioned above is ExtendedAmount - almost equal to UnitPrice * OrderQuantity. I see no way to generate ExtendedAmount values that are actually "correct".

Is there a way to do this with the current product and I just fail to see it? And if not, is there a wishlist where I can add this?

Thanks in advance!
--
Hugo Kornelis
(SQL Server MVP and Friend of Red Gate)
HugoKornelis
 
Posts: 5
Joined: Wed Mar 25, 2009 10:48 am

Postby Brian Donahue » Mon Aug 05, 2013 11:43 am

Hi Hugo,

I'd give you the exact same answer to that as I did to your similar query here: http://www.red-gate.com/messageboard/vi ... hp?t=18089

It would be nice if we supported this but in the meantime, you can use either the Python or Ruby generators.
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Data Generator 2

Who is online

Users browsing this forum: No registered users and 0 guests

cron