Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 11 Jul 2005 @ 22:06:52 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Question regarding Selection limits
From:   Mike Felts

  and then I'm asked to "back-fill" the data with a random sample of the remaining available records until I hit the 500,000 targeted records.  

One thing I haven't seen addressed by others as of yet... If you just use a SAMPLE from your original data set, you'll get completely random records and thus you would more than likely end up getting the same record twice, once in your original selection criteria and once in your random SAMPLE dataset. There are ways around it, but I wanted to make sure you were aware...


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023