0 - 7 of 7 tags for sample

I have a table TXN that has Transaction_ID and Store_nbr. Suppose also that I have a table SAMP that has Store_nbr and n_samples.
Suppose I want to take a sample of n_samples Transaction_IDs from TXN. I.e., I want the SAMP table to be able to drive how many transaction_id samples are taken from the TXN table. E.g.,

I'm trying to input a dynamic value for SAMPLE RANDOMIZED ALLOCATION as in the example below. This produces an error: expected something like an integer or a decimal number...
Is there any way to input a dynamic value in this case?

We use SAMPLE RANDOMIZED ALLOCATION to generate random samples for a monthly survey that we operate.

The Teradata MultiLoad Notify Exit Routine has some issues in the 14.00 and 14.10 releases because of enhancements to the MultiLoad notify events logic. This document discusses the enhancements and issues in detail.

Our Goal is we need to minimize collect sats time:
we do use Combination for Full / Sample stats based on Row size:
- Smaple 50% for all table's statitics combination for tables  > 5 Billion Rows
- FULL for all table's statitics combination for tables  < 5 Billion Rows
 

Hello,

Hello,

I am trying to set up our Development environment, and would like to take a copy of the Production envirnment and put in in Dev. The catch....I don't want 100% of all records in the tables. I would like only x% to populate the Dev tables.

Does anyone know if there is a way to do this?