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 a three-tier data warehouse?
Write a program to show the parser component used in teradata?
List the logical and conditional operators that are used with teradata along with their meanings?
What is the purpose of joins in teradata?
What is dimensional modeling?
What do you mean by fastexport in teradata?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Explain fallback in teradata?
What is bteq script in teradata?
What is teradata?
what is object level locking ? where do appear this type of locking ?
Comment whether bottleneck is an error or not.
Explain BYNET.
What is upsert statement in teradata?
Can we collect statistics on multiple columns?