Interested to Buy Any Domain ? << Click Here >> for more details...
How to Skip or Get first and Last Record from Flat File
through MultiLoad and TPUMP Utility?
- 4 Answers
- 26713 Views
- Comsys, IBM, I also Faced
- E-Mail Answers
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 do you mean by parsing?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
What are differences between teradata and ansi session modes in teradata?
Discuss the advantages of using partitioned primary index in a query?
What are the various indexes in teradata?
Differentiate database data and data warehouse data?
What is called partitioned primary index (ppi)?
What is meant by a Parsing Engine?
What is the basic syntax for teradata select statement?
What are the joins in teradata and how many types of joins are there in teradata?
Explain teradata architecture?
Describe primary index in teradata?
What does sleep function does in fast load?
Explain fastload in teradata?
Explain the term 'tables' related to relational database management system?
