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 are the various indexes in teradata?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What happens in a conflict? How do you handle that?
how can we analyze the locks ?
What is meant by Teradata Gateway?
How to find duplicates in a table?
What is bteq utility in teradata?
What do you mean by teradata intellicloud?
What are types of partition primary index (ppi) in teradata?
Explain the term 'primary key' related to relational database management system?
What are aggregate tables? How do you design them using teradata?
How does hashing happens in teradata?
Why do you get spool space errors? How do trouble-shoot them?
What are the available primary index types in teradata.
How do you set the session mode parameters in bteq?