Discussions Populaires Dans la Communauté Teradata

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

Réponses:

6

Adeptes:

6

Vues:

347

Vote Count:

0

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

Réponses:

7

Adeptes:

8

Vues:

403

Vote Count:

2

Why to prefer Teradata over conventional Oracle SQL Tool?‎

Réponses:

5

Adeptes:

5

Vues:

162

Vote Count:

0

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

Réponses:

0

Adeptes:

0

Vues:

28

Vote Count:

0

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

Réponses:

1

Adeptes:

1

Vues:

2

Vote Count:

0

 

La répondre a été ajoutée par  Hassan farooq, SOFTWARE ENGINEER
Depuis 5 années

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 ... Voir Plus

 

La répondre a été ajoutée par  Ahmed Lateef, Member Technical Services, eBay
Depuis 5 années

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 ... Voir Plus

 

La répondre a été ajoutée par  Ahmed Lateef, Member Technical Services, eBay
Depuis 5 années

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

 

La répondre a été ajoutée par  Ahmed Lateef, Member Technical Services, eBay
Depuis 5 années

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 ... Voir Plus

 

La répondre a été ajoutée par  Syed Zahur Ahmed Syed Shakir Ahmed
Depuis 5 années

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 ... Voir Plus