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?
Answer Posted / 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 |
Post New Answer View All Answers
What is collect statistics?
What is difference between user and database in teradata?
What is the function of parser component in teradata?
What are types of partition primary index (ppi) in teradata?
Different phases of multiload?
What is the purpose of joins in teradata?
What is meant by Teradata Gateway?
any one answer me how they can analyzing the project using data ware housing?
Explain teradata architecture?
How can you track login parameters of users in teradata?
How can bottlenecks be identified?
What does sleep function does in fast load?
What are the different softwares used with their functions in teradata?
Explain the meaning of Amp?
What is meant by a Highest Cost Plan?