0 - 50 of 244 tags for teradata

I have on SQL2008 server linked server Teradada. I select from this linked server and for many tables is ok, but
when I select some tables I see error:

In my organisation, there are 6 Nodes used and each node carry 24 AMPs.
Could any one please let me know how to determine how many Number of AMPs are required per node ? 
If More Number of AMPs / Nodes are supposed to increase Performance , Why its not true to have Maximum number of Amps / Nodes ?

Hi Everyone
During the performance analysis in cognos reports accessing Teradata, we have identified a large number of accesses to the Teradata catalog (DBC Tables and lots of Help columns).

Hello All,

I have a query where teradata expain is giving wrong esitmated time though the query is taking very few seconds.
It is estimating 9 mins due to which it is getting throttled.  Issue is in step 7. All the stats are ok and refreshed.
Could anyone pleae suggest what might be wrong.


Hi all,
I am trying to export data hive table to teradata table, Below is the command

hadoop com.teradata.hadoop.tool.TeradataExportTool

-url jdbc:teradata://testsystem/database=testdb

-username testuser

-password testpassword

-jobtype hive

-fileformat textfile

I am tyring to write a query that will give me the customer counts on a rolling 52 week ending on monthly basis. I can't seem to find anything anywhere that will help me. I am trying to avoid pulling the query 12 times to get the 52 week customer counts ending for each month!
this is what I have so far:

In Teradata SQLAssistant, I have created a db user USER1 which has 17 views. This user can do a SELECT on any view, thanks to a profile/role I granted and then associated to him. His child USER2 is a db user with the same profile/role as USER1, but my problem is he can't select any of the views of USER1 :

Friends, I have the following problem: I have a final table, where some values are rounded wrongly. There is no transformation of these values. The tables have the same data type, decimal (9.2) and FastExport it converts to the same data type. An example I got was a value of 46.23.

I have a table with Customer, Quarter, Month and Sales (montly) figures.
I need to calculate Quarter Sales and Previous Quarter Sales per Customer, while also showing Montly sales (see desired table format below).
For quarter sales I use sum() over partition by

I've created a Java Function and imported it in TeraData
But after few thousand executions, the function becomes too slow.
You can find below output from TOP command.
tdatuser  23   8  815m  33m 1976 S  200   1.4          1835:21  udfsectsk

Hi All,


Order by Behavior is different in DB2 and Teradata 


I already tried adding Case specific which doesn’t work for my project related data .


Here is the main query modified (table-name etc for security reasons and its output Demo Data but similar to main one )

I am new BTEQ and scripting. I am checking if my source data is updated or not before i am updating my petspace tables.
where cast(CMPGN_RUN_DATE as date)=current_date-1 and TRANS_DATE =current_date-1
group by 1;
.IF ACTIVITYCOUNT = 0 THEN .EXIT 99; -- 99 error code reserved for dependency

Hello. Unfortunatelly the net is really empty with that information. I didn't find anything right about that. Please, help me with that common problem. I can't connect my Teradata SQL Assistant to ODBC Teradata Source. I'm working alone at my home pc (local host). I've got mysql client and database where i was studying sql first.

I am very concerned with the Disk IOs of my Teradata server.
I have ran the following query

Hi All,
How encryption happens in Teradata? What are the different levels of encryption defined in Teradata? And of course decryption too.

I have set up a BTEQ of an SQL code through PUTTY.
The code runs weekly. However, I run a drop statement and then a create table statement, thus losing the table of the previous week. Is there anyway for me to create a table of the following format so that I retain all the tables that I have created ?

ROW_COUNT is returning wrong number.
i have a table having around 100K rows. In a procedure i'm updating all the rows and returning number of rows affected.
I'm using following query to get number of affected rows.

While exporting data from Teradata table with MLSCRIPT option to generate mload script too. I am getting below strings p1<96> or p1 instead of DATE/TIME/TIMESTAMP fields in layout section.
p1<96>p1<96>.FIELD COLUMN2 * CHAR(1);

I faced this scenario in an interview. Suppose there are 2 large tables say CUSTOMERS AND CUSTOMER_SESSIONS. The CUSTOMERS table holds the CUST_ID and CUST_NAME say for a website such as facebook/amazon. The CUSTOMER_SESSIONS table contains the CUST_ID referencing the CUSTOMERS tables and the SESSION_TIME every time the user logs in.

I am very much new to teradata. I am a mainframe & Iseries developer, recently we came across this teradata for one of our implementataions. I found this forum & its keen intresting for the new bies.Appreciate your way of knowledge exchange.
Can some one let me know the answers for the following on teradata :

I want to write SQL UDF with Multiple Lines:
1. Declare variables.
2. Set those variables with select into statement.
3. some if conditions on Variables
4. return some value.
What is the syntax to write this.
I'm using teradata Version

Can Anyone Suggest me where teradata jobs are available.

I am exploring business calendar functions in teradata. There are some of the business calendar functions like td_week_begin, td_week_end, which takes timestamp with time zone value in first argument and time literal value in third argument, Second argument is the calendar type like iso, teradata.

We have a Customer asking this question:
-----Original Message-----

Hi all,
   I need to get data from users from a webpage (jsp) and connect to a teradata database and load them into the tables in the database. I am using jsp to create the webpage. Is it possible to directly connect to the teradata database by scripting in jsp?. If so, some guidance will be appreciated. Thank you

Am looking to find out where does the Checksum metadata values of the datable got stored.
Here when I run a query
        "Column1" CHARACTER(5),
        "Column2" CHARACTER(5)

I am facing a problem when writing a case statement, 
Here is the sample query

I am teradata developer I  worked in teradata technology  last 2 years . i have taken 2 year gap  and searching for  oppurtunities . Can anyone suggest good  big training institutes in USA / any other certifications that  help  to improve my career.

I want to Update a table. But before that i want disable foreign key\check Constraint\Unique Key on some tables.
After update, i want to enable those disables constraint again.
Can you please tell me how can i do that.

We are upgrading from Teradata 12 to Teradata 14, and DataStage 7.5.2 to DataStage 9.1
Existing Teradata DataStage stages will not be converted.  The following parameters are used to read and write from Teradata.

Parameters to read From Teradata 14

I have been developing a demo MVC application and trying it to connect to Teradata Database. But I have been failing since long . I tried whatever I could do as a newbie to this field but apparently have not been able to solve the problem.

I'm new to TeraData. Following is the script i am using to create to While loop in Stored Procedure.
But TeraData Studio is giving me Syntax Error:
can we use loop in Stored Procedure or is there any other way to do that.
Kindly suggest.
        IN i INTEGER,

Looking for Teradata job in USA
              please help me.


What distinguishes set processing from row processing?

Set processing normally applies to primary key operations.

Set processing is unsupported by Teradata Utilities.

Set processing efficiently updates large amounts of data.

Set processing is seldom an all-AMP operation.


Can any one answer my Question...How can we connect (Different Oracle, Teradata) multiple database servers to join the tables from both DB's

In our database we have a system-generated ID that is built off of the timestamp. It’s not a date or time format, it’s a string, like (20130405103422), which is essentially the year, month, day, hour, minute and second that the record was created. I want to join it to another field, which is date, but I need to convert it first. How do I do that

Explain Fast Load in Teradata?


What is Teradata & how does it differ from other conventional Systems?


Hi Team 


While performing calculations I am facing some precision issues between output from Oracle and Teradata.Please Help.


-- Oracle

SELECT ROUND((((3.82/23.88)*23.88)/767),2) FROM dual




-- Teradata

Hi Team 


While performing calculations I am facing some precision issues between output from Oracle and Teradata.Please Help.


-- Oracle

SELECT ROUND((((3.82/23.88)*23.88)/767),2) FROM dual




-- Teradata

So i've been searching all around on how i could increment a column in Teradata. I'm new to this so im not really familiar with all the syntax or tactics that i could use. 
I've read about autogenerated identity column, OLAP and recursive in teradata but i think it does not matches my need. 
So here's my problem.

Hello Experts:


What's the difference between NOT IN and minus  in SQL? 


Which is better to use in SQL queries for the performance aspects?

Can we ALTER/add/delete the partitions created on CP(columnar Partition) table? Please specify the way to do so, if any.
If at any point of time after the CP table is creared, can I delete/add any columnar partition to the exisiting table? Or the table need to be recreated?

I am very new to teradata. Please help me. 
Is it possible to connect to teradata using Entity framework 6.0. 
If so, is there any sample application or source code(some kind of tutorial) for reference.
Previn S

Every tried to figure out the exact ETL/ELT process that is running some sql statement from within the database..... good luck with that!

Query Banding is part of Teradata's workload management features BUT can also be simply used to trace exactly what process is executing something.

id   16hex   
aaa  28E1
id    decimal 
aaa   10465

How did Teradata get its name? Does mistletoe grow in parse trees? If there are “virtual AMPs” are there “virtual Watts” as well?