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
- 7162 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 various etl tools in the market?
What is a clique?
Explain the term 'columns' related to relational database management system?
What are the various indexes in teradata?
What is meant by a Channel Driver?
How do you define Teradata?
What is upsert statement in teradata?
Explain teradata utilities. What is multiload, fast load, tpump?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
What are the various indexes in teradata? How to use them? Why are they preferred?
Why are oltp database designs not generally a good idea for a data warehouse?
Explain the meaning of Amp?
Explain and compare pros and cons of snow flake schemas?
