How to Skip or Get first and Last Record from Flat File
through MultiLoad and TPUMP Utility?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / yuvaevergreen
Adding to the above, if from n"start record" and for n "stop
record" are not mentioned, mload considers records from
start till the end of the file.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / tdguy
Two options, FROM 'n' THRU 'm' can be used or FOR 'n' can
be used.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / kvsnr
MultiLoad is going to need to know the structure the INPUT
flat file. Use the .LAYOUT command to name the layout.
It is used to designate the starting location for this data
based on the previous fields length. If you are listing
fields in order and need to skip a few bytes in the record,
you can either use the .FILLER (like above) to position to
the cursor to the next field, or the "*" on the Dept_No
field could have been replaced with the number 132 ( CHAR
(11)+CHAR(20)+CHAR(100)+1 ). Then, the .FILLER is not needed
Is This Answer Correct ? | 2 Yes | 10 No |
Does any body has TERADATA Certification Dumps, if any body is having please let me know to summee4you@gmail.o, it is very Very URGENT to me
What are different table types used in teradata?
Explain vproc in teradata?
Explain PDE.
What happens when a node suffers a downfall?
What is the difference between SI and JI?
Can we load a Multi set table using MLOAD?
How do you determine the number of sessions?
Discuss the advantages of using partitioned primary index in a query?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
Can we collect statistics on multiple columns?
Describe the between keyword in teradata?