Teradata is a parallel 'shared-nothing' database management system. It is primarily used for data warehouse applications with large data volumes.

learn more… | top users | synonyms

0
votes
0answers
9 views

Teradata Viewpoint 13.10 Data Collection Backup

Viewpoint Guide suggests that there's a daily postgresql backup in my /data/backup folder, each database in every folder ( cam dcsdb lportal td_portal td_portlets ) but in the dcsdb folder there's ...
0
votes
2answers
43 views

Teradata performance statistics

I need some statistics regarding the performance of Teradata, something like with a given hardware, given nodes and given AMPs - a table which has thousands of rows can be read in 't' secs. I need ...
1
vote
0answers
171 views

Rename primary key constraint in Teradata

Does Teradata have a way to rename a primary key constraint, rather than dropping it and recreating it? I'm using SP_RENAME for SQL Server and ALTER TABLE...RENAME CONSTRAINT for Oracle, but I don't ...
5
votes
2answers
396 views

Teradata: How to design table to be normalized with many foreign key columns?

I am designing a table in Teradata with about 30 columns. These columns are going to need to store several time-interval-style values such as Daily, Monthly, Weekly, etc. It is bad design to store ...