0 - 50 of 297 tags for teradata

I am using teradata vesion of Prestodb 141t to connect to different data sources and one of my datasource is teradata but there aren't any documenatation about the connector. Does prestodb have the ability to connect to Teradata? If yes, how could i set up my connector?
Thanks, Siva. 

I have a unique scenario for which I would like to build a SQL to get desired result. Could you please help me find a SQL solution for this.
Here is how my data looks. here are 2 sets of records .. 
Col1         Col2 
111          222
222          333
333          444
444          555

I have a SQLSERVER 2012 database running on a Windows Server 2012 platform.   I have installed the Microsift Connector for Attunity Version 2.0 and in SSIS I now have Teradata Source and Destination tools available.  I have created a connector to the database and table I which to use in my SSIS package.  The connector works and it allows me to preview the

Is there any easy way to find out any DELETES happened on a table or not with out parsing the qrylog table.
Do we have any dbc tables that captures this information.

Hi All,


i tried making two sessions in fasload 1st got passed with inserion and 2nd didnt showed any such behaviour.
so why cant we have multiple sessions in fastload to load multiple tables?

There are 3 locations. DBC.ColumnStats, DBC.IndexStats, and DBC.MultiColumnStats where the information for the stats used to get stored.i'm giving the below query to find that info regarding no of rows in a table or average row size  etc.

Untitled Page

I have a data set in oracle (img1 in attachment)








I am facing an issue in executing below scritp  through fast load utility for tab delimited .txt file
1. First issue in .RECORD 1;

This is the MYSQL query, now I need this below dynamic query to be execute in TERADATA SQL.


    set l_sql=concat('SELECT max(',l_rid_col,'), MAX(cid) INTO @c2, @c3 FROM ',p_database,'.',p_table);
    SET l_rid = @c2;
    SET l_cid = @c3;

And this update query:


Hi I have just installed Teradata in my local Machine. 
1. How do I know my username and password and connections etc..
2. How do I connect to any database? if I have to create one on my own, how do I do it?
Kindly help me. Thanks

We have a a number of processes where in we transfer the data from SQL server to TD. We extract he data as files & then dump it using Fastload. Just wanted to know is there any other process we can experiment to make this load any more faster ? The record number is a bit high so takes around significant time.
Hope I made myself clear.

I have a 'Dob_Date' column with date format 'dd-mm-yyyy'. I need to extract the year from it and
need to add year+1(i.e Adding one year) and insert that into another column named 'Modified1_date',
need to add year+2(i.e Adding two year) and insert that into another column named 'Modified2_date',

The OBIEE Sample Application is a fully functioning OBIEE environment available on a VM.  It is self-contained in that demo applications can be run against data stored on the VM.  It is possible to modify the VM so that external data can also be accessed and shown in a demo or used for testing.  This article shows how to mod

Aster AppCenter provides the citizen data scientist the ability  to run a different type of analytic.  

Hi All,
I want to use ACTIVITY_COUNT   with  DBC.SysExecSQL to get how many rows updated by the query executed in DBC.SysExecSQL.
Can anybody help me in this. 

Dear all, 
I would like ti create a DB Link from a Teradata database (v. to an Oracle database (10g) but the Create DBLink query doesn't work. I have looked on the Internet about this, but I didn't find anything relevant about it? How should I proceed to create the link between the two environments? 
Thank you in advance

Hi All ,
Please help me to download Teradata Tools and Utilities 15.10 for Linux / Centos6 . Please give me a link .

Error Using teradata client for centos 6/7 php/python/unixODBC

Hi All - 
Thanks for taking time to read my question / post.
I'm a beginner in using Teradata and after searching the web for any insight or guidance, I'm still lost.  
How do I customize the format of the column results that I query below pertaining to an item UPC...
** For Example **

I need to query a teradata table by referencing a column that is of type Timestamp(6). I'm not successful at getting the right format so far. What do I need to set the Size, Precision, and Scale values to for this to work. (By size, precision, and scale I mean these parameter values in Visual Studio's Dataset Editor)

Community Edition is a SUSE Linux Enterprise Server (SLES) operating system and Teradata Database packaged into a virtual container that runs in a VMware vSphere ESXI virtualized environment on third-party hardware. Community Edition software consists of a template and associated property files and scripts. When a Community Edition virtual machine is deployed, it operates as a fully functional instance of the configured Teradata Database. Once deployed by the VMware administrator, Community Edition can be used to evaluate Teradata Virtual Machine and the Teradata Database.
Note: You must have administrative privileges on the destination VMware environment to install and configure Community Edition virtual machines.

Dear All, Need help with below situation....
id        date
100   6/6/2015
100   8/1/2015
100   9/30/2015
200   8/11/2015
300   7/18/2015
300   1/10/2015
300   3/5/2015
300   6/15/2015

I am trying to understand how Datastage interacts with Teradata in Immedaite mode. During my testing, I created a Datastage job with TD connector as  source and destination to just select from one table and load into another table. 

Hi all,

If you are user DBC or user TDWM and you log onto a Teradata Database, you might get treated somewhat differently than other users.  This posting describes what user DBC and user TDWM do, some of the special things about them, and when you can expect them to get treated differently.   We’ll also look at any implications in setting up workload management for these two special users.

I have a query with a UNION.  I was trying to combine 2 records into 1.  The top half gets records from 1 set of tables and the bottom half gets records from a differen set of tables.  Both halves use fields from 2 derived queries.  The results currently look like this:

I am a newbie in Teradata. I need to check a date column has valid date in case statement. This column is in "YYYY-MM-DD" format. If this field is invalid need to use '1900-01-01' as default. Can anyone please guide me on this?

Hi all,
there is a requirement of copying all the tables with data from one db (may be dev) to another db ( Test) .
It can be done as below :
a) Utilizing the metadata tables for creating the automated  create table statements  as below :

Hi all,
I've got an interesting issue going on with Teradata. Suppose I have a table tbl with columns col1, col2, col3 with col1 being the primary key.
I can run 

Select * from tbl where col2 like '%abc%'

However, if I attempt to run the following:

My data looks something like this:
ID | Line | Code
1 | 1 | a
1 | 2 | b
2 | 1 | d
2 | 2 | e
2 | 3 | f
Code | Name
a | alpha
b | beta
d | delta
e | epsilon
f | phi
A common join brings the following results:
ID | Line | Name

Hi ,

I am using a Stored procedure in teradata , in which multiple updates are written. I want to generate log file for Stored Procedure. so that i can come to know how many rows are getting updated by each update statement.

is there any why to implement this. 

Hi All,
       I have faced a scenario recently where the DELETE statements are going into RESPONDING state. I am aware that the sessions which run SELECT will be going into the RESPONDING state if the result is being written into a file. 
I have tried to find the root cause. But couldnt find. Please help me out with this.

I'm attempting to connect MS Accses to a Teradata table with the intention of viewing an object in a BLOB field I have stored there. 
I'm connecting Access to Teradata through a System DSN connction using Teradata driver
My method was to link the table in Access to Teradata through this connection.

I have the following table with columns:
id     fr_dt       to_dt      price
The idea is to find minimum price for overlapping periods and for non-overlapping periods, show the price. The final output should contain non-overlapping periods spanning from minimum of the fr_dt and maximum of to_dt.

Hi all,
Can anyone let me know which all settings are needed to be optimized in DBS Control Settings. Can u list down those which are recommended.? i have gone thorugh in Teradata PDF of Utilities. Need Just the Useful One.
Also PLEASE let me know from where (LOCATION) can i open the DBS Control Settings? I have a Unix Box Environment. 

This “Teradata Basics” posting describes the current dimensions of parallelism in the Teradata Database, and how they work together.

Hi Everyone
Pls help me in solving teradata sql query. I want to know the total YTD active buyers on my website. which includes the buyers for first time (FT)also  the returning buyers(RB). 

i.e. January should have FT (Jan) + RB (Jan)

Feb = FT (Jan) + FT (Feb) + RB (Jan+Feb combined)

Oracle BI Enterprise Edition (OBIEE) 11g Configuration and Integration with Fuzzy Logix DB Lytix™ On Teradata

This article describes how to integrate Oracle BI Enterprise Edition (OBIEE) 11g with Fuzzy Logix DB Lytix™ 1.x on Teradata to enable transparent OBIEE end user access to the advanced analytic functions from Fuzzy Logix.  Fuzzy Logix’s DB Lytix™ 1.x includes libraries of in-database models that run deep inside Teradata Systems.  Use of these models allows execution of analytics within the database, leveraging the performance, parallelism and scalability of Teradata system while dramatically improving the performance of analytic results and simplifying the integration of analytics into existing reporting and analytic applications.

Hello ,

how can i have access Ex:select on view/table from a local database server to a distant database server, with same session ?


I have a table with the following layout

cust_acct_id (PK)| effect_dt | expiry_dt | curr_rec_ind | field_a | field_b | field_c | field_d

I have to populate any NULL values in field_a, field_b, field_c, or field_d with the most recent value received for that field for the same cust_acct_id.

Sample Input:

I am new to TD SQL environment and learning the differences as I code.
I wanted to know if there are any resources available (other than TD DevEx) which explain the differences within TD SQL and MS SQL e.g cannot use variables except in SProc, temp tables vs volatile tables etc ?
Thanks in advance,

Can you give example for User defined functions/methods without external? How methods can be used for UDTs?

I am getting the below message from the log. I could not see that there was a sucessfull connect happened to the DB at all. Usually "UTY6211 A successful connect was made to the RDBMS." would be there. Its missing here and teh steps there after but directly returns error code. Please help on this.

with drvd_amts (acct_nbr, grp_br_ps_org_id, PSAmt)
sum(d.pstd_ttl_amt) as PSAmt

from psfs.ps_gl_acct_ldgr d
where d.fiscal_yr_mth_nbr between 201500 and 201508
and d.acct_nbr between 130500 and 160500

group by d.grp_br_ps_org_id, d.acct_nbr) 


Teradata Studio 15.10 is now available for download. Teradata Studio is an administration tool for creating and administering database objects. It can be run on multiple operating system platforms, such as Windows, Linux, and Mac OSX.