Teradata is a parallel 'shared-nothing' database management system. It is primarily used for data warehouse applications with large data volumes.
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 ...