0 - 50 of 237 tags for teradata

Hello Seniors


I presume Teradata Corporation is a CMM Level 5 company and ISO certified too. Teradata has launched an ADC at India.


Can any one please guide me or share any link, what is ISO certification level.


Any further information about Teradata Corporation at India would be helpful.


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?

In my server I am running TD Express for VMware, version TD14.10. I have created several users and have no relevant data there (its a sort of sandbox for some users).
I would like to create all the users and keep the same passwords. I am guessing that this could be done exporting and loading some tables into TD15?

My PreSQL query in the WorkFlow of Informatica had 2 parts, 1.Insert query 2.Refresh Stats procedure call In the absence of a ';' between these 2 parts gives me record count in Millions but in the presence of the ';' it gives me record count in Thousands.

whenever i run any query in terdadata, i am getting blank result in columns having VARCHAR or CHAR data type. using windows 7.  please help if anyone have idea. not able to understand why CHAR values are not showing in the answersheet result?

I need to convert these statments from using  AT TIMEZONE to FROM_GMT2.  Help is very much appreciated
c_timestamp is a column of timestamp(0) type

Hello All,
The way I see Teradata is...Node contains multiple PE & AMPs. PE handles the user sessions in addition to other activities and AMPs service the data movement amongst other role. Considering a production system having say, 50 Nodes...I seek clarification on the following 02 topics:

Hi All,
I want to install teradata on a linux machine. 
1) Do we have a teradata version directly for linux or do we need to install a vmware player in linux and use teradata for vmware player.