why should we go Teradata over Oracle,what is the main
differences?

Answers were Sorted based on User's Feedback



why should we go Teradata over Oracle,what is the main differences?..

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

why should we go Teradata over Oracle,what is the main differences?..

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

why should we go Teradata over Oracle,what is the main differences?..

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

why should we go Teradata over Oracle,what is the main differences?..

Answer / anay reddy

Apart from that data distribution and retrival will be
parallel

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Teradata Interview Questions

What is the use of virtual processor connectivity in teradata?

0 Answers  


what is the query for retrieve the unique values(not display the duplicates values) from single table?

6 Answers   IBM,


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

6 Answers   IBM,


What are the primary characteristics of the Teradata.

0 Answers  


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?

0 Answers   IBM,






Fast Load Script is failed and error tables are available then how do you restart?

3 Answers   TCS,


How to copy teradata scripts from ur remote desktop to server machine?

3 Answers  


Why FLOAD does not support multiset tables??

3 Answers   TCS, Tesco,


How is MLOAD Teradata Server restarted after execution?

0 Answers  


Explain and compare pros and cons of start schemas?

0 Answers  


What type of indexing mechanism do we need to use for a typical data warehouse?

0 Answers  


What are some primary characteristics of teradata?

0 Answers  


Categories