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
- 27093 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 is called partitioned primary index (ppi)?
What is meant by a Clique?
What is the opening step in basic teradata query script?
How many types of joins are there in teradata?
Explain Teradata performance tuning and optimization?
Explain and compare pros and cons of start schemas?
What is dimensional modeling?
How does hashing happens in teradata?
Highlight a few of the important components of Teradata?
How do you see a ddl for an existing table?
What are the main components of teradata system?
How to find duplicates in a table?
List out teradata data types?
Explain the types of join supports by teradata?
What is a node in teradata? Explain
