general mock (fake) database creation approach ?

Hello, friends and gurus. May I have some advice on general approach you
guys take to generate a mock database with fake data in it?
Thanks
--
SincerelyIf you have real data available, you can scramble the data (especially
names) to make demo data. Otherwise, it's just a lot of work. There are
lots of options. Randomize. Get some other data source and pretend it's
what you want. Refactor census data. Get imaginative.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Frank RS" <FrankRS@.discussions.microsoft.com> wrote in message
news:C2C3586F-FC2F-4476-B1F3-F74265142799@.microsoft.com...
> Hello, friends and gurus. May I have some advice on general approach you
> guys take to generate a mock database with fake data in it?
> Thanks
> --
> Sincerely|||Frank,
I don't know if this will help or not, but what we have found that works
well is use stored procedures that return "fake" data; at least enough to
return data that will suffice for formatting, grouping, etc.
"Frank RS" <FrankRS@.discussions.microsoft.com> wrote in message
news:C2C3586F-FC2F-4476-B1F3-F74265142799@.microsoft.com...
> Hello, friends and gurus. May I have some advice on general approach you
> guys take to generate a mock database with fake data in it?
> Thanks
> --
> Sincerely

Fuzzy Grouping Transform Corrupts Pass-through Data

We are working with a client and are using Fuzzy Group transform for de-duping, and hierarchy creation for a national account list.

I've found that if a large number of pass through columns are sent to the Fuzzy Grouping transforms it randomly corrupts the char columns.

Our work around was to only pass through ID columns and then build out the attributes needed from views against the Fuzzy group output however product team should take a look at this.
By corruption I mean random characters from other records would show up in character columns (we had address and name corruption in about 10% of a 1.5 million record dataset).

Thanks.

Michael Slater
Software Architects

Michael,

Thanks for your post. We have been unable to reproduce the problem you have reported in the new test cases that we have created for this issue. We would very much like to get to the bottom of what you are seeing. Can you please contact me directly so that we might work with you to find a better repro case that can be used to further investigate and fix this problem?

Please send an email to KrisGan@.microsoft.com

Thanks,
Kris Ganjamsql