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 are the various indexes in teradata? Why are they preferred?
How do you verify a complicated sql?
Discuss the advantages of using partitioned primary index in a query?
Highlight the differences between Primary Key and Primary Index.
In general, how do you optimze any sql in teradata?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
How will you solve the problem that occurs during update?
What are the different methods ot loading a dimension table? A fact table etc?
why use references rather than pointers in the public api, particularly for arguments which are modified?
What are the available primary index types?
What is the syntax for case when statement?
What are normalization, first normal form, second normal form and third normal form?
How many codd's rules are satisfied by teradata database?
What are the various indexes in teradata? How to use them?
What are some commonly used bteq scripts?