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
- 27110 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 |
what is referential constraints?how do you implement RI in teradata?
what is identity column in TD?
Explain fallback in teradata?
what do you mean by INMOD Routines and OUTMODE Routines ?
In your project what type of issues and errors you facing in Teradata
sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?
Describe primary index in teradata?
What is the use of having index on table?
In Teradata, how do we Generate Sequence?
Explain the term 'columns' related to relational database management system?
What's the syntax of sub string?
Differentiate primary key and partition key?
Teradata 
