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
How is the teradata different from oracle?
What are the different softwares used with their functions in teradata?
how many modules are there in telecome domain?how to explain the architecture?
What is the purpose of indexes?
What is the use of fallback?
Where is teradata rdbms used?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What is meant by a Clique?
What is called partitioned primary index (ppi)?
Explain the term 'columns' related to relational database management system?
How do you set the session mode parameters in bteq?
Discuss the advantages of using partitioned primary index in a query?
What is spool space? Why do you get spool space errors?
What are normalization, first normal form, second normal form and third normal form?
Can we collect statistics on multiple columns?