Trending Teradata Discussions

What is the difference between fastload and Multiload in Teradata?‎

How do you define Teradata? Give some of the primary characteristics of the same.‎

Why to prefer Teradata over conventional Oracle SQL Tool?‎

What is the difference between Ansci mode and Teradata mode?‎

How would you calculate cumulative sum of a specific column in SQL Server ?‎

 

Answer added by  Hassan farooq, SOFTWARE ENGINEER
5 years ago

This will help you.... select t1.id, t1.SomeNumt, SUM(t2.SomeNumt) as sum from tableName t1 inner join tableName t2 on t1.id >= t2.idgroup by t1.id, t1.SomeNumt order ... See More

 

Answer added by  Ahmed Lateef, Member Technical Services, eBay
6 years ago

Oracle is good for OLTP. But can not retrieve data efficiently. It actually will not work when volumes are high. Teradata will allow you high number of concurrent queries ... See More

 

Answer added by  Ahmed Lateef, Member Technical Services, eBay
6 years ago

Scalable - Highly parrallel (AMP architeture) MPP system. Fault Tolerant with no single point of failure.

 

Answer added by  Ahmed Lateef, Member Technical Services, eBay
6 years ago

Fload is Faster - Target table must be empty ( so no need to resume from failed point) - If fails - Drop and recreate the table - Can not have NUSI  on table as it requir ... See More

 

Answer added by  Syed Zahur Ahmed Syed Shakir Ahmed
6 years ago

Fast Load usually prefrerred to load in empty tables, as it locks the entire table. Muti Load laods into tables without locking the entir table.Multiload loads the data i ... See More