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
What is stored procedure in teradata?
What is logical data model?
What are default access rights in teradata?
What are the primary characteristics of the Teradata.
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What are teradata utilities?
What are the main components of teradata system?
How can you track login parameters of users in teradata?
What is partitioned primary index (ppi)?
How to find duplicates in a table?
What is the purpose of joins in teradata and what are the available join types?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
Explain the term 'columns' related to relational database management system?
Explain the advantages of partitioned primary index in a query?
What's the difference between timestamp (0) and timestamp (6)?