#DateForumTypeThreadPost
90914 Jul 2015 @ 09:50 PDTToolsReplyunloaded Date value issue by tpt scriptJust for the sake of trying, can you please pick a single byte delimiter that is part of the normal 7-bit ASCII code page? I would like to see if that enables the date data to be written correctly...
90813 Jul 2015 @ 08:30 PDTToolsReplyWhy TPT mload is taking long time than bteq for huge volume of dataPlease send me the script you are using currently to delete those 80 million rows.  
90713 Jul 2015 @ 04:00 PDTToolsReplyunloaded Date value issue by tpt scriptI am surprised your job ran at all. You used the DEFINE SCHEMA to pull the table definition from a table. This would have created a schema with various datatypes. However, the SQL Selector is de...
90613 Jul 2015 @ 01:27 PDTToolsReplyTeradata tptIn the future, please start a new thread with a subject that describes the problem. This makes it easier to track the issues, and for others to peruse and look at in case they have the same issues....
90513 Jul 2015 @ 09:10 PDTToolsReplyTPT buffer and shared memory usageWhat do you mean by "store data while using the Export operator"? All TPT operators work the same way.
90413 Jul 2015 @ 09:08 PDTToolsReplyWhy TPT mload is taking long time than bteq for huge volume of dataFor that many rows, maybe try the DELETE Task.
90310 Jul 2015 @ 09:37 PDTToolsReplyWhy TPT mload is taking long time than bteq for huge volume of dataAre you using the Delete Task to delete the records? Or the generic DELETE FROM . . . ?
90209 Jul 2015 @ 07:08 PDTToolsReplyTeradata tptLook at the MultiLoad script. (I do not know how FastExport generates it, so you may want to post it here if you want) The database defines column sizes in terms of "characters". Multi...
90109 Jul 2015 @ 01:18 PDTToolsReplyFile Writer operator writing out 0 for decimal columns with precision greater than 18.This is a known issue and we are currently working on the fix.  
90009 Jul 2015 @ 12:45 PDTToolsReplyTPT buffer and shared memory usageThe shared memory is used for all sorts of information, but most importantly, it is used by the data streams when sending data from one operator to another. Since TPT does not land data to disk, it...
89908 Jul 2015 @ 01:06 PDTToolsReplyTPT: reading variable blanks at end of record. Filler?You can either define a filler character in the TPT schema (TPT does not have a "filler" keyword, but if you include a column as the last column in the schema, but omit it from the DML st...
89808 Jul 2015 @ 01:03 PDTToolsReplyTPT buffer and shared memory usageTPT will allocate a certain amount of shared memory which will be enough for most jobs. In the event a job is configured in such a way that more shared memory is needed, TPT engineering would inst...
89706 Jul 2015 @ 04:27 PDTToolsReplyTeradata tptI cannot paste the whole script (I have a lot of other work I need to get to). I have already provided almost the entire script already. For now, you will need to put the entire INSERT or UPDATE ...
89606 Jul 2015 @ 04:18 PDTToolsReplyTeradata tpt<some commands> will just be any commands you need to use to create the target table. If you do not need them. then do not use the DDL operator. I already wrote you about the DML statements...
89506 Jul 2015 @ 04:07 PDTToolsReplyTeradata tptEverything in a TPT script is substitutable. Even the Insert statement. You can do this if you want us to generate the INSERT statement for you:    APPLY $INSERT TO OPERATOR ($LOAD) &...
89406 Jul 2015 @ 04:01 PDTToolsReplyTeradata tptWell, first of all you can eliminate the need for specifying the operator definitions in the script. Use templates instead. So, you can have a script that does this:    DEFINE JOB <...
89306 Jul 2015 @ 03:51 PDTToolsReplyTeradata tptWhat version of TPT are you using? You can use the same commands for defining the schema for the IMPORT as you use for the Export. The data would have the same layout. And when loading from a del...
89206 Jul 2015 @ 03:10 PDTToolsReplyTeradata tptEasy Loader (tdload) is meant to do simple jobs. Load delimited data from a file into a table. And Easy Loader will use a set of rules to determine the best load protocol (the best/fastest operato...
89102 Jul 2015 @ 03:37 PDTToolsReplyTPT For Informatica 9.0.1The title of this thread should not have TPT in the title, since it is a problem or question regarding BTEQ.  
89001 Jul 2015 @ 03:12 PDTToolsReplyTeradata tptI only see one operator that extracts data out of Teradata. The SQL Selector operator. Please check the documentation; you will want to add something like: INTEGER MaxDecimalDigits=38  
88901 Jul 2015 @ 01:53 PDTToolsReplyTeradata tptIn the operator definition for extracting data fro Teradata, make sure to set MaxDecimalDigits to 38 (or whatever your max precision size for your decimal columns). We default the precision to 18.
88801 Jul 2015 @ 11:54 PDTToolsReplyTPT: system variables with result count"This functionality" means that we will be populating Teradata tables with complete operational metadata. I cannot comment on this feature being usable by IBM Information Server, as I am...
88729 Jun 2015 @ 10:42 PDTToolsReplyTPT UTF8 Import of "no valid unicode character" - need helpIt appears as though  "U+10002A" is a character from 4-byte UTF8 encoding. If so, Teradata load/unload products do not support 4-byte UTF8 data.
88629 Jun 2015 @ 08:45 PDTToolsReplyTPT UTF8 Import of "no valid unicode character" - need helpThank you. And just checking that your script indicates "USING CHARACTER SET UTF8" prior to the DEFINE JOB?
88526 Jun 2015 @ 09:17 PDTToolsReplyTPT UTF8 Import of "no valid unicode character" - need helpPlease provide the entire output from the console.  

Pages