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 |
Where is teradata rdbms used?
What do you mean by ttu in teradata?
What can be achieved by using the teradata rdbms?
how can i answer for question like teradat architecture in interveiw
How to copy 1 million records from one DB to another, Which is effective interms of performance?
Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?
In general, how do you optimze any sql in teradata?
What are the different design perspectives used in teradata?
What is the opening step in basic teradata query script?
How do you determine the number of sessions?
How to Extract data from multiple legacy systems?
Explain the teradata primary index mechanics in detail with a diagram.