Increasing no of amps will increase performance. Is this
true?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / yuvaevergreen
yes...
>>increase the no of amps with same no of users--performance
increases proportionately.
>>increase the no of PEs to increase the no of sessions.
>>increse the no of disks to increase the data storage.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / himanshu
Yes. But in that case no. of users should be the same. i.e.
suppose there are 5 users requesting 50 MB data, so the no.
of users should not increase. If suddenly 10 users start
demanding the same data, performance would not increase
even if the no. of amps are increased...!!
Is This Answer Correct ? | 0 Yes | 3 No |
any one answer me how they can analyzing the project using data ware housing?
id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???
What is bteq utility in teradata?
What is Join Index in TD and How it works?
In general, how do you optimze any sql in teradata?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
Can some one tell me the ressolution for the error. I was not able to answer this question in wipro interview. "The transaction exceeded the maximum number of rowhash locks allowed"
what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)
What is a clique?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What is the basic syntax for teradata select statement?
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?