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
- 26665 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 real time and near real time data warehousing?
What do you mean by tpt in teradata?
What is called partitioned primary index (ppi)?
List out some of the primary characteristics of teradata.
Can we collect statistics on table level?
What are the available primary index types in teradata.
What is the purpose of using case expression in teradata?
How to Extract data from multiple legacy systems?
Write a program to show the parser component used in teradata?
why use references rather than pointers in the public api, particularly for arguments which are modified?
Highlight a few of the advantages that ETL tools have over Teradata.
if collect stats but it show low confidence why?
What are the different methods ot loading a dimension table? A fact table etc?
Highlight the limitations of TPUMP Utility.
Explain the term 'foreign key' related to relational database management system?
