why should we go Teradata over Oracle,what is the main
differences?
Answers were Sorted based on User's Feedback
Answer / talk2sreenivas@gmail.com
In Teradata Architechture is shared nothing.
It supports unconditional parallelism.
supports terabytes of data.
we can load bulk data into tables with less time.
| Is This Answer Correct ? | 17 Yes | 0 No |
Answer / my name is manguni
Teradata is generally preferred for data warehousing
because of its "shared nothing" architecture and
unconditional parallelism. Perfect for OLAP and handling
very huge amount of data.
--- By manguni manikam from saidapet.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / yuvaevergreen
>>>Adding to the above, the distribution of data in disks would be uniform where as in oracle i hope it is range distribution.
>>> Similarly, for reporting purpose, the data can be exported in a very fast manner using utilities compared to oracle.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / anay reddy
Apart from that data distribution and retrival will be
parallel
| Is This Answer Correct ? | 1 Yes | 0 No |
Explain vproc in teradata?
Does SDLC changes when you use Teradata instead of Oracle?
What are the advantages of teradata?
Highlight the limitations of TPUMP Utility.
Explain PDE.
What is multi insert?
List out some of the primary characteristics of teradata.
How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average sal with out using avg function????
A Query was run fine earlier. It is not running properly now. what are proactive steps you can take as a dba ?
What is the basic syntax for teradata select statement?
Why is the case expression used in teradata?
What is meant by a Highest Cost Plan?