All Forums Database
ChrisAL 1 post Joined 08/14
10 Aug 2014
Repeatability of random sampling

We use SAMPLE RANDOMIZED ALLOCATION to generate random samples for a monthly survey that we operate.
Our auditor has asked us if we have the ability to reproduce the sample if required - I think this would usually be done by capturing and reusing the random seed value that was initially used, but I can't find any mention of such a capability in the Teradata manuals.
 
Could anyone cast any light on this subject please?
 
Thank you

dnoeth 4628 posts Joined 11/04
11 Aug 2014

There's no random seed, if there's only a single row inserted/deleted/updated it would be impossible to repeat that sample.
The only way is materializing the result of the sample select in a table.

Dieter

You must sign in to leave a comment.