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
- 6214 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ugandhar
1) It depends on the requirement. Generally around 10 node
system will be a moderate to high dataware house
environments.
2) Check the log file to know the exact failure. Fix it, do
the mlod cleanup and rerun the job.
3) specify the table craetion step in the beginning of the
script before the actual fastload commands starts.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / 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 |
What is meant by a Parsing Engine?
What is a clique?
How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.
How do you create a table with an existing structure of another table with data and with no data?
What is the use of virtual processor connectivity in teradata?
What are the commands to make a new table, change a table and remove a table in teradata?
What are the various indexes in teradata? How to use them? Why are they preferred?
What is TPD?
On which column will you take primary index???
I want to write one query How to get Matched records and unmatched records in table?
What do you mean by teradata intellicloud?
what is meant by Hot amp?
Teradata 
