How to Skip or Get first and Last
Record from Flat File through MultiLoad in Teradata?
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
No comments:
Post a Comment