Trending Teradata Discussions

Follow

Ask the Community


Ask any professional question and get answers from other specialists.

Stream language
Default profile image
Question added by Deleted user
7 years ago
Answers:
6
Followers:
Views:
347
Vote Count:
0
Answer should contain a minimum of 25 characters.
PAPPU MAJUMDER's image
Question added by PAPPU MAJUMDER Microsoft Business intelligence (MSBI) Equifax
8 years ago
Answers:
7
Followers:
Views:
403
Vote Count:
2
Answer should contain a minimum of 25 characters.
Juber shaikh's image
Question added by Juber shaikh Software Engineering Analyst Accenture
8 years ago
Answers:
5
Followers:
Views:
162
Vote Count:
0
Answer should contain a minimum of 25 characters.
Default profile image
Question added by Deleted user
7 years ago
Answers:
0
Followers:
Views:
28
Vote Count:
0
Answer should contain a minimum of 25 characters.
Default profile image
Question added by Deleted user
5 years ago
Answers:
1
Followers:
Views:
2
Vote Count:
0
Answer should contain a minimum of 25 characters.
Hassan farooq's image  
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

Ahmed Lateef's image  
Answer added by  Ahmed Lateef, Member Technical Services, eBay
5 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

Ahmed Lateef's image  
Answer added by  Ahmed Lateef, Member Technical Services, eBay
5 years ago

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

Ahmed Lateef's image  
Answer added by  Ahmed Lateef, Member Technical Services, eBay
5 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

Syed Zahur Ahmed Syed Shakir Ahmed's image  
Answer added by  Syed Zahur Ahmed Syed Shakir Ahmed
5 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