All Forums

Covers Teradata-developed applications such as TRM, DCM, etc. For articles, blogs and more, see the Applications section of the site.

You must login to post to the forums.
FastExport Retcode 16 Topic by alchang 23 Sep 2015

I am curious in what circumstance, FastExport will returns the return code as '16' ? And how could I trigger a sample to get the return code '16'? Thanks.

620 views
0 replies
Fast export error Topic by nimish_123 24 Mar 2015

I am running fast export through informatica. Sometime fast export is getting failed with below error. To fix it we try to re run fastexport and it is getting finished succesfully. Sometimes we need to re run twice. I am not able to find the root cause and permanent fix for it. It is strange error because workflow dont fail everytime.Please help.

2809 views
5 replies, 3 years ago
teradata production support Topic by ranga116 31 Aug 2015

senior software teradata production support  duties and  responseblities  and real  time scenarious . please some one help me 

698 views
1 reply, 4 years ago
error Topic by esharma 17 Aug 2015

Hi all,
I am trying to upload a file via FastLoad and it is giving me error-

953 views
1 reply, 4 years ago
copy paste command Topic by esharma 14 Aug 2015

Hi there,
Recently started using teradata fast loader. Is there any command for cut copy paste?
thanks in advance!
 

528 views
0 replies
713 views
0 replies
FASTLOAD UTILITY- LOADING DATA FROM CSV FILE HAVING 143 COLUMNS TO A TERADATA TABLE Topic by rcetl 07 Aug 2015

Hi All,
I have am newly using the Fastload utility for loading data from CSV file to a table in Teradata.
I am able to successfully load for 10 columns from CSV file to table .This is my Scenario1
When i am trying with an SECOND  scenario of Loading 143 columns from CSV file to a table in Teradata

1003 views
0 replies
TeraData SQLA History Partially loading Topic by JPearson 06 Aug 2015

I am experiancing an issue where the History window is only partially loading with the history that is it should be.

779 views
0 replies
Explain Plan Topic by anagpure 28 Jul 2015

The explain plan which we see in teradata by using command like EXPLAIN < QUERY> is estimated plan or actual plan ?
if it is estimated plan then where is actual plan ?
Thanks.

1002 views
5 replies, 4 years ago
diagnostic helpstats Topic by malli111 20 Jul 2015

Hi Dieter,

 

Please help in below issue.

 

diagnostic helpstats on  for session; 

It is giving zero processed. I would like to know SUPPORTDB.EMP_TEST on which column i have to use stats.

 

Please let me how to use the table in diagnostic helpstats on  for session;  statement.

 

Thanks in advance.

 

1072 views
4 replies, 4 years ago
1188 views
0 replies
Why TPT is successful with return code 0, even when records goes to ET table? Topic by ck185031 04 Jun 2015 ET table, #TPT

We just upgraded To TD 14.10.04.06 version from TD 12, and we are in a process of replacing all the fastload scripts with TPT Load.
Earlier with fastload, it used to load the good records and move bad records to ET and job used to fail.

2041 views
11 replies, 4 years ago
MLOAD returns error code 12 without logging into RDBMS Topic by nvk.kumaran 27 May 2015 teradata, mload, Return code 12

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

0003 .logon tddb/usrname,;

1403 views
0 replies
TPT export and error code 2595 Topic by ulrich 07 Feb 2014 TPT export Error

Hi,
we are getting with an TPT export the error code 2595.
Explanation:
2595 The FastExport select request has been aborted.
Explanation: The current Select request has been aborted.
Generated By: LCTExpSt
For Whom: End user
Remedy: Examine the reason of the abort, do whatever necessary to correct the problem and then resubmit the Select

1863 views
9 replies, 4 years ago
Error while loading data from Oracle table to teradata table Topic by atulkumarsharma 01 Oct 2013

Hi Experts,
I am trying to run a TPT script which aims to load data from oracle table to teradata table.On Executing the script am getting the following error:
gilderoy:/ngs/app/slsaudedwt >tbuild -f ora_tera.ctl -v para_var.sql
Teradata Parallel Transporter Version 13.10.00.12
Job log: /opt/teradata/client/13.10/tbuild/logs/slsaudt-28962.out

2971 views
2 replies, 4 years ago
BTEQ import not reading and displaying data completely Topic by javeed939 21 Apr 2015

Hi guys,
I have problem with below  import bteq script. its not displaying complete out put from the below query in the script. the query is displaying two records when ran from teradata sql assistant with ci_id values ='7264'  and mbr_id value = 00009582554 like this

ci_id         MBR_ID          ENTR_ID                         

               00009582554  163987 

1025 views
0 replies
Data Mover for Data Migration Topic by mb255021 30 Mar 2015

Hey people,
We are planning to use Teradata Datamover to migrate data from an existing Teradata system to a new one.
This is a one time data movement, that is the entire source TD system will be replicated on to the target TD system(sort of a sustitute for NPARC that is usually used by CS/GTS to move data between non connected servers)

2060 views
1 reply, 4 years ago
Need to load data from a flat file to teradata table Topic by prasanth225 03 Mar 2015

Hi,
 
I need to prepare .sh script to load data from a flat file to teradata tables. Below are the flexibilities to be handled:
 
1. The file name should popaulate as the value for the first column.
2. The columns in flat file can come in any order
3.The non-mandatory fields in a record can be missing.
 

1166 views
0 replies
FastLoad process hang with concurrent sessions Topic by jdliau 29 Sep 2014 fastload, concurrency

Hi,
We have an application spawns multiple FastLoad sessions to move data from Microsoft SQL server to Teradata concurrently. We are running the application on Microsoft Windows Server 2012 R2 and have been observed random errors where some FastLoad sessions in hung state. 

2305 views
11 replies, 4 years ago
Answerset columns containing character values are displayed as blank in Teradata SQL assistant ver14 Topic by Akhilpadavathil 06 Jan 2015

when iran i query, the resulting answer set containing colums which is having alphabetical values(for ex: names) are displayed as blank. but in actually these tbales are having alphabetical values. Don't know what happened.
Can any one please help me how to view it  in proper again

1524 views
0 replies
Teradata 14 Certification Topic by gvenkatesh89 20 Nov 2014 #TeradataV14
1850 views
2 replies, 4 years ago
Questions on Inside AMP Topic by gbansal 11 Sep 2014 amp

Hello Guys ,
 
I have some basic questions .
 if you guys can help that will be really helpful.
 

2036 views
6 replies, 4 years ago
Need help on prep for Teradata 14 TEO-141,142,143 Exams Topic by codejamster 23 Dec 2014

Hi,
Currently i am working on TD 13.0.
I am preparing for TEO-141 exam and need help with study materials.
I have gone thru some certified links to obtain books, which seem to be too costly in INdia, (INR 5700).
I am looking for these Authorized study guides:

Teradata 14 Certification Study Guide - Basics

Teradata 14 Certification Study Guide - SQL

889 views
0 replies
DCM User Group Topic by Fred Narduzzi 17 Nov 2014

The DCM User Goup is looking to use this site to share best practices for business users fo the Teradata DCM Application. DCM users would like to share business knowledge, inquire about business scenarios and share information specific to the DCM application. 

1451 views
0 replies
After devolping a script as a teradata devolper then unit test and after how it goes to production . Topic by nani_hero 09 Nov 2014

hi , i would like to know the steps after devolping a script what will be the process.
like unit test and code review and peer test and packing etc... plz tell me step by step flow with tools using .

1519 views
1 reply, 4 years ago

Pages