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
How does hashing happens in teradata?
How do you define Teradata?
Explain the new features of teradata?
In BTEQ, how are the session-mode parameters being set?
What are the steps involved after the disk manager passes the request?
Differentiate primary key and partition key?
In the Primary Index, what is the score of AMPs that are actively involved?
What is the purpose of using case expression in teradata?
In Teradata, what is the significance of UPSERT command?
What are the various etl tools in the market?
Explain the term 'columns' related to relational database management system?
What do you mean by teradata sql assistant?
Explain how spool space is used.
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
If a Node is busy what are the steps you can take to avoid ?