Percentage Sampling
Hello Everyone, As i m using percentage sampling tool in ssis 2005 i m having following queries. 1) Where to use Percentage sampling real life example? 2)How to customize percentage Sampling (I have divide it in 25% so here how can i get rows 4 times )
June 13th, 2011 5:59am

The Percentage Sampling transformation is especially useful for data mining Please check this at James's blog Let us TRY this | Mail me My Blog :: http://quest4gen.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
June 13th, 2011 6:41am

Thanks I have used this example but my query is 1) Where to use Percentage sampling real life example? 2)can i use percentage Sampling (30%+30%+30%+10% )Like this Not like (32%+68%)
June 13th, 2011 7:14am

Thanks I have used this example but my query is 1) Where to use Percentage sampling real life example? 2)can i use percentage Sampling (30%+30%+30%+10% )Like this Not like (32%+68%) 1> we are using this generally data mining (SSAS) project.. (Please read the above msdn link) By using this transformation, you can randomly divide a data set into two data sets: one for training the data mining model, and one for testing the model. 2> why you want to use Sampling (30%+30%+30%+10% ) way.. not sure.. never use such way. Let us TRY this | Mail me My Blog :: http://quest4gen.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
June 13th, 2011 7:31am

1) The more general example would be for testing purposes. You could generate sample data out of this component which represents the original data but not the original data and use it for unit testing. 2) Generally used for Proof of Concept purposes when a code is developed and you need to test this with sample data. The sample data can be generated from this compoenent. 2) For the second you can try out appending one more percentage sampler and go on dividing the result smaller further.Happy to help! Thanks. Regards and good Wishes, Deepak.
June 13th, 2011 7:41am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics