1)WHAT IS THE EXACT DIFFERENCE BETWEEN TERADATA AND ORACLE?
2)MOST OF THE COMPANIES ARE USING TARA DATA FOR "DWH PROJECTS" ONLY? WHY?

Answers were Sorted based on User's Feedback



1)WHAT IS THE EXACT DIFFERENCE BETWEEN TERADATA AND ORACLE? 2)MOST OF THE COMPANIES ARE USING TARA ..

Answer / yuvaevergreen

Teradata is RDBMS and Oracle is Object RDBMS. Teradata has
been mainly designed to OLAP whereas Oracle is for OLTP.
Both can be used for OLTP and OLAP. But, Teradata is mainly
used for DWH because of its parallelism. Even a simple table
with less no of rows is also distributed equally among the
amps. This gives TD an edge over Oracle, when it comes to
DWH. Oracle is very well suited for transaction processing
because of its object rdbms nature.

Is This Answer Correct ?    32 Yes 6 No

1)WHAT IS THE EXACT DIFFERENCE BETWEEN TERADATA AND ORACLE? 2)MOST OF THE COMPANIES ARE USING TARA ..

Answer / shirisha

Teradata is shared nothing Architecture where as oracle is
shared every thing.milllions of instructions persec,fast
retrieval and better storage in teradata.thousands of
instructions per sec n fast retrieval in oracle.Teradata
many bulk load facilities and terabytes of storage. oracle
limited bulkload facilities and GIGA bytes of storage.
parallelism is unconditional in teradata and conditional in
oracle.teradata is designed for DWH, datamart,internet,e-
commerce appliances.oracle is designed for OLTP
more and OLAP and DWH parti l.

Is This Answer Correct ?    10 Yes 1 No

1)WHAT IS THE EXACT DIFFERENCE BETWEEN TERADATA AND ORACLE? 2)MOST OF THE COMPANIES ARE USING TARA ..

Answer / praveen

Addition to above answers

Lets Think there are 50 records to be inserted into the table and each record will take 1 sec. If we are doing in oracle or Teradata (with 1 amp) It will take 50 secs. But due to parallelism we can increase the amps. let us assume we have 5 amps. So, now the amount of work is distributed between 5 Amps and now it will take only 10 sec's. Whatever the database we are using time efficient should be imp. So, Teradata is used in many DWH projects.

Is This Answer Correct ?    8 Yes 0 No

1)WHAT IS THE EXACT DIFFERENCE BETWEEN TERADATA AND ORACLE? 2)MOST OF THE COMPANIES ARE USING TARA ..

Answer / tdguy

Teradata's parallelism gives an edge over Oracle, when it
comes to OLAP. Whereas Oracle is generally used for OLTP due
to its conditional parallelism and object rdbms nature.

Is This Answer Correct ?    4 Yes 0 No

1)WHAT IS THE EXACT DIFFERENCE BETWEEN TERADATA AND ORACLE? 2)MOST OF THE COMPANIES ARE USING TARA ..

Answer / shaik mahamad rafi

Teradata Oracle
--------------------------------------------------------------1 shared nothing architecture 1>shared pool architecture
2 Index's Parallel Distribution 2>Sequence distribute
3 No need to maintain Index's as 3>dba must maintain index's
dba
4 MIPS 4>KIPS
5 Especially EDWH 5>Especially TX Process
6 High Availability 6> Comparing Low
7 Easily Writing Complex Queries 7>Difficult To write CMPLXQ
8 Tera bytes of data for historical 8>giga bytes for TX Pro

Is This Answer Correct ?    3 Yes 0 No

1)WHAT IS THE EXACT DIFFERENCE BETWEEN TERADATA AND ORACLE? 2)MOST OF THE COMPANIES ARE USING TARA ..

Answer / ramon morales

Teradata es una BD para DWH, con arquitectura para manejo de grandes cantidades de datos TB y hasta PN.
Oracle es una BD con arquitectura relacional, Oracle tiene Exadata que es la competencia de Teradata.
Teradata tiene mas años en el mercado y esta posicionado como la herramienta Lider en DWH.
Speak about the both Arquitect is other topic

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Teradata Interview Questions

What are the various indexes in teradata? How to use them? Why are they preferred?

0 Answers  


Explain about Skew Factor?

6 Answers   TCS,


Explain teradata architecture in detail with a diagram.

0 Answers  


Explain the term 'database' related to relational database management system?

0 Answers  


Difference between client character set and server character set? What is the use of these two?default character set in teradata?

1 Answers   TCS,






Explain BYNET.

0 Answers  


How many types of index are present in teradata?

1 Answers  


What is the difference between correlated sub queries and inner queries?

4 Answers  


which utitility can use for loading the data from non-teradata to teradata ?

5 Answers   Wipro,


Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?

2 Answers   IBM,


Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance

6 Answers   Cap Gemini,


What is the Maximum number of volatile tables that can be created?

4 Answers   Mphasis,


Categories