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 / 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 |
Post New Answer View All Answers
What is real time and near real time data warehousing?
any one answer me how they can analyzing the project using data ware housing?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
Difference between star and snowflake schemas?
What is meant by a Least Cost Plan?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Describe the between keyword in teradata?
What are types of partition primary index (ppi) in teradata?
Explain PDE.
if collect stats but it show low confidence why?
What is the purpose of joins in teradata?
Explain the advantages of partitioned primary index in a query?
Explain the new features of teradata?
How do you set the session mode parameters in bteq?
Where is teradata rdbms used?