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
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
How many sessions of MAX is PE capable of handling at a particular time?
What is the use of stored procedures in teradata?
Is multi insert ansi standard?
What is the purpose of indexes?
What are some commonly used bteq scripts?
What happens in a conflict? How do you handle that?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What interface is used to connect to windows based applications?
Explain the term 'row' related to relational database management system?
Explain and compare pros and cons of snow flake schemas?
What is a sparse index?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
Explain teradata utilities. What is multiload, fast load, tpump?