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
- 7119 Views
- I also Faced
- E-Mail Answers
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 are the different design perspectives used in teradata?
What is teradata? What are some primary characteristics of teradata?
How can we check the version of Teradata that we are using currently?
What is difference between user and database in teradata?
What is the purpose of indexes?
Explain the advantages of partitioned primary index in a query?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What are the things to be considered while creating secondary index?
What are default access rights in teradata?
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?
Why managing the data is important?
What is multi insert?
How can bottlenecks be identified?
What do you mean by tpt in teradata?
How to eliminate product joins in a teradata sql query?
