0 - 50 of 232 tags for teradata

Hi,
I am new BTEQ and scripting. I am checking if my source data is updated or not before i am updating my petspace tables.
Sel 1 from SOURCE_TABLE
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.
Thanks,
Dinesh

Hi,
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 ?

Hi,
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.
 
GET DIAGNOSTICS v_Variable_Name = ROW_COUNT;
 

Hi,
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>.FIELD COLUMN1 * DATE;
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.

Hi,
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 :

Hi,
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 14.00.03.02.
 
Parth

Can Anyone Suggest me where teradata jobs are available.
 
        Please..........

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.
Example: 

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

Hi,
Am looking to find out where does the Checksum metadata values of the datable got stored.
Here when I run a query
CREATE TABLE "ravi"."Table1", FALLBACK , SINGLE BEFORE JOURNAL , CHECKSUM = HIGH (
        "Column1" CHARACTER(5),
        "Column2" CHARACTER(5)
    );

Hello,
 
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.

Hi,
 
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.
 
Parth

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
  RequestedSessions
  SessionsPerPlayer

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.

Hi,
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.
CREATE PROCEDURE proc (
        IN i INTEGER,

Looking for Teradata job in USA
 
              please help me.

1.

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

--0.000

 

 

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

--0.000

 

 

-- Teradata

Hi, 
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?

Hi, 
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.
 
Thanks
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.

hexadecimal--->decimal 
 
id   16hex   
aaa  28E1
 
 
Result:
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?

Hi,
 
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?

Hi
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
TO_CHAR(CAST(CAST(c_timestamp AT TIME ZONE 'America Mountain' AS VARCHAR(19)) AS TIMESTAMP(0)),'YYYY-MM-DD HH24:MI:SS') AS C_TIMESTAMP_MDT

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.

Hello All,
 
Teradata Utilities are specialised tool for loading or exporting huge volume of data as compared to conventional SQL tools like SQL Assistant & BTEQ. I wish to learn the fundamental performance gain reason between them. I have provided my understanding on them below. I would appreciate any addition/correction to them.

I have a table to be updated having 3 columns ext_JobGroupCd,ext_JobCd,ext_OrderIngroup

I am a newer to teradata database, and I want to study teradata database systematically all the time by a classical book about teradata. But I could not find such that book as introduce teradata. Can everyone recommed one book to me? it is better to tell me where download it. Thanks very very much .

Hi,
 
We are using Teradata Parallel transporter (TPT) loaders as both source and target connection.
 
     Source     - TPT Export
     Target      - TPT Load
 
Using that performance has improved significantly compared to relational connection.
 

Does anyone know how to connect to a DB View with OData service in Visual Studio?