#DateForumTypeThreadPost
88425 Jun 2015 @ 01:42 PDTToolsReplyTeradata tptUse the long names. --ErrorTable1 --ErrorTable2   And just make sure to put the databasename and table name.  
88325 Jun 2015 @ 12:02 PDTToolsReplyTeradata tptFully qualify the error table names.  
88225 Jun 2015 @ 09:26 PDTToolsReplyTPT For Informatica 9.0.1A couple of things. 1. you can use the platform appropriate package command (e.g. pkginfo) to see if the TPT package was installed. 2. from a command prompt on the machine on which you installed ...
88117 Jun 2015 @ 06:37 PDTToolsReplyTPT Date format errorOk, thanks for the info. The only version number that is important here is the operator version. 15.00.00.00. This issue was fixed in 15.00.00.01. Please upgrade to the latest patch (efix). &nb...
88016 Jun 2015 @ 01:10 PDTToolsReplyTPT Date format errorThank you for the information. Yes, we recognized that we had a bug when the provided data was NULL. The original implementation did not account for the data being NULL. Are you sure about 15.00...
87915 Jun 2015 @ 03:07 PDTToolsReplyEXPORT_OPERATOR: TPT12108: Output Schema does not match data from SELECT statementAh, ok I was looking for "outer join" or "inner join" and did not see it and so was under the impression that your SELECT statement was not using a join.   Do you have an...
87815 Jun 2015 @ 01:14 PDTToolsReplyPassing date parameter (current month) to tbuild from command line1. Again, it is unclear to me what "input extraction data file" you are referring to. You will have to provide the script and job variable file and any other information you can.  
87715 Jun 2015 @ 01:11 PDTToolsReplyEXPORT_OPERATOR: TPT12108: Output Schema does not match data from SELECT statementWhere is the SELECT with the JOIN? I thought the scenario with a SELECT and a JOIN fails?
87615 Jun 2015 @ 09:14 PDTToolsReplyEXPORT_OPERATOR: TPT12108: Output Schema does not match data from SELECT statementPlease show me the script, and the DDL for the two tables.  
87512 Jun 2015 @ 08:30 PDTToolsReplyPassing date parameter (current month) to tbuild from command line1. please provide more information; not sure what you mean by "file which is being generated is of huge size". which file? 2. you need to split up the SELECT statement and use concatenat...
87402 Jun 2015 @ 01:44 PDTToolsReplyLoading carriage returns with TPT Load OperatorThe DataConnector is the only operator that processes data from flat files and it does not currently support newlines embedded in data.   (We are actually working on that feature now as part...
87301 Jun 2015 @ 09:25 PDTToolsReplyTPT Inserter OperatorThe Inserter does not support error limit. The Skip Rows feature is for the DataConnector operator, not the Inserter. So, that will be supported no matter which loading operator you use.  
87227 May 2015 @ 01:55 PDTToolsReplyTPT: system variables with result countSystem variable enhancement is not yet supported. Metadata table enhancement is implemented, but not yet officially released to the public. We are working on completing that in this current releas...
87120 May 2015 @ 12:15 PDTToolsReplyTPT19003 Number of characters in column 20 (65537) exceeds maximum allowed (65536)Always download and install the latest patches for all packages of TPT. They are located on the patch server, probably accessing through Teradata At Your Service.  
87019 May 2015 @ 01:32 PDTToolsReplyTPT19003 Number of characters in column 20 (65537) exceeds maximum allowed (65536)What is the exact version number of TPT you are running (I need the patch number)? (And while I research this, if you could upgrade to the latest and greatest patch for TPT 14.00, and retry your j...
86918 May 2015 @ 09:40 PDTToolsReplyMload Error - UTY3403 Only one statement per line is allowed.Can you provide the script?
86813 May 2015 @ 10:34 PDTToolsReplyTPT Permission errorTPT does not use environment variables, which is why I said that it is something in the environment.   You would have to check with the sysadmin to determine what is changing about the acces...
86713 May 2015 @ 09:27 PDTToolsReplyTPT Permission errorThank you for the information. Sorry to be picky here, but the script you sent me does not have information that matches the original post (with regard to file names). When you try 2 instances, w...
86613 May 2015 @ 07:57 PDTToolsReplyTPT Permission errorPlease provide the version of TPT you are running, the script, and the command line you used to run TPT.  
86512 May 2015 @ 12:12 PDTToolsReplyTPT Job was terminated even if the "Highest return code encountered = '0'"Looks like the job completed successfully. I am not sure what the issue is. Were the rows loaded correctly? Is the data valid and correct?  
86407 May 2015 @ 09:25 PDTToolsReplyLoading into Views using TPTTPT only exports data.
86328 Apr 2015 @ 07:38 PDTToolsReplyTPT Data Connector Error reading JSONAnother thing you must do is change your INSERT statement from:   'INSERT INTO D1_STG_WEB.FRESH_JSON ( :DATA_JSON );'   to:   'INSERT INTO D1_STG_WEB.FRESH_JSON VAL...
86227 Apr 2015 @ 05:44 PDTToolsReplyTPT Data Connector Error reading JSONIf you want to read in only character data, you can only user record format "Text" or "Delimtied".   You cannot use "unformatted" as that is used for binary dat...
86127 Apr 2015 @ 05:02 PDTToolsReplyIs Fast Import/Export available on OSX?No.
86023 Apr 2015 @ 11:10 PDTToolsReplyFastexport with MLOAD optionI am not sure this forum is the correct place to teach someone how to look at binary data to see if the data is correct. You have to know how to interpret the values for each byte. Obviously, if ...

Pages