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

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

628


What are the various reporting tools in the market?

861


What is meant by a dispatcher?

809


What is the maximum number of dml can be coded in a multiload script?

864


What are the different design perspectives used in teradata?

783


What is the command in bteq to check for session settings ?

911


If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

1939


What is the opening step in basic teradata query script?

820


What are the various indexes in teradata? Why are they preferred?

787


What is TPD?

1167


Explain and compare pros and cons of snow flake schemas?

841


How do you set the session mode parameters in bteq?

846


What do high confidence, low confidence and no confidence mean in explain plan?

839


Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3166


hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

2591