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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the purpose of using case expression in teradata?

567


What is basic teradata query language?

627


i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

1761


What is the use of fallback?

550


how do you manage the production space. what are the proactive methods you can take ?

1470






What do you mean by tpt in teradata?

583


Highlight the limitations of TPUMP Utility.

600


How is the teradata different from oracle?

618


What is upsert statement in teradata?

607


Mention a few of the ETL tools that come under Teradata.

611


What are the components provided on node?

565


Why is the case expression used in teradata?

582


What is the difference between fastload and multiload?

784


any one answer me how they can analyzing the project using data ware housing?

2020


What are the various etl tools in the market?

578