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 stored procedure in teradata?
What are the various reporting tools in the market?
Explain the teradata primary index mechanics in detail with a diagram.
What are the uses of client software involved in teradata?
What are the design features involved in teradata?
Explain the term 'columns' related to relational database management system?
If a Node is busy what are the steps you can take to avoid ?
How to find duplicates in a table?
What is oltp?
In general, how do you optimze any sql in teradata?
Why does varchar occupy 2 extra bytes?
What is inner join and outer join?
Explain amp in teradata?
Did you write stored procedures in teradata?
What is the difference between teradata and basic rdbms?