How to Skip or Get first and Last Record from Flat File
through MultiLoad and TPUMP Utility?
Answer Posted / milind mane
In .IMPORT command in MLoad we have a option to give
record no. from which processing should begin. ie. ‘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.
| Is This Answer Correct ? | 11 Yes | 4 No |
Post New Answer View All Answers
What is the difference between union and union all in teradata?
What are the different table types supported by teradata?
Describe primary index in teradata. And what are the available primary index types?
What are the various indexes in teradata? How to use them?
How would you load a very large file in teradata in general?
What is the purpose of joins in teradata?
How do you do backup and recovery in teradata?
What is the purpose of joins in teradata and what are the available join types?
What is a level of granularity of a fact table?
Write a program to show the parser component used in teradata?
What is logical data model?
What do you mean by ttu in teradata?
What are the advantages of teradata?
Why do you get spool space errors? How do trouble-shoot them?
What is multi insert?