Tags for sample
Get n random records where n is stored in a table
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.,
sample RANDOM dynamic random sample
Dynamic value for SAMPLE RANDOMIZED ALLOCATION
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?
dynamic SAMPLE RANDOMIZED ALLOCATION sample
Repeatability of random sampling
We use SAMPLE RANDOMIZED ALLOCATION to generate random samples for a monthly survey that we operate.
RANDOM sample
MultiLoad Notify Exit Routine issues in 14.00 and 14.10
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.
multiload notify 14.00.00 14.10.00 sample v_tools
Sampled Stats vs Time trade-off
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  
stats sample statitics
Sample database
Hello,
database sample schema
Move a subset of Records
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?
archive arcmain sample