Archives of the TeradataForum

Message Posted: Mon, 18 Aug 2008 @ 22:06:19 GMT

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

You can achieve using Sample function.

     Select * from dbname.tablename sample .30;

This would return you 30% of data from our source table. If the number of records are very less then probably you use SQL Assitant's export/Import utility and achieve it. If the number of records are more then probably you need to wirte a fast export/import script.

Thanks,

Rakesh Saxena.

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