#DateForumTypeThreadPost
63403 Apr 2014 @ 10:58 PDTToolsReplyDifferent Modes and FormatAll of our documentation can be found here: http://www.info.teradata.com/  
63302 Apr 2014 @ 05:54 PDTToolsReplyTPT : Infrastructure Setup ErrorsAs always, it would be very helpful to know a little more information. What version of TPT are you running? On what platform are you running? How did you install TPT? Provide us with your "...
63202 Apr 2014 @ 05:41 PDTToolsReplyTPT - Assigning default values for columns not present in a file via TPT to load a tableYes, it is possible. However, it depends on what you want to assign to these new columns. I will give you the basic method and you can adjust as you need. Let's assume for a minute that your ...
63102 Apr 2014 @ 05:28 PDTToolsReplyDifferent Modes and Format(all of this is located in our documentation)   MODE RECORD means the data will not have indicator bytes. MODE INDICATOR means the data will be preceded by indicator bytes.   For the...
63002 Apr 2014 @ 02:56 PDTToolsReplyFast Export and Fast Load ErrorWhen dealing with text data, you need to have FastLoad written to read the data in the exact same format as you have FastExport exporting the data.   In the FastExport script, you define the...
62931 Mar 2014 @ 10:44 PDTToolsReplyFastload Utility Locks due to abort- .FILLER command- possible solution?Yes, there are 2 choices. But for #2, you do not need to try to load an empty file. You can do the equivalent of FastLoad's: .logon begin loading ....; end loading ....; .quit By...
62828 Mar 2014 @ 01:17 PDTToolsReplyTPT load to table which contains special characters in name and column namesYes, you can have special characters in database object names, as long as you enclose them in double-quotes, which you have. You will have to obtain the syntax information from the Teradata SQL ma...
62728 Mar 2014 @ 10:29 PDTToolsReplyTPT Error using DATACONNECTOR PRODUCER OperatorWell, I cannot show you an example because the data is in binary. Our supported record formats are well documented. Please refer to the TPT documentation. The record format called "FORMATTE...
62627 Mar 2014 @ 02:09 PDTToolsReplyEnd of Record marker with TPTOk, a couple of things. First, please upgrade to the latest patch (14.00.00.11). Next, if the problem still persists, I need you to enable tracing for the Data Connector operator by placing: &nb...
62527 Mar 2014 @ 12:25 PDTToolsReplyTPT load to table which contains special characters in name and column namesI need to see more of the script. The error message might be referring to some other part of the script.  
62427 Mar 2014 @ 10:50 PDTToolsReplyEnd of Record marker with TPTPlease provide version of TPT and entire screenshot of console output.
62327 Mar 2014 @ 10:47 PDTToolsReplyTPT Error using DATACONNECTOR PRODUCER OperatorThat is a different issue than the first one you reported. This one is a known issue and is being fixed. It happens because you do not have a newline (end-of-record marker) after the last record ...
62226 Mar 2014 @ 07:31 PDTToolsReplyEnd of Record marker with TPTYou have the correct info. With: Column1_value, Column2_value,,Column4_value column 3 will be NULL. No space can be between the delimiters (otherwise the space character will be interpreted as th...
62126 Mar 2014 @ 03:50 PDTToolsReplyTPT Error using DATACONNECTOR PRODUCER Operator"Formatted" is a binary format that consists of a 2-byte record length ('n'), followed by 'n' bytes of data, followed by an end-of-record marker. Your data format does no...
62024 Mar 2014 @ 08:55 PDTToolsReply Issue while loading space delimited flat file using fastload on TPTPlease provide a sample of the data after making the modifications to it so that only a single space separates each field.  
61920 Mar 2014 @ 11:49 PDTToolsReply Issue while loading space delimited flat file using fastload on TPTThe TextDelimiter you have defined will look for a delimiter made up of the characters (the word) "space". You need to actually tell us the characters, and they must all be the same for e...
61819 Mar 2014 @ 01:54 PDTToolsReplyWhere can I download the Teradata Parallel Transport API for all platforms?It is part of the TPT installation. There is no separate installation for TPTAPI.
61719 Mar 2014 @ 01:31 PDTToolsReplyEnd of Record marker with TPTPlease explain this answer:   "When the value (no. of character) is more/less than the buffer size, it will error out. It need to be exactly same number of character defined in the sche...
61619 Mar 2014 @ 01:28 PDTToolsReplyData mismatch while migrating data from SAS to Teradata using TPTAgain, I cannot help until I have more detailed information about the TPT operator. I need verification that the job is using a tool such as DataStage to run the TPT operators (via TPTAPI). I the...
61518 Mar 2014 @ 06:41 PDTToolsReplyData mismatch while migrating data from SAS to Teradata using TPTThe original post said:   "I have been trying to load a 200GB dataset from SAS onto Teradata using TPT multiload option."   Thus, they may be using the Update operator. One...
61418 Mar 2014 @ 10:19 PDTToolsReplyData mismatch while migrating data from SAS to Teradata using TPTThis looks like SAS is using DataStage to load the data, which also means the job is using TPTAPI, and not script-based TPT (correct me if I am wrong).   The information you sent me was the ...
61317 Mar 2014 @ 11:41 PDTToolsReplyData mismatch while migrating data from SAS to Teradata using TPTThere could be several reasons. But before I try to answer the questions, the best thing to do is to provide me with the entire output from the TPT job. It will tell us how many rows were actually ...
61212 Mar 2014 @ 07:37 PDTToolsReplyTPT 14.10 error with fifo input fileswhat does the "-1" mean in your version numbers (e.g. 14.10.00.04-1)?
61111 Mar 2014 @ 11:59 PDTToolsReplyFASTLOAD SCRIPT ISSUEAs indicated above, the match has to be exact (in content and length). With VARCHARs that is difficult because each row may have a different length for that field. Thus, the NULLIF feature does n...
61010 Mar 2014 @ 10:50 PDTToolsReplyFASTLOAD SCRIPT ISSUEFastLoad does an exact match, byte-for-byte. It is not pattern matching. So, if you field will have 7 '*'s, then your NULLIF clause must have 7 '*'s. If each row will have a diff...

Pages