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 |
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What are the enhanced features in teradata v2r5 and v2r6?
What are the uses of bynets in multi-node systems?
What are the various indexes in teradata?
What are the commands to make a new table, change a table and remove a table in teradata?
What is the purpose of joins in teradata?
Explain vproc in teradata?
Explain how spool space is used.
what is object level locking ? where do appear this type of locking ?
How to relege locks in fastload and multiload? example?
what is meant by Hot amp?
Why AMP & PE are called Vprocs?