150 - 200 of 251 tags for teradata

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!

Hello,

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

 

Hi!

I am a beginner concerning the Teradata. I was trying to find simple descriptions on the internet about functions QUALIFY; RANK; OVER; PARTITION BY - unfortunately unsuccessfully. I coudn't find a simple explanation what does each of the funcions do.

Can anyone send me a link or give a explanation about this functions.

The Teradata Named Pipe Access Module (NPAM) provides an inter-process communication link between a writer process (such as FastExport) and a reader process (such as FastLoad).  The NPAM can also be used by Teradata Parallel Transporter (TPT) for data transfer activity.

This article discusses the Fallback file that is used by the NPAM.

I'm working on architecture diagrams to illustrate Teradata in an environment that includes Microsoft, Oracle/Sun, IBM, HP, and other technologies. I can find Visio shapes for all these platforms at www.visiocafe.com, but none for Teradata.

 

Hello,

 

Is there any tool or method or something else which can help me with analysis of the process.

The process contains around 15 steps and each job step is represented with one SQL script. I am working with Teradata.

Online Teradata Training Provide low cost Teradata trainig with high qulified Proffesional IT employees

We offer comfortable trainig times for Students and both students.

we have certified traineers in teradata training

Our course fee is too low compare to other trainig institutes

Hi All,

I am a new member to this forum.  I am currently working on Mainframe Technology(6 yrs) and looking for a technology change.  Please let me know how to start and what are the advantages/opportunities I would have with this change. 

Regards,

Saheel.

Hi all

Am done with some trainings on teradata. am still giving some reading.

 

I want to know the roles and responsibilities of a Teradata Developer with 3 - 5 years of experience.Would be helpful for my preperation.

 

Thanks

 

Windows setup: tdodbc__windows_i386.14.00.00.04.zip (tdicu, TeraGSS, tdodbc), Python-2.7.3, pyodbc-3.0.3

 

I am able to extract data from using tdxodbc.  The following piece of python code also works fine -- 

 

========

>>> import pyodbc

Here is what I have that is causing the error........

 

CREATE MULTISET TABLE DLAB_MARKETING.Click,

NO FALLBACK,

NO BEFORE JOURNAL,

NO AFTER JOURNAL,

CHECKSUM = DEFAULT,

DEFAULT MERGEBLOCKRATIO

(

AccountID INTEGER,

OYBAccountID INTEGER,

JobID INTEGER,

I am trying to import some data and it keeps giving me a format error. Is this because I am not including the column headers? Thanks for the help!

I need some help as to how I can import a .csv file with the date format as MMDDYYYY so that it changes to YYYYMMDD. I know you can do a INSERT INTO table.name function and add the FORMAT(column name) function, but I am not exactly sure of the syntax and how to correctly do it. Any help or guidance is appreciated.

Hi!

First, I would like to appologize to those who will find my question too general or even maybe irrelevant to the forum topics that can be found here, but I need to ask these questions.

I just got a job in a Telekom company that is using Teradata. I have a few assignments that have to do with ETL processes.

Hi,

We are trying to do a EntityManager.MERGE operation in JPA and trying to retrieve the ID generated from the identity column but Teradata doesn't return the ID like Oracle does. is there any way of pulling the ID back from the JPA transaction.

Hi

The environment my Windows app runs in has recently changed and uses LDAP as the authentication method for connection to the Teradata warehouse.

But I'm really stuck, I am unable to connect using my app now.  I can connect ok using the Queryman application, using the same User ID and Password values, so I know the connection is possible and queries will run and return results from the Queryman application.

My ConnectionString looks like this:

I have a table with a column of alpha-numeric data the currently has multiple (periods) "." and spaces in the string.

I need to remove them for data compare in another DBMS.

I have searched not only through this forum but others as well and can not seem to find the solution.

is looking for opportunity accross Europe or USA.

Germany, Austria, Switzerland, Sweden, UK preferred. Available since 1-st July 2012.

more : http://at.linkedin.com/in/eduardperschala

 

The Teradata Named Pipe Access Module (NPAM) provides an inter-process communication link between a writer process (such as FastExport) and a reader process (such as FastLoad). The NPAM can also be used by Teradata Parallel Transporter (TPT) for data transfer.

The reader process will initialize the NPAM module via an Initialization string and this article details the various parameters that are initialized during this process.

The Teradata Named Pipe Access Module (NPAM) provides an inter-process communication link between a writer process (such as FastExport) and a reader process (such as FastLoad).  The NPAM can also be used by Teradata Parallel Transporter (TPT) for data transfer.

This article details the different modes in which Named pipes are opened and used by NPAM for data transfer activity.

What is the best way to convert 'yyyy-mm-dd' to the Teradata interger storage of a date? (yyyy-1900)mmdd

 

For example:

If my date was April 1, 2012 and it was stored in the database column in the format 'yyyy-mm-dd'.

This is what I am trying to get: 1120401

Hi,

I  want to load special characters to teradata table. Can anyone tell me reqiured settings for that!!!

 

eg: say my source contains following data.

aqwwe!@#(~

 

 

 

Masters,

 I am trying tofind if any one used session-specific volatile or temp tables from Data stage - (TD connector stage) on Teradata ?

I was told by my ETL folks  given the parallel nature of DataStage in that it opens many independent Teradata sessions and hence we cannot use volatile tables ! Did nay one used this ?

Hi Professionals,

We have some Informatica Mload jobs running daily and weekly

since yesterday we are facing some job fails in production due to the below error

we did not change any thing all of sudden we got this issue.

 

Hi everyone! I am currently studying Teradata and currently working on this problem of mine. You see, i have this set of data on a flat file that needs to be loaded in a table based on a condition.

This is what my flat file looks like:

##Flatfile
SOR|03/17/2012|2 -- This is a header

Hi all,

anybody Using Datastage 8.1 version  with Teradata database 13.10  ? please let me know.

Thank you

 

Suprisingly, I'm not finding many examples of this out there.  

I have a table like:

 

id  foo

--  ----

1   yes

2   yes 

3   no

 

i want a 1 row result set like: 

bar

----

1: yes, 2: yes, 3: no

 

Hello!  I'm new to the forum, nice to meet you all. 

I want to Update and Insert when a condition in the case was true. However, it seems that Teradata doesn't accept it. My question is, is there a way for that to happen?

Like

 

CASE WHEN SEL Table1.Column return TRUE

THEN UPDATE Table2 AND INSERT Table3

ELSE

INSERT Table2 AND INSERT Table3

END

Is there going to be a release of SQL Assistant that can be installed on Windows 7 64bit?  The Java version doesn't work very quickly and is cumbersome to use.

 

 

Problem statement:

 

We want to set custom SQLSTATE in Teradata stored procedures. The only way to set custom SQLSTATE value is through external stored procedure.

 

Dear All,

I am trying to create an external stored procedure using JAVA but keept getting NoSuchMethodException.

I am using windows 7 to compile and create the JAR file (client)

My teradata is running on SUSE Linux(server)

My java class is:

Hi all,

 

i am trying to load data in my database using informatica but getting the error that is placed below:

 

Hi all,

 

i am trying to load data in my database using informatica but getting the error that is placed below:

 

 Execute Direct -- [Teradata][ODBC Teradata Driver][Teradata Database] An owner referenced by user does not have INSERT WITH GRANT OPTION access to BATABASE_NAME.TABLE_NAME.ID.Unable to get catalog string.

 

Delta Community Credit Union is hiring for a full-time Senior DBA position managing a large Teradata warehouse and a set of SQL Server application servers.  Experience in Business Intelligence preferred.  Great compensation and world-class benefits at a small company within the Delta family.  Come check it out!

 

Hi,

 

How to get "View vs Table dependency" from dictionary tables by simple querying them? Query needs to list the table names  used by a View. It is possible in Oracle using dba_dependencies and similar table to get the list of tables used by a view. Please advice.

Karteek

hi

I am new to teradata and learning it as my projet requirement. I am basically an Informatica guy. So an I get a teradata database on my laptop so that I can have a hands on learning.

Kindly give a detailed anwer.

Thanks.

Greetings,

My application works on Teradata client. I dont have access to server and hence i do not know what operations can be done at server . For e.g., at client side, DB updations , running macors n stored procedures can be done at client side. What else operations can be done at server side?

 

I'm adding up totals within a database and would like to see how the totals change over different time periods.

I'm using this code:

<code>

Select Sum(CASE WHEN Offer_1 = 'Y' THEN 1 ELSE 0 END) as Offer1,

Sum(CASE WHEN Offer_2 = 'Y' THEN 1 ELSE 0 END) as Offer2,

I've contacted many people within my company who use SAS, but I can't figure out how to resolve my issue and am running out of places to turn.

Background:

   Datastage8.1 install SUSE 10 64-bit

   Teradata install vm on SUSE 10 64-bit

In the DS server i install the TD ODBC driver. also used the ./adhoc can connect to the TD  and can execute the SQL command. but i don't know two the configuration the ODBC and the env on the DS server?

 

Top Tier Financial Client has Multiple positions open for Data Analysts. Multiple Locations. Immediate Interviews. Read below for Details.

Locations: Richmond, VA / Mclean, VA / Plano, TX

The job description:

I have a column that has both numbers and texts in the fields.
Examples:
xyz 120 abc lmnop
xy 120
120
Null
?/ 567 abc
.... 233

As you can see the fields can have numbers, texts, special chacters, null values, etc. If there is a no numbers in a field I want to return null for that.

Hello All,

We have a Unix C application that connects to Teradata as backend. We are currently migrating from HP-UX to AIX. The exe which is working fine in HP-UX, is dumping core in AIX.

We have re-compiled the code in AIX successfully. We are getting the following error when we try to run the executable -

The 32 bit executable needs to be re-compiled as 64 bits. The exe compiled successfully, but it is dumping core when trying to login to Teradata -

IFMXcomm[21] = 14
IFMXcomm[22] = 9
Before Proc OpenDB 0 1311723748 41
In open Teradata DB
Teradata system: qa
qa

Hi Teradata Experts

Here is an Interesting opportunity for people with expertise in Teradata Development.

Here is the Job Description :

Designation                                       : Software/Sr.Software Engineer
Experience                                         :5-8Years.
Location                                             : Hyderabad
Education Qualifications               : B. Tech/MS/M.Tech

Skills/Expertise Required:
Strong Teradata SQL writing skills and Teradata SQL tuning concepts (Must)

Ok the setup is RHEL 5 with unixODBC 2.2.11 python 2.4 using pyodbc 2.1.5

I have followed the instructions located here:

http://cjgoldsmith.blogspot.com/2011/03/teradata-odbc-python-pyodbc-on-fedora.html

To try and get this working but with no luck. I can get sql server and mysql working and everything like that but just can't get teradata to work. I've tried downloading and using the 13.0 bundle and the 13.10 bundle linking the files and everything like that. When i look at the trace it looks like this:

[code]
ENTER SQLSetEnvAttr
SQLHENV 0x13a13830

Hello,

I have an issue regarding a group by for my query: Error 3540

I understand what it means on a basic level and I believe the issue revolves around this particular column

CAST((COALESCE(price, 0.000000)) AS DECIMAL(18,6)) * quantity amount