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
6 views

Granting permission on an altered table in Teradata

I have a table, which has two columns say A and B as part of the Primary index PI_AB. I have to alter the length of B column - increase it. I was planning to alter the primary index to just have A, ...
-1
votes
0answers
38 views

Converting Script from Teradata to SQL Server

I am currently working on moving a database, and all of its related scripts, off of Teradata 13 and into SQL Server 2012, and am having an issue with just one of the scripts. In the script, the ...
1
vote
0answers
26 views

Convert Teradata Database to SQL Server 2012 [closed]

I am just wondering if anyone has any experience, knowledge, or recommendations on migrating a Teradata database to SQL Server 2012. I have never worked with Teradata before so I am unfamiliar with ...
0
votes
1answer
41 views

Teradata SQL Assistant - List tables under DBC in the Database Explorer

I am able to query, but under DBC, in the Database Explorer, I do not see the list of tables. That also makes it impossible for me to qualify name and get any kind of ide support while writing my ...
0
votes
2answers
85 views

Best practice - use of derived table or use the original table in join?

Imagine I have the following tables in Teradata : TableA : Field1|Field2|Field3 TableB : Field1|Field4|Field5 I am trying to join these two tables Method 1 : SEL TableA.Field3, TableB.Field4 ...
0
votes
1answer
89 views

How to split a large table in Teradata

I'm trying to load data from a very large table (200 million rows) into a Presentation Datamart (PDM) for an Enterprise Data Warehouse using Teradata 14.10. I want to split this large table into ...
0
votes
3answers
70 views

SQL MAX function

Suppose I have a table with attributes Name, Age as follows: MyTable (Name, Age) Now, to get the oldest age I can write the following query: SELECT MAX(Age) AS "Oldest Age" FROM MyTable; ...
0
votes
0answers
57 views

Teradata query to fetch records based on date value

I have a case where current date is passed as a parameter to fetch records in TD through a SQL. If current_date doesnt have any records in the DB, then I need to query the DB using previous date ...
0
votes
1answer
332 views

Problem while connecting to teradata with sqoop

I am trying to connect to Teradat using Sqoop with following command: sqoop import -libjars /usr/lib/sqoop/lib/tdgssconfig.jar,/usr/lib/sqoop/lib/terajdbc4.jar -driver com.teradata.jdbc.TeraDriver ...
0
votes
0answers
62 views

Is it possible to automatically convert/load an Access database into a CSV or TXT file?

I'm working on moving an Access database to ultimately Teradata. Now I know that Teradata can't read Access files (.aacdb). So what a colleague has tried was manually convert one of the tables in the ...
0
votes
1answer
80 views

Normalization of Time Series Data

I have a table containing various a/b test experiment performance on a daily basis. The table structure looks something like this: date | experiment | user_count | user_attr | sales ...
0
votes
0answers
166 views

Teradata With Recursive

Hi All i'm having problems writing a recursive query and i ran out of options that i can think of . The query should join serial numbers in one cell coma delimited to a specific order number . ...
3
votes
1answer
845 views

Teradata : Disadvantage of Collect stats

I want to know any disadvantage can occur by doing collect stats on a column that is being widely used in join condition across so many procedures ? (Eg. the column is accessed 300+ times access in 60 ...
0
votes
2answers
206 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
1answer
472 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
886 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 ...