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
Difference between star and snowflake schemas?
What are the enhanced features in teradata v2r5 and v2r6?
What are the various etl tools in the market?
How many sessions of MAX is PE capable of handling at a particular time?
Explain and compare pros and cons of snow flake schemas?
How do you do backup and recovery in teradata?
What is partitioned primary index (ppi)?
What are the functions of a teradata dba?
List out some of the primary characteristics of teradata.
What is the use of having index on table?
What are the commands to make a new table, change a table and remove a table in teradata?
Describe the between keyword in teradata?
Explain the types of join supports by teradata?
What are the different table types supported by teradata?
What is a clique?