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 are the components used in smp and massively parallel processing (mpp) machines?
Why Multiload does not supports USI and supports NUSI?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What are the different softwares used with their functions in teradata?
What is the difference between teradata and basic rdbms?
How will you solve the problem that occurs during update?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
How to Extract data from multiple legacy systems?
which join mostly use in realtime?
What is spool space? Why do you get spool space errors?
How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.
What is difference between user and database in teradata?