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
What is the use of teradata system software?
In the Primary Index, what is the score of AMPs that are actively involved?
Highlight the advantages of PPI(Partition Primary Index).
What is the difference between fastload and multiload?
What are the available join types in teradata?
What are the functions performed by bynet?
Highlight a few of the advantages that ETL tools have over Teradata.
What is the use of stored procedures in teradata?
What do high confidence, low confidence and no confidence mean in explain plan?
What is node? How many nodes and amps used in your previous project?
How many sessions of MAX is PE capable of handling at a particular time?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What are the joins in teradata?
What are differences between teradata and ansi session modes in teradata?