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

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

862


How many sessions of MAX is PE capable of handling at a particular time?

828


What is the use of stored procedures in teradata?

791


Is multi insert ansi standard?

1974


What is the purpose of indexes?

823


What are some commonly used bteq scripts?

775


What happens in a conflict? How do you handle that?

853


What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

867


What interface is used to connect to windows based applications?

832


Explain the term 'row' related to relational database management system?

744


Explain and compare pros and cons of snow flake schemas?

833


What is a sparse index?

839


If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

858


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

1504


Explain teradata utilities. What is multiload, fast load, tpump?

798