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
- 27091 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
Explain Teradata performance tuning and optimization?
What is TPD?
Explain parsing engine in teradata?
In the Primary Index, what is the score of AMPs that are actively involved?
What are the steps to create a data model?
Different phases of multiload?
What are the different methods ot loading a dimension table? A fact table etc?
Explain some differences between mpp and smp?
What is the use of fallback?
Describe the between keyword in teradata?
What does sleep function does in fast load?
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?
Discuss the advantages of using partitioned primary index in a query?
Can we collect statistics on multiple columns?
What is teradata? Also, list out some of the primary characteristics of teradata.
