#DateForumTypeThreadPost
10919 Jan 2011 @ 12:14 PSTToolsReplyLoading carriage returns with TPT Load OperatorWe 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.
10812 Jan 2011 @ 12:57 PSTToolsReplyfload 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...
10712 Jan 2011 @ 12:52 PSTToolsReplyTpump Vs Stream LoadYes, 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...
10606 Jan 2011 @ 05:08 PSTToolsReplyFastload 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.
10506 Jan 2011 @ 05:04 PSTToolsReplyXML data format support by the TPT DataConnector OperatorOur 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 ...
10416 Dec 2010 @ 02:24 PSTToolsReplyXML data format support by the TPT DataConnector OperatorAddition: 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...
10316 Dec 2010 @ 01:55 PSTToolsReplyTeradata PT - ODBC and Load operator - Release lock on target tablesWe 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...
10216 Dec 2010 @ 01:44 PSTToolsReplyXML data format support by the TPT DataConnector OperatorThe 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...
10116 Dec 2010 @ 01:35 PSTToolsReplyDual 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...
10002 Dec 2010 @ 01:36 PSTToolsReplyClarrification 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 ...
9918 Nov 2010 @ 01:04 PSTToolsReplyTPT 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 ...
9811 Nov 2010 @ 01:34 PSTToolsReplyTPT 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...
9710 Nov 2010 @ 11:02 PSTToolsReplyTpump and DuplicatesMy 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 ...
9610 Nov 2010 @ 06:34 PSTToolsReplyTPT 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...
9510 Nov 2010 @ 05:11 PSTToolsReplyTpump and DuplicatesAssuming 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 ...
9403 Nov 2010 @ 05:13 PDTToolsReplyHow-to Skip duplicatesThe 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 ...
9320 Oct 2010 @ 11:50 PDTToolsReplySession and Checkpoint consideration in TTUs and TPTI 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...
9214 Oct 2010 @ 04:06 PDTToolsReplySession and Checkpoint consideration in TTUs and TPTThere 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...
9130 Sep 2010 @ 04:06 PDTToolsReplytbuild, failures of EXPORT operator on linuxPlease 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...
9024 Sep 2010 @ 05:48 PDTToolsReplytbuild, failures of EXPORT operator on linuxThe 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.
8924 Sep 2010 @ 04:55 PDTToolsReplytbuild, failures of EXPORT operator on linuxThank you for the detailed output. We are looking into this.
8823 Sep 2010 @ 01:27 PDTToolsReplySession and Checkpoint consideration in TTUs and TPTCheckpointing: 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...
8720 Sep 2010 @ 04:52 PDTToolsReplyFastload -- 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...
8602 Sep 2010 @ 10:50 PDTToolsReplyQuestion: 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. :) ...
8502 Sep 2010 @ 10:42 PDTToolsReplyLooking for Comparison of Teradata PT to Fastload and MultiloadWe 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 ...

Pages