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
1answer
7 views

How do I get a list of all the partitioned tables and partitioning details in my Teradata?

How do I get a list of all the partitioned tables in teradata? and How do I get a partitioning columns and details for a table in teradata ?
-1
votes
5answers
59 views

How to apply two different where conditions for two different tables in same select statement

select a.column1, b.column2, d.column3, d.column4, d.column5, d.column6 from table1 a left join table2 b on a.colx = b.coly left join table3 c on a.colx = c.colz left join table4 d ...
0
votes
0answers
36 views

INSERT INTO SELECT causing data to double

I have strange issue. I am working in a Teradata database. In a procedure I am populating a main table by processing data via multiple intermediate tables. But in the end only one table is populating ...
0
votes
1answer
89 views

teradata database unable to increase database size in permanent space

Anyone with teradata database experience? I'm new to this database and I've been tasked to increase the size of a database. I am using Teradata Administrator to do this. I am using Tools > Modify ...
0
votes
0answers
70 views

Why does a table take more space in SQL server than in Teradata? [closed]

Is there any reason for a table to occupy significantly more space in SQL server than Teradata? The rows and data structure (columns, data types, data type length) are same, no extra objects like ...
0
votes
0answers
42 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
vote
0answers
65 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
353 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
508 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
355 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
193 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
83 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
827 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
1answer
101 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 ...
3
votes
1answer
1k 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
243 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
535 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
1k 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 ...