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
Why does varchar occupy 2 extra bytes?
What are tpump utility limitations?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What are the various reporting tools in the market?
What is the use of stored procedures in teradata?
How to view every column and the columns contained in indexes in teradata?
What is primary index and secondary index?
Comment whether bottleneck is an error or not.
What is upsert statement in teradata?
how can we analyze the locks ?
What is the function of parser component in teradata?
What is partitioned primary index (ppi)?
How do you define Teradata?
Why teradata is used?