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
- 26666 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 the multi-insert?
What is logical data model?
What are the commands to make a new table, change a table and remove a table in teradata?
What is meant by a Highest Cost Plan?
Highlight a few of the advantages that ETL tools have over Teradata.
Explain the types of join supports by teradata?
What is smp and mpp platforms?
Can you connect multiload from ab initio?
How to Extract data from multiple legacy systems?
What is the difference between union and union all in teradata?
What is the use of virtual processor connectivity in teradata?
what are the uses of fact table and dimension table in banking project?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
Explain teradata architecture in detail with a diagram.
What are aggregate tables? How do you design them using teradata?
