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?
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.