#DateForumTypeThreadPost
25903 Apr 2012 @ 10:42 PDTToolsReplyskip the header row in the flat file, when importing using FastLoad script Yes
25830 Mar 2012 @ 11:32 PDTToolsReplybteq export and import for _ET dataparcel If the file was TAB delimited, then the data was sent in character format (just a series of VARCHARs). So, I believe DataParcel will first contain a 2-byte record length, followed by the ind...
25728 Mar 2012 @ 01:45 PDTToolsReplybteq export and import for _ET dataparcel Well, there is a way to decode the data (we are working on a tool for that right now). The tool, however, will work with jobs run by TPT. However, you do need to know how the data was origin...
25626 Mar 2012 @ 11:38 PDTToolsReplyRDBMS error 3029: Associated LSN was not found Is this an intermittent problem? Or can you get this error every time you run this particular job?  
25526 Mar 2012 @ 10:30 PDTToolsReplyTeradata PT 12.0 error output schema does not match Please refer to the TPT documentation in the use of the 'tlogview' utility to process and view the contents of the logs. The "log" to be accessed is named with the job-id. ...
25426 Mar 2012 @ 10:26 PDTToolsReplyTPT script loading issue I do not see an error message from that output. You will probably have to look at the entire log (with the tlogview utility) to see more about why the row may have been rejected.  
25321 Mar 2012 @ 05:42 PDTToolsReplyExport large data set to CSV files It is labeled when they go to the website. I do not want people misled just by looking at the post.  
25221 Mar 2012 @ 05:33 PDTToolsReplyExport large data set to CSV files Please refrain from using the term "in house" when responding on this forum. People might get the idea that it is a Teradata product, which it is not.  
25102 Mar 2012 @ 04:47 PSTToolsReplyHadoop to Teradata Not quite sure what the questio is here. But if you are asking why we cannot have multiple "fastload" processes running from different client boxes at the same time, all loading the sa...
25029 Feb 2012 @ 07:33 PSTToolsReplyTeradata PT 12.0 error output schema does not match 1. Each "Apply" step in a TPT script is a separate load (or unload) job. If you need each extract job to write to a different file, then you will need to keep them as separate jobs. If...
24922 Feb 2012 @ 03:19 PSTToolsReplybteq export and import for _ET dataparcel The topic of the thread was about processing data in a FastLoad error table. As much as I appreciate your desire to promote your conversion tool, it would not work for the problem described ...
24822 Feb 2012 @ 11:16 PSTToolsReplybteq export and import for _ET dataparcel I just read the notes on that tool. Are you telling me that for any Teradata FastLoad job that resulted in rows ending up in the error table, that your tool will be able to issue this comman...
24721 Feb 2012 @ 12:16 PSTToolsReplybteq export and import for _ET dataparcel No, there is currently no tool. Although, it is not really that difficult for you to do it on your own. But you either have to have a hex editor or write a simple C program to process the ex...
24620 Feb 2012 @ 10:48 PSTToolsReplybteq export and import for _ET dataparcel We are considering writing a tool to do this and so I have been taking a look at the contents of the DataParcel field. The DBS places the record, just as the client software sends it, into t...
24516 Feb 2012 @ 10:45 PSTToolsReplyTransformations in TPT Please look at the TPT Reference and/or User Guide at the syntax for the CASE statement support. I think you will be able to see how this is possible in the TPT script language.  
24416 Feb 2012 @ 10:32 PSTToolsReplyusage of check point in fastload The DBS will always eliminate the duplicate rows from SET and MULTISET tables for FastLoad jobs. In other words, on a FastLoad job, you can send duplicate rows to the Teradata database, but the ...
24314 Feb 2012 @ 04:57 PSTToolsReplyTPT script loading issue The Load operator uses the FastLoad protocol. With the FastLoad protocol, you cannot insert duplicates rows into a MULTISET table. They will be discarded by the DBS during the Application Ph...
24207 Feb 2012 @ 06:44 PSTToolsReplyWill the order of records in input file be maintained while loading using multiple load and read instances in Teradata PT 12? A few things: 1. TPT is a parallel application. By nature, parallel applications do not rely on data order. 2. You cannot use the Load operator to perform UPSERTs. The Load operator can ...
24107 Feb 2012 @ 10:47 PSTToolsReplyText Qualifiers in Teradata Utilities No dates are available right now.  
24007 Feb 2012 @ 09:34 PSTToolsReplyText Qualifiers in Teradata Utilities We added the capability to our load/unload tools in 14.0. We are trying to get the feature back-shipped into TPT 13.10, but that has not yet completed. We would like customers to use TPT...
23906 Feb 2012 @ 02:43 PSTToolsReplyHow to specify TAB as a delimiter for TDLOAD Try -d 'TAB'
23806 Feb 2012 @ 01:11 PSTToolsReplyTBUILD log file There is currently no method for you to name the output log file yourself. TPT must ensure the name is unique and so it uses the job name (or logon id if no job name is specified) plus it ap...
23703 Feb 2012 @ 09:29 PSTToolsReplyCan ANSI transaction mode be set in TPT script? TPT always runs in Teradata mode. It is hardcoded that way and the user cannot change that.  
23618 Jan 2012 @ 10:56 PSTToolsReplyTeradata Parallel Transporter Wizard 13.10 Issues A) "TPT only runs in 32-bit mode. We do not have a 64-bit version of TPT" B) "Checking with development, it looks like the Wizard is only supported with JRE 1.4 and 1.5."...
23517 Jan 2012 @ 09:53 PSTToolsReplyTPT_ISSUE What issue? I provided answers and asked questions and there has been no update.  

Pages