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


Please Help Members By Posting Answers For Below Questions

What is a three-tier data warehouse?

635


Write a program to show the parser component used in teradata?

554


List the logical and conditional operators that are used with teradata along with their meanings?

555


What is the purpose of joins in teradata?

546


What is dimensional modeling?

595






What do you mean by fastexport in teradata?

561


How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

3914


Explain fallback in teradata?

611


What is bteq script in teradata?

635


What is teradata?

648


what is object level locking ? where do appear this type of locking ?

3117


Comment whether bottleneck is an error or not.

625


Explain BYNET.

612


What is upsert statement in teradata?

618


Can we collect statistics on multiple columns?

570