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
Explain the term 'database' related to relational database management system?
What is dimensional modeling?
What is the difference between union and union all in teradata?
How can we check the version of Teradata that we are using currently?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What is a dimension table?
What is basic teradata query language?
any one answer me how they can analyzing the project using data ware housing?
What is the purpose of joins in teradata?
What are differences between teradata and ansi session modes in teradata?
Can we collect statistics on multiple columns?
What are the available primary index types?
What is the purpose of indexes?
When tpump is used instead of multiload?
What do high confidence, low confidence and no confidence mean in explain plan?