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


Please Help Members By Posting Answers For Below Questions

What is spool space? Why do you get spool space errors?

703


What is teradata? What are some primary characteristics of teradata?

754


What is bteq utility in teradata?

743


What is the difference between union and union all in teradata?

839


In general, how do you optimze any sql in teradata?

778


What is partitioned primary index (ppi)?

809


Explain the most common data types used in teradata?

783


What is the use of having index on table?

750


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?

856


Can you connect multiload from ab initio?

907


What are the steps involved after the disk manager passes the request?

808


What is the use of teradata system software?

776


My table got locked during mload due to a failed job. What do I do to perform other operations on it?

873


If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

1902


When tpump is used instead of multiload?

849