May 6, 2011 at 9:41 am
Hi,
I am looking for a way to increase the amount data in AdventureWorksDW FactInternetSales and FactResellerSales tables. My goal is to randomly increase the data by a couple of million rows while randomly distributing the dimension keys as well. Also the dimension tables will remain the same but I just need to randomly expand the fact tables.
Thanks for your help.
MCTS: BI 2008, MCITP: BI 2008
Stay Thirsty My Friends
May 6, 2011 at 10:18 am
You can use this to generate the data.
http://www.red-gate.com/products/sql-development/sql-data-generator/
Or you can do it manually using this exemple :
http://www.sqlservercentral.com/articles/T-SQL/68467/
Go to the section called "Populate the Test Table with Randomized Data".
Option 2 is a little more work but you'll have 100% control over that one.
May 6, 2011 at 11:58 am
Ninja's_RGR'us (5/6/2011)
You can use this to generate the data.http://www.red-gate.com/products/sql-development/sql-data-generator/
Or you can do it manually using this exemple :
http://www.sqlservercentral.com/articles/T-SQL/68467/
Go to the section called "Populate the Test Table with Randomized Data".
Option 2 is a little more work but you'll have 100% control over that one.
Thanks, this is exactly what I needed.
MCTS: BI 2008, MCITP: BI 2008
Stay Thirsty My Friends
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply