Increasing no of amps will increase performance. Is this
true?
Answer Posted / dinesh
hi,
yes ofcourse its increasing performance against when work
load increases, in teradata performance wil not affect
because the work load is evevnly distributed acorss all the
amps.
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
Explain the term 'primary key' related to relational database management system?
Explain fallback in teradata?
What is the meaning of Caching in Teradata?
If a Node is busy what are the steps you can take to avoid ?
How to select first n records in teradata?
Explain the teradata primary index mechanics in detail with a diagram.
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Why is the case expression used in teradata?
Highlight all the modes that are present under Confidence Level.
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What are the different methods ot loading a dimension table? A fact table etc?
What is the difference between fastload and multiload? Which one is faster?
Difference between multiload and tpump?
What are the different table types that are supported by teradata?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?