Repeatability of random sampling

Database

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

Tags (2)
1 REPLY
Senior Apprentice

Re: Repeatability of random sampling

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.