How to fetch packets of records and process them in Teradata
I have a very urgent requirement.
There are some millions of records in one of my Teradata tables.Now I need to process these records by fetching 10000 records at a time. For example- say in the first pass I pick up 10000 records and put them in a flat file,process it. Then in second pass pick next 10000 records put in a flat files process it and so on until all my records in the table gets processed.
Any solution to this problem would be really helpful.