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
- 26720 Views
- Comsys, IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / milind mane
In .IMPORT command in MLoad we have a option to give
record no. from which processing should begin. ie. ‘FROM m’
‘m’ is a logical record number, as an integer, of the
record in the identified data source where processing is
to begin. You can mention ’m’ as 2 and processing will
start from second record.
THRU k and FOR n are two options in the same MLoad command,
functions same towards the end of the processing.
| Is This Answer Correct ? | 11 Yes | 4 No |
Answer / yuvaevergreen
Adding to the above, if from n"start record" and for n "stop
record" are not mentioned, mload considers records from
start till the end of the file.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / tdguy
Two options, FROM 'n' THRU 'm' can be used or FOR 'n' can
be used.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Mention a few of the ETL tools that come under Teradata.
where we can use the delimiter in mload? pls let me know
What are the commands to make a new table, change a table and remove a table in teradata?
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
What is a three-tier data warehouse?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What are the available primary index types?
What is Join Index in TD and How it works?
List out teradata data types?
Aborted in Phase 1 data Acquistion Incomplete in fastload?
What is differnce between Error code and Error Level in Bteq
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
Teradata 
