109 | 19 Jan 2011 @ 12:14 PST | Tools | Reply | Loading carriage returns with TPT Load Operator | We are working on this in the 14.0 release. Once that is complete, we will hopefully be able to backport that feature to earlier versions of TPT but that effort has not been committed yet.
|
108 | 12 Jan 2011 @ 12:57 PST | Tools | Reply | fload script not working. | It is not 100% clear to me about the contents of the FastLoad script.
You have KSH syntax and BTEQ commands, and those are not allowed in FastLoad scripts.
And the "#" is not a valid comment ch... |
107 | 12 Jan 2011 @ 12:52 PST | Tools | Reply | Tpump Vs Stream Load | Yes, the Stream operator is analogous to the TPump standalone utility tool.
We did not name our operators after the utilities because we felt people would get confused and expect certain feature... |
106 | 06 Jan 2011 @ 05:08 PST | Tools | Reply | Fastload with bad input file name | What version of FastLoad are you running?
FastLoad should have exited with an '8' or '12'. I will have this fixed.
|
105 | 06 Jan 2011 @ 05:04 PST | Tools | Reply | XML data format support by the TPT DataConnector Operator | Our access modules are currently constructed to support the existing record formats by our utilities. XML format is not one of their formats, thus this is not something that was "missed". The user ... |
104 | 16 Dec 2010 @ 02:24 PST | Tools | Reply | XML data format support by the TPT DataConnector Operator | Addition:
The rule using the axsmod is ‘the message has to be in a format compatible with our utility layout’.
The original problem statement seems to infer that data is somehow (by conve... |
103 | 16 Dec 2010 @ 01:55 PST | Tools | Reply | Teradata PT - ODBC and Load operator - Release lock on target tables | We modified the Load operator (and TPT infrastructure) to allow the Load operator to run without data coming from data streams, so that we could emulate what is done in FastLoad with just the speci... |
102 | 16 Dec 2010 @ 01:44 PST | Tools | Reply | XML data format support by the TPT DataConnector Operator | The TPT DataConnector operator does not support the processing of data that exceeds 64000 bytes per row, and currently does not support any type of XML "data type".
I will have to investigate th... |
101 | 16 Dec 2010 @ 01:35 PST | Tools | Reply | Dual Load with TPT?? | As you have learned, yes TPT will allow you to send the data from the Producer operator(s) to more than one Consumer operator (using the multiple-APPLY feature).
However, we do not, and will not... |
100 | 02 Dec 2010 @ 01:36 PST | Tools | Reply | Clarrification on Multiload errorlimit , checkpoint | Please explain a few things, so that your doubts can be satisfied.
1. I do not understand what you mean by, "it should check for changes starting from record 201 instead it consider the changes ... |
99 | 18 Nov 2010 @ 01:04 PST | Tools | Reply | TPT Stream Operator Bug? | The Stream operator uses the DML statements sent to it from the application (Informatica, in this case). If the DML statements being executed are not the ones you are expecting ("expecting" due to ... |
98 | 11 Nov 2010 @ 01:34 PST | Tools | Reply | TPT Load Operator error table being loaded? | BTW, another solution is to run a script with a BEGIN LOADING and END LOADING (no insert statement). This will cause the data loaded, up to the last checkpoint, to be committed to the table and the... |
97 | 10 Nov 2010 @ 11:02 PST | Tools | Reply | Tpump and Duplicates | My first answer was just for the question about what constitutes a duplicate row and whether the duplicate rows would have to come from the source.
According to the TPump manual (please look up ... |
96 | 10 Nov 2010 @ 06:34 PST | Tools | Reply | TPT Load Operator error table being loaded? | This is a DBS issue, not a TPT issue.
When a data load job is running, the target and error tables remain locked during the acquisition phase. Since your job terminated in the middle of the acqu... |
95 | 10 Nov 2010 @ 05:11 PST | Tools | Reply | Tpump and Duplicates | Assuming that your table is a MULTISET table . . . .
The ability to insert duplicate rows into a table does not refer to the need for the duplicates to all be coming from the source.
Loading ... |
94 | 03 Nov 2010 @ 05:13 PDT | Tools | Reply | How-to Skip duplicates | The Load operator (FastLoad protocol) cannot be used because the target table is already populated. The FastLoad protocol requires an empty table.
Why not use the Update operator? That uses the ... |
93 | 20 Oct 2010 @ 11:50 PDT | Tools | Reply | Session and Checkpoint consideration in TTUs and TPT | I am not quite sure an official explain of the execution plan would necessarily help you. I believe our documentation has information in it regarding the amount of resources being used based on the... |
92 | 14 Oct 2010 @ 04:06 PDT | Tools | Reply | Session and Checkpoint consideration in TTUs and TPT | There is no Rule Of Thumb, unfortunately. And that is just the nature of the beast when dealing with parallel processing. There are a lot of factors (network speed, CPU bandwidth, I/O bandwidth, et... |
91 | 30 Sep 2010 @ 04:06 PDT | Tools | Reply | tbuild, failures of EXPORT operator on linux | Please get in touch with Tony.Lee@Teradata.com.
He will work with you on this.
He will want you to send him the entire log (the .out file) generated for the job(s) that is(are) failing.
Thank... |
90 | 24 Sep 2010 @ 05:48 PDT | Tools | Reply | tbuild, failures of EXPORT operator on linux | The Export Operator log shows an old version of the TPT Operator Support Library 13.10.00.02.
Upgrade the TPT Infrastructure package (and any other old operators) to 13.10.00.03.
|
89 | 24 Sep 2010 @ 04:55 PDT | Tools | Reply | tbuild, failures of EXPORT operator on linux | Thank you for the detailed output.
We are looking into this.
|
88 | 23 Sep 2010 @ 01:27 PDT | Tools | Reply | Session and Checkpoint consideration in TTUs and TPT | Checkpointing:
The basic rule of thumb for checkpointing is this: how much time are you willing to lose in a batch job if the DBS should encounter a restart?
If you have a job that should run... |
87 | 20 Sep 2010 @ 04:52 PDT | Tools | Reply | Fastload -- doubt.. help required | The two Error Tables are populated with rows for different reasons and those error tables are controlled and populated by the Teradata DBS. Not by the client.
Error Table 1 contains rows that ha... |
86 | 02 Sep 2010 @ 10:50 PDT | Tools | Reply | Question: Is this a user only forum or is this also a way to feed back to Teradata Developers? | Agree with this last post. For the load/unload utilities (FL/ML/FE/TP and TPT), I have been unable to get the engineers to be active in the forum section.
So, unfortunately, I am it. :)
... |
85 | 02 Sep 2010 @ 10:42 PDT | Tools | Reply | Looking for Comparison of Teradata PT to Fastload and Multiload | We used to put the information in the manuals, listing the features found in the traditional load/unload utilities that are not found in TPT. I am not sure why that information was removed.
(I ... |