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 default access rights in teradata? What explicit right can be given to a user?
what is meant by Hot amp?
What is the Maximum number of volatile tables that can be created?
What are the functions performed by bynet?
If the query is NOT WRITTEN PROPERLY then what are the recommendations you can give to the developer ?
What are the differences between TerdataV2R5 and V12 Versions please??
Steps to create a data model?
What is the maximum number of dml can be coded in a multiload script?
What do you mean by tpt in teradata?
write lock is compatiable with which type of lock?
What are the different table types supported by teradata?
How do you verify a complicated sql?