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 |
What is oltp?
what is the difference between filter and router transmissions
Mention a few of the ETL tools that come under Teradata.
Explain parsing engine in teradata?
What is the diffrence between Multiload & Fastload interms of Performance?
what is meant by Hot amp?
What is meant by a Virtual Disk?
What are the steps involved in the process flow of the sql statement through channel attached system?
Find 2 highest sal from each dept who have completed 5 year in org
Which is more efficient group by or distinct to find duplicates?
Explain the term 'columns' related to relational database management system?
Difference between star and snowflake schemas?