Interview Questions   Tutorials   Discussions   Programs   

Teradata - How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?




1787
views
asked mar September 20, 2014 06:38 AM  

How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?


           

1 Answers



 
answered By vishnoiprem   0  
In .IMPORT command in Mload we have a option to give record no. from which processing should begin. i.e. ‘FROM m’ ‘m’ is a logical record number, as an integer, of the record in the identified data source where processing is to begin. You can mention ’m’ as 2 and processing will  start from second record.

THRU k and FOR n are two options in the same Mload command, functions same towards the end of the processing.

Adding to the above, if from n"start record" and for n "stop record" are not mentioned, mload considers records from start till the end of the file.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert