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


Please Help Members By Posting Answers For Below Questions

What are the steps involved after the disk manager passes the request?

806


What is the maximum number of dml can be coded in a multiload script?

825


Explain the meaning of Amp?

778


What is a clique?

785


How would you load a very large file in teradata in general?

794


How to find duplicates in a table?

863


Explain teradata utilities. What is multiload, fast load, tpump?

769


What are the joins in teradata and how many types of joins are there in teradata?

781


Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

1922


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

2561


What is the syntax for case when statement?

808


What is inner join and outer join?

820


If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

831


What is node? How many nodes and amps used in your previous project?

864


What are the various indexes in teradata?

769