1)WHAT IS THE EXACT DIFFERENCE BETWEEN TERADATA AND ORACLE?
2)MOST OF THE COMPANIES ARE USING TARA DATA FOR "DWH PROJECTS" ONLY? WHY?
- 6 Answers
- 48419 Views
- Bank Of America, Wipro, I also Faced
- E-Mail Answers
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
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
what are the day to day activities of teradata DBA ?
What is the multi-insert?
How can bottlenecks be identified?
Explain teradata vs. Redshift?
Explain the term 'columns' related to relational database management system?
List out some of the primary characteristics of teradata.
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Where is teradata rdbms used?
In general, how do you optimze any sql in teradata?
Explain fallback in teradata?
Why is the case expression used in teradata?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
Comment whether bottleneck is an error or not.
What is collect statistics?
