How to Skip or Get first and Last Record from Flat File
through MultiLoad and TPUMP Utility?
Answer Posted / 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 |
Post New Answer View All Answers
What is spool space? Why do you get spool space errors?
What is teradata? What are some primary characteristics of teradata?
What is bteq utility in teradata?
What is the difference between union and union all in teradata?
In general, how do you optimze any sql in teradata?
What is partitioned primary index (ppi)?
Explain the most common data types used in teradata?
What is the use of having index on table?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
Can you connect multiload from ab initio?
What are the steps involved after the disk manager passes the request?
What is the use of teradata system software?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
When tpump is used instead of multiload?