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 / shaik mahamad rafi
Teradata Oracle
--------------------------------------------------------------1 shared nothing architecture 1>shared pool architecture
2 Index's Parallel Distribution 2>Sequence distribute
3 No need to maintain Index's as 3>dba must maintain index's
dba
4 MIPS 4>KIPS
5 Especially EDWH 5>Especially TX Process
6 High Availability 6> Comparing Low
7 Easily Writing Complex Queries 7>Difficult To write CMPLXQ
8 Tera bytes of data for historical 8>giga bytes for TX Pro
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
What is TPD?
What is dimensional modeling?
What is meant by a node?
Can you connect multiload from ab initio?
Explain how spool space is used.
What is stored procedure in teradata?
What are the things to be considered while creating secondary index?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
When tpump is used instead of multiload?
What are the available join types in teradata?
What is the difference between global temporary tables and volatile temporary tables?
Explain BYNET.
Highlight the points of differences between the database and user in Teradata.
How do you do backup and recovery in teradata?