Interested to Buy Any Domain ? << Click Here >> for more details...
How to Skip or Get first and Last Record from Flat File
through MultiLoad and TPUMP Utility?
- 4 Answers
- 27098 Views
- Comsys, IBM, I also Faced
- E-Mail Answers
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 do you mean by tpt in teradata?
what is the default character set in teradata,,?
What is meant by a Least Cost Plan?
How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
How would you load a very large file in teradata in general?
i have a table like sales....the field are Prodid Jan(jam month sales)Feb March 1 20 76 50 2 30 94 40 3 40 90 30 4 70 20 30 5 23 40 40 6 85 30 55 7 84 20 65 8 10 93 40 9 57 30 30 10 38 83 40 11 35 39 90 12 83 89 50 Now the Question is i want get the max sales of 12 products from the months.hint:for eg I WANT GET 89 for product12... Can any one help me
What are teradata utilities?
How do you Generate Sequence in Teradata?
Why is the case expression used in teradata?
what is identity columns in TD?
While creating table my dba has fallback or no fallback in his ddl. What is that?
Teradata 
