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 the use of virtual processor connectivity in teradata?
what is the query for retrieve the unique values(not display the duplicates values) from single table?
Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table
What are the primary characteristics of the Teradata.
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
Fast Load Script is failed and error tables are available then how do you restart?
How to copy teradata scripts from ur remote desktop to server machine?
Why FLOAD does not support multiset tables??
How is MLOAD Teradata Server restarted after execution?
Explain and compare pros and cons of start schemas?
What type of indexing mechanism do we need to use for a typical data warehouse?
What are some primary characteristics of teradata?