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
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What are the various reporting tools in the market?
What is meant by a dispatcher?
What is the maximum number of dml can be coded in a multiload script?
What are the different design perspectives used in teradata?
What is the command in bteq to check for session settings ?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
What is the opening step in basic teradata query script?
What are the various indexes in teradata? Why are they preferred?
What is TPD?
Explain and compare pros and cons of snow flake schemas?
How do you set the session mode parameters in bteq?
What do high confidence, low confidence and no confidence mean in explain plan?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
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