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 meant by Teradata Gateway?
What are the joins in teradata and how many types of joins are there in teradata?
What is meant by a node?
Explain the term 'primary key' related to relational database management system?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What are the different functions performed in development phase?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Can you fastexport a field, which is primary key by putting equality on that key?
What are the various etl tools in the market?
Where is teradata rdbms used?
How can you track login parameters of users in teradata?
Explain the meaning of Amp?
What is collect statistics?
What do you mean by parsing?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?