How to Skip or Get first and Last Record from Flat File
through MultiLoad and TPUMP Utility?
- 4 Answers
- 25876 Views
- Comsys, IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is TPD?
What are the uses of bynets in multi-node systems?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
Explain fallback in teradata?
What are the different methods ot loading a dimension table? A fact table etc?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
How can we check the version of Teradata that we are using currently?
Explain the teradata primary index mechanics in detail with a diagram.
Highlight a few of the important components of Teradata?
What exactly do you know about catching in teradata?
what is sysdba and sysdbc ? which has high priority ?
What is the use of having index on table?
Define views in teradata with general syntax.
Explain BYNET.
