150 - 200 of 299 tags for teradata

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?

Dear All
I have recently moved from Windows to Mac and am trying to get used to the change. At the same time I am new to Teradata and want to learn it. I have installed Teradata Studio on Mac but I am unable to create a database connection and database to start working on it. 


Locations: Northeast US, Phoenix, Washington, D.C. Area, Atlanta, Chicago, Dallas
Apply now: http://ow.ly/hwvLP
General Description:

Permanent Teradata Modellers and Testers required for Ireland. Client willing to hire candidates requiring Visa/Work Permits as long as your communication is strong.
Please send your CV to me shaz@lightbulb-recruitment.com

Hi everybody,
Could anybody tell me how TD analytical functions are implemented under the hub?

I'm new to Teradata and have a question on creating a table with a CPPI.
I have a table with a few hundered million rows. I want to create partitioning on a column called SAP_CODE whose structure is always four digits. The first digit is alphanumeric the last 3 digits are numeric, e.g. S001, M123, Z012.


A third party vendor has developed a data mart application for us and now they are deploying it.  This is a cloud based 

application using Informatica 9.0 and Teradata 13 database. The source data files are comming from different locations

I have a long script Teradata SQL in SQL Assistant 13.11 that has about 20 places where a date is used, each time I run it, I need to change the dates manually & want to name the Date at the Start & add the variable name instead of the date to save work (& mistakes).

Hi i have written a script in bteq .
The queries execute fine but at the end the scripts exits with below error.
*** Warning: EOF on INPUT stream.|
*** BTEQ exiting due to EOF on stdin.|
*** Exiting BTEQ...|
*** RC (return code) = 4 |
How do I resolve this error.I have also tried adding :

BluecubeIT Provides Teradata Course Training Online  with  the Best  Placements according to the students. Online Training programs are taken by Our Experts with complete life time experience. Well, We have taken the initiative career objectives of the students to work with our clients which provide useful it Training Programs.


Hi Teradata gurus,
I have developed a process in Java that read some files, add some fields, and load in some pipes to my TPT script.
In my tests I'm loading 6 pipes with 6 separeted Threads.
To load this I have these Producer Operators:

I need help with this issue.

Dear All,
Anybody remember the SLJM windows client for SLJM? it was a win32 application, and could read job status from SLJM configured on Unix. Anybody knows where I can get it from?

Hello, Everyone

I just want to know if it is normal that executor.exe uses 40% above of cpu.


hi All we are providing TERADATA ARCHITECTURE Training.

The key points of our training is

+ Experiance Trainers

+ Online Training

+ Flexible timings

+ Real Time Project Explanation


Visit US : www.onlineinformaticatraining.com



Playing with some engine designs that require volatile tables structures based on existing tables structures on a system. The number of unique table structures is very high, so minimal customization should be required or it becomes a sustainability problem.

Very simple example: 

Hi All! I need your help. How do we create Master and Working Repositories in Teradata that ODI would connect to? We need to create a development environment that would mimic the above set up. How can we go about to do this? Thanks in advance!


How does TPUMP behaves if we have 2 rows with same UPI key in flat file?

Is there any method it choose order of data while executing tpump?

I have flat file with data as:


ID | Name

1 | A

1 | B