#DateForumTypeThreadPost
4928 Nov 2014 @ 02:00 PSTToolsReplyTPT Vs other ETL Utilitiesvincent91, Please check "-h" option in the TPT.
4803 Mar 2014 @ 04:45 PSTToolsReplyTeradata Parallel Transporter - Session Character Set@arun_tim1: Does not look like TPT caused the abend, because you can see the return code from the step LOAD_TABLES. Please paste the DC operator log of the execution. If possible, please execute th...
4703 Mar 2014 @ 01:28 PSTToolsReplyTeradata Parallel Transporter - Session Character Set@arun_tim1, The information provided is not enough to dig deep into the issue you are facing. Please provide the logs of the operators to see where the problem might lie.   And, I think you ...
4603 Mar 2014 @ 01:26 PSTToolsReplyTeradata Parallel Transporter - Session Character Set@Santanu84, Try using the attributes ValidUTF8 and ReplaceUTF8Char. Refer to the documentation to see if it helps. 
4506 Feb 2014 @ 05:59 PSTToolsReplyTeradata Parallel Transporter ~ OPERATOR FILE_WRITER ~ escape characters in output Mention "QuotedData" attribute as "Yes" in your FILE_WRITER attribute list. Mention the value for OpenQuote Mark and CloseQuoteMark attribute as double quote character ( "...
4429 Jan 2014 @ 06:08 PSTToolsReply TPT12106: Cannot restart !!! Please resubmit the job.The information provided is not enough to suggest. Please provide the following information:   * TPT Script * Oracle ODBC driver used and its version.  * Sample data (if possible).
4324 Jan 2014 @ 12:07 PSTToolsReplyTPT casting w/ format issuesCreate the target table with Timestamp as data type, instead of VARCHARs. In the TPT schema definition, define all varchars which match the data in the flat file. You ca Something like this: ...
4217 Jan 2014 @ 06:08 PSTToolsReplyDelimiter Issue With TPT on Linux PlatformDebra,  How many records were there in the source table approximately.   
4117 Jan 2014 @ 03:13 PSTToolsReplyTPT15105: Error 13 in finalizing the table schema definitionFor all character types, while using UTF-8 character set, you have to triple the size. You have tripled it for the first four columns, and have doubled for the last column. 
4014 Jan 2014 @ 11:22 PSTToolsReplyTPT error - TPTThe ".twbcfg.ini" file in the home directory of the user provides a way for the user to change the checkpoint and logs directory, and they should work just fine if the user has proper per...
3914 Jan 2014 @ 11:06 PSTToolsReplyTPT Error - Not able to get rows having incorrect format The attribute you should use is RowErrFileName. If you mention this attribute, that the error record will be directed to the file name you mentioned value for the attribute RowErrFileName.
3812 Jan 2014 @ 11:04 PSTToolsReplyTPT - new line in data - export to file has issuesPlease post the TPT version you are using, sample data you are trying to load (if possible), and the script you are using. It would be easy for the forum members to zero it in quickly. 
3717 Jul 2012 @ 11:02 PDTToolsReplyHow to bypass the valid comma separator during the fastload Are the explanations provided in the above thread not clear enough ?
3617 Jul 2012 @ 10:59 PDTToolsReplyTeradata Utilities to load data from table to table I am not sure what exactly you want to do. Please provide more details. My assumption: If you are having source table with column data types which are different than the target table, and yo...
3528 Jun 2012 @ 10:55 PDTToolsReplyHow to bypass the valid comma separator during the fastload The latest version of fastload (well, from TTU 14.0) supports quoted vartext records. You can specify the data as "10021","Brown, Jo".
3426 Jun 2012 @ 09:32 PDTToolsReplyBeginner TPT Which version of products did you install ? libtelapi.so should be present in /opt/teradata/client/13.10/tbuild/lib directory, not in tdicu directory, unless this is the path explicitly specifie...
3326 Jun 2012 @ 09:18 PDTGeneralReplyInformatica TPT issue Hmmm.. We should wait for somebody else who knows about informatica+TPT to comment..
3224 Jun 2012 @ 08:39 PDTGeneralReplyInformatica TPT issue I am not sure how to use informatica with TPT - I believe they use TPT ODBC operator to extract the rows from Oracle (or) other databases. There will be log which is generated by TPT ODBC operat...
3122 Jun 2012 @ 01:21 PDTToolsReplyBeginner TPT View the contents of the file $TWB_ROOT/twbcfg.ini. There are two entries in there. One is the checkpoint directory and another is the log directory. User should have permission to write in the ...
3013 Dec 2010 @ 01:22 PSTToolsReplyTeradata PT - ODBC and Load operator - Release lock on target tablesIf you want to release the lock in a different way other than what is mentioned above, you have to define LOAD operator as standalone, specify the exact names of target, error and log tables as you...
2913 Dec 2010 @ 01:19 PSTToolsReplyTeradata PT - ODBC and Load operator - Release lock on target tablesYou have to drop the error tables, log table, target table, and recreate them. Thats the easy way.
2804 Oct 2010 @ 12:34 PDTToolsReplySession and Checkpoint consideration in TTUs and TPTNo need to apologize.. The legacy Fastexport writes to a file. With TPT, are you using dataconnector operator as consumer ? I still am not able to believe that export operator is taking more ti...
2730 Sep 2010 @ 01:16 PDTToolsReplySession and Checkpoint consideration in TTUs and TPTI did not understand this statement: it was executing faster than (MaxSession 4 to10) session takes more execution time Did you find a better performance, time wise ? The CPU Utilization w...
2627 Sep 2010 @ 10:06 PDTToolsReplySession and Checkpoint consideration in TTUs and TPTYes, you can use more than 15 files using TPT. You have to use the wildcard in the FileName attribute of DC operator. Like "VARCHAR FileName = '*.dat' ", and the DirectoryPath attribute will point...
2523 Sep 2010 @ 06:26 PDTToolsReplySession and Checkpoint consideration in TTUs and TPTDNoeth and Feinholz... Please respond..

Pages