259 | 03 Apr 2012 @ 10:42 PDT | Tools | Reply | skip the header row in the flat file, when importing using FastLoad script |
Yes
|
258 | 30 Mar 2012 @ 11:32 PDT | Tools | Reply | bteq 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... |
257 | 28 Mar 2012 @ 01:45 PDT | Tools | Reply | bteq 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... |
256 | 26 Mar 2012 @ 11:38 PDT | Tools | Reply | RDBMS 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?
|
255 | 26 Mar 2012 @ 10:30 PDT | Tools | Reply | Teradata 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.
... |
254 | 26 Mar 2012 @ 10:26 PDT | Tools | Reply | TPT 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.
|
253 | 21 Mar 2012 @ 05:42 PDT | Tools | Reply | Export 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.
|
252 | 21 Mar 2012 @ 05:33 PDT | Tools | Reply | Export 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.
|
251 | 02 Mar 2012 @ 04:47 PST | Tools | Reply | Hadoop 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... |
250 | 29 Feb 2012 @ 07:33 PST | Tools | Reply | Teradata 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... |
249 | 22 Feb 2012 @ 03:19 PST | Tools | Reply | bteq 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 ... |
248 | 22 Feb 2012 @ 11:16 PST | Tools | Reply | bteq 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... |
247 | 21 Feb 2012 @ 12:16 PST | Tools | Reply | bteq 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... |
246 | 20 Feb 2012 @ 10:48 PST | Tools | Reply | bteq 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... |
245 | 16 Feb 2012 @ 10:45 PST | Tools | Reply | Transformations 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.
|
244 | 16 Feb 2012 @ 10:32 PST | Tools | Reply | usage 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 ... |
243 | 14 Feb 2012 @ 04:57 PST | Tools | Reply | TPT 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... |
242 | 07 Feb 2012 @ 06:44 PST | Tools | Reply | Will 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 ... |
241 | 07 Feb 2012 @ 10:47 PST | Tools | Reply | Text Qualifiers in Teradata Utilities |
No dates are available right now.
|
240 | 07 Feb 2012 @ 09:34 PST | Tools | Reply | Text 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... |
239 | 06 Feb 2012 @ 02:43 PST | Tools | Reply | How to specify TAB as a delimiter for TDLOAD |
Try -d 'TAB'
|
238 | 06 Feb 2012 @ 01:11 PST | Tools | Reply | TBUILD 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... |
237 | 03 Feb 2012 @ 09:29 PST | Tools | Reply | Can 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.
|
236 | 18 Jan 2012 @ 10:56 PST | Tools | Reply | Teradata 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."... |
235 | 17 Jan 2012 @ 09:53 PST | Tools | Reply | TPT_ISSUE |
What issue?
I provided answers and asked questions and there has been no update.
|