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
- 26898 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
any one answer me how they can analyzing the project using data ware housing?
What are aggregate tables? How do you design them using teradata?
Why does varchar occupy 2 extra bytes?
What is the purpose of upsert command?
What is partitioned primary index (ppi)?
What are the different functions performed in development phase?
What is teradata? What are some primary characteristics of teradata?
What is oltp?
What are the uses of client software involved in teradata?
How many tables can you join in v2r5?
What are the updated features of teradata?
What is a three-tier data warehouse?
Explain the most common data types used in teradata?
How do you set the session mode parameters in bteq?
What do you mean by teradata intellicloud?
