Interested to Buy Any Domain ? << Click Here >> for more details...
1. generally how many node system will be used by the client.
2. while running mload if the job is aborted/failed at any
phase what we have to look after to run the job successfully?
3.i wanted to know how to write the fastload script for
table creation as well as table loading in a single script?
- 3 Answers
- 7266 Views
- I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
1. As said above, the requirement drives the no of nodes to
be connected. But, for millions of data, generally, 10 nodes
may be used
2.release mload, drop the log table,work table,error table
and submit the mload if the table needs to be loaded from first.
3.Log onto Teradata,Defining the Teradata table that you
want to load (target table),Defining the INPUT data file,
Telling the system to start loading.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is partitioned primary index (ppi)?
What is called partitioned primary index (ppi)?
What is the use of fallback?
Highlight the need for Performance Tuning.
What do you mean by tpt in teradata?
What are the different functions performed in development phase?
What are the steps involved in the process flow of the sql statement through channel attached system?
If a Node is busy what are the steps you can take to avoid ?
What is meant by a Virtual Disk?
Highlight a few of the advantages that ETL tools have over Teradata.
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
Difference between multiload and tpump?
What is meant by a Parsing Engine?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
Highlight the differences between Primary Key and Primary Index.
