150 - 200 of 319 tags for teradata


We currently use Teradata version 13 and have no issues connecting to Unica version 6 via ODBC connection.



I am new to Teradata and I am working on query for which I greatly appreciate any help.


i have data in a table as shown below:












Looking for someone long term who has skills in the following areas:
Netbackup for Teradata (TARA)
Installing Teradata Tools on disparate platforms
Proficient on Arcmain
Sioalris and LINUX Administration
Pass a background check: Must have been in the US physically working for the past 4-5 years+

Hi all,
I am building an SSIS package in SQL Server BIDS 2008 version to pull data from Teradata and dump to SQL Server.
1. I am able to connect to Teradata sucessfully as Source.
2. Connection to SQL Server as Destination is also good.
2. When I am running the package I am getting the error
*********  ERROR *******

I am not sure if this is the right category of the current issues we are facing right now. Unity Director had been implemented in our client together with the Teradata database implementation. I am not sure if this is a verified bug but below are the current scenario we are facing.

Hi Experts,
As per one of the requirement , we are making one column as CHARACTER SET UNICODE CASESPECIFIC.
But as we know that in Unicode too we have two types of character sets UTF-8 & UTF-16.
Can we know some how which one  (UTF_8 or UTF-16?) would be created after making the column as UNICODE?
Thanks in advance!

In a script, at Session level the transaction isolation is set to RU (Read Uncommitted or ACCESS).
At table level I am overriding to READ lock for Table1 in a SQL select.
Now if there is already an INSERT / MERGE / UPDATE operation going on Table1 then it will be on WRITE lock. So the SQL with READ lock will wait. 

I have source data froma a table in the following way 

Source  Data table 

Date_key          Location       Vendor           call_cnt

2013-09-09      Highlands         att               1500

2013-10-28      Highlands       att                 200

what would be the code to count the number of words in a phase using Teradata SQL without using the oreplace function as I do not have access to this.
Thanks in advance.

Hi Masters,


This is a Hadoop/Teradata scenario. I'm looking for advise for a data migration from Hadoop to Teradata. The source data is supposed to be coming in form of delimited flat files. What are my best options for migrating data with best performance.


I'm generally more of a forum lurker, but every once in a while I get something working that doesn't readily work out of the box the way you'd expect and feel that its worth posting about to ease the path of others (and maybe leave a trail for Google to scan so I don't have to remember where I left my notes!)

We have several queries that sometimes get stuck in response mode. Is there a way to real time see what the queryid is of a query that is currently in response mode? Using the following:
SEL a.*,
FROM dbc.qrylog a
     LEFT OUTER JOIN dbc.qrylogsql b

[Teradata][ODBC Teradata Driver][Teradata Database] Incorrect referential constraint definition.
Execution Failed!
ALTER TABLE Failed. 3976:  Incorrect referential constraint definition.

Dear Sir/mam,
Our company has just started to use teradata appliances. We have 1 cabinet with 2 node of memory &  1/4 disk that will be used for development environment.
however we need another environment with 4 node & half disk.

Hi Guys
I am working on migration from Oracle to Teradata. I am facing few issues there. I would be glad if some one please clarify below questions.

Hi All,
We have define a coulmn as CLOB in a teradata table as we have to load it from a CLOB column from Source(Oracle), but
during loading it from API/Uitlity mode in Abinito, we are getting an error and load is failing.
I belive we cannnot load a CLOB column thorugh utility...
Work around -->

Recently we were forced to build out a new instance of Teradata V12.  During the "configuration" phase of the install.  I get to the step "Run Config and Reconfig".  The Config steps runs without issue however when it goes to run Reconfig it throws an error.
If anyone has run into this and knows the answer please let me know.

Is it possible to combine two heterogenous sources and load into one particular target. If so How using TPT?
Ex: I'm combining data from Oracle and DB2 and loading into one Teradata Table.

I have requirement where i need to send mutliple files based on the data. Our enivroment is Unix and teradata.
EG: below is table with sample table.
C_Name   ID
xxxxx        1
yyyy          1
aaaaa       2
bbbbb       2
ccccc         1

I have a dynamic stored procedure with an if statement setting a stmt to include in my insert statement. I will only share a portion of the code, enough to get the idea across.  The procedure compiles correctly, but when I validate my if statement this error is returned:

I am developer and I am new to TeraData

I downloaded the TD14 VM (40GB) and I started it in
VmWare Workstation 7.1.1
(I do not have a WmWare Server)

Now SuSe linux shows a login dialog.

What can I do to start the database and to connect to the database ?

Hello all,
we hav a large table (CDRs) with PPI defined on timestamp containing date & time when a record was loaded in DW.

Alright. So I looked at this page: http://developer.teradata.com/doc/connectivity/tdnetdp/14.10/webhelp/EntityProviderCanonicalFunctions.html. It mentions that canonical functions for .NET 4.0 are supported under the "Teradata" namespace. Where in the world is this namespace?

My requirement is to validate whether the given string format is valid or not.
VARCHAR(8) is the data type.
First 2 characters should be characters and the rest 6 characters must be integers
Ex : 'NA123456' is valid but 'NAA12345' or 'N1234567' is not valid
Can you please help me on this.

Hi, I am able to create the cubes using the TDOLEDB provider in Analysis Service and only come across the following error when processing the cubes. "The provider 'TDOLEDB.1' is not registered."

I am running the following configurations

- Windows 7

- Database: Teradata on VMware

Im running with the spool space error when im trying to insert into a table based on the selection i do on the join of a fact and few other dimension tables.
Following are the details:
1.      Problem Description

Xcel Resourcesis one of the leading top Training and Consulting
Company in US, with a good placement track record. We have
certified trainers. We will provide Online Training, Fast
Track online training, with job assistance. We are providing
excellent Training in all courses. Faculty from top MNC’s

Has anyone successfully used the Teradata driver with LDAP authentication in the ETL tool Talend?

Good online training offers the best Teradata online training with the industry experts as their trainers. All the experienced certified tutors will share their experience, tips and tricks in the SAP SD Online training course. We will provide More informations please contact us :

 Hi all,
Can any one pls share any doc or case study or if some one can explain the process how to set up the standard archive & Purge main frame jobs in teradata ?

Our client has an immediate need for a Teradata Aster Architect.  The position is a consulting opportunity and can be based anywhere near an airport.  To learn more, please contact me at:  tom.miller@careerbuilder.com

      I was trying to install Teradata(Teradata Express (ami-99f65af0)) on aws its installing properly and working fine but it’s have only 76GB disk space and i want more than 100 GB disk space.

Hi gurus,
I have an application where i have to download data from Teradata into SQL Server, update data in SQL Server and push it back to Teradata server.
I am able to import data from Teradata into SQL server using SQL Bulk Copy. I am trying to see how to push data to Teradata.

I have a table which has a column where I can find special characters like &Altide; &Abc; etc. The total list of special characters is 110, I identified them using the logic anything between "&" and ";" is a special character and finally cross checked manually. Now I need to find and replace them in my table with space(" ").

Hello Everyone,
I was creating diffrent tables in database by taking year and date from the users with the help of '?' character but the problem is

We have multiple openings. Teradata industry model background is preferred.
ERWin is required. Must be current and strong experience. Any Teradata Utilities experience is a plus. 3-6 months, extendable long term

Hi Friends
I am new to this forum. I hope this is the right place to post below questions. I am preparing for TD Basic certification. While doing so I stumbled on two questions. Here are they.
1. Which component is part of Teradata's open architecture?

Hi all,

I am new to TERADATA DATAMOVER. I am looking for any supported material regarding it. Any help would be appreciated.

Thanks and Regards,

Install Teradata Client on Unix Sun Solaris SPARC and general x86 machines

Hi All
I'm trying to implement Oracle REPLACE() function in teradata using SQL statements only. I searched the forum , but found Oreplace() UDF as the only solution.  Can someone help me in implementing this is pure teradata SQL  ?? 

I need to load a file using mload where  the load clm has a data like this 03/29/2013 12:00:00 PM.
select cast(cast('03/29/2013 12:00:00 PM' as timestamp(0) format 'MM/DD/YYYYBHH:MI:SSBT') as varchar(22))
I need it to load as Timestamp rather than varchar

I currently use SQL Assistant to write Teradata tables to existing MS Access tables by using the SQL Assistant "Export Results" File option. The problem is that I must manually direct the output to the specific table in SQL Assistant and there are 30 tables that I need to reload each month.


I'm trying to run a macro during a connection or with teradata using SAS and when I run the code I'm getting the error. What can be the reason? Error in teradata?

Hi all,
We are migrating from oracle to teradata, and got stuck with dense_rank function, please any suggestions would be appreciate. 
Here is our query in oracle: 



COALESCE(columnA, 'Other')

from  tableA

I have a requirement to update the duplicate records in teradata. For E.G. if col, col, col, col have same values in the table, those records are regarded as duplicates and duplicate flag needs to be updated as '1' for all those records.

Any suggestions on how implement this logic?

Hi there,
I am looking into the potential storing RDF data to Teradata?  General I called the database designed to store RDF data as triple store or RDF database.   Did anyone of you store RDF data direct to Teradata?