Using query, you can limit with where and qualify and even row_number based on your requirements.
I think you can elaborate your requirements more :). Teradata has bteq ( import, export), mload ,fastload,tpump, fastexport to export data to file, tpt( stream,update,load).
You can specify checkpoints for interval loads.
Thanks for the reply. The issue is that we have large volume of data in the view and when we are running the query in Teradata assistant or using Bteq, we are getting Spool space error.
I found one option to get data in chunks. The option is to use MOD on Time period column to limit the number of rows.
However, I may have to repeat the query 'n' no. of times where 'n' is no. of months.
Let me know if you have any better solution.