#DateForumTypeThreadPost
3530 Mar 2016 @ 01:57 PDTDatabaseReplyUDF Default DatabaseIs it recommended to use this database?  Ideally I'd be able to create a new database, USER_SYSFNLIB, and get Teradata to search that database for functions as well as the system databases.
3429 Mar 2016 @ 06:37 PDTDatabaseReplyPK used as USI and not UPIIn my opinion, for large transaction tables the primary key is rarely the best option for a primary index.  The primary index should be defined based on three things: distribution, access and ...
3329 Mar 2016 @ 06:05 PDTDatabaseTopicUDF Default DatabaseIs there a database where we can create user defined functions so that it is not necessary to qualify them with the databasename when we use them.  The UDFs that have been created by the Terad...
3213 Oct 2015 @ 06:41 PDTDatabaseTopicMonitoring Intelligent MemoryCan anyone tell me how I can tell what columns to look at in DBQL and resusage to see how much of a benefit we are getting from intelligent memory, and which queries have been improved by using it?
3121 Nov 2014 @ 07:40 PSTDatabaseReplyConnecting Multiple Teradata ServersI've been doing something similar myself recently.  I tried using TPT to copy tables in a generic manner.  However this didn't work with geospatial data, would be difficult with X...
3001 Oct 2014 @ 06:58 PDTDatabaseReplyHow to find base tables/views for views You can use a similar query as above to generate: show select * from viewname; statements and run those.  This will give the DDL for each object used in the query.   Another opti...
2922 Sep 2014 @ 05:11 PDTToolsReplyFacing TPT error while lading data from flat file to Teradata I think the error may be the trailing comma in line: VARCHAR OpenMode        = 'read',  
2816 Sep 2014 @ 06:28 PDTGeneralReplyGeneral QuestionThe correct, most up to date answer is: E - TPT load operator into a No Primary Index table The TPT load operator has basically the same functionality as fastload.  Generally they will remov...
2703 Sep 2014 @ 01:27 PDTToolsReplyTPT Extract - Newline character in data causes number of records mismatch I don't know if this is of any help, but I have done something similar on unix using awk to format data copied from excel and pasted into a text file.  If you wrote the file to unix and...
2601 Sep 2014 @ 02:54 PDTToolsTopicTPT User TemplatesI want to create and test some user templates, which I'm going to base on the Teradata provided templates $LOAD and $EXPORT. Do the templates I create have to be saved to the same directory as...
2527 Aug 2014 @ 03:34 PDTDatabaseReplyDefining two derived tables using WITH clause ??On a related subject, is it possible to insert this data into a table? I wrote a pretty complex query recently using the 'with' syntax, but when I tried to use it as an insert/select query...
2407 Jul 2014 @ 11:57 PDTToolsTopicTPT Script to load multiple data types from a delimited fileI have a file to load which doesn't seem to be in too unusual a format, but I'm not sure if it is possible to load it using TPT.  Can anyone let me know whether this is possible, or if...
2316 Jun 2014 @ 11:26 PDTData ModelingTopicDatabase Design ToolIs anyone using, or have any suggestions for, a free/cheap data modelling or database design tool?  We are about to start planning and building a new data warehouse.  It is fairly small, ...
2212 Jun 2014 @ 07:57 PDTData ModelingTopicAccessing Information from Visio ERD I'm just looking at using Visio 2010 to create a database design.  The tools seems a great way of entering information and drawing the ERD.  However there doesn't seem to be any w...
2110 Jun 2014 @ 11:19 PDTToolsReplyis Teradata Query Scheduler included in TTU Release 15?I get those errors too: Query Scheduler Startup Error --------------------------- 08:25:50|COMM |001596|QmCreateShm       |CreateFileMap     |...
2008 Jun 2014 @ 11:36 PDTGeneralReplyDisadvantages of denormalization in teradataDenormalisation in Teradata tables is an engineering decision, i.e. there isn't necessarily a right answer - it depends on what works.  It's best not to denormalise columns that can ch...
1906 Jun 2014 @ 12:45 PDTToolsReplyTPT - Format = text exampleI'm using version 15.0 (I've only recently downloaded it) I'm not sure if I can put quotes round it.  There could be quotes within the file, and they may be unmatched ones - it...
1802 Jun 2014 @ 01:19 PDTToolsReplyTPT - Format = text exampleI don't want to choose a delimiter!  However if I choose an empty delimiter by using: SourceTextDelimiter  = '' Then TPT uses the default delimiter of '|' which does...
1729 May 2014 @ 06:11 PDTDatabaseReplyBest practise table creation with primary key or/and index?I would take issue with the statement:'The more even the data distiribution is, the better the perfomnce will be' There are 3 things you should take into account when defining the primary ...
1628 May 2014 @ 11:23 PDTToolsReplyTPT - Format = text exampleI did end up using delimited with a delimiter string of 'jkajdnsksklfnsklslkdmjsks'.  I'm hoping that never occurs in the file! It doesn't seem like the right way to do it tho...
1528 May 2014 @ 01:04 PDTToolsTopicTPT - Format = text exampleDoes anyone have an example of a TPT script with format = text? I'm trying to load a file with variable length records into a table with a single varchar(1000) column.  I tried basing the...
1427 May 2014 @ 12:43 PDTToolsReplyTPT - Can you load from a file containing multiple record types?In this file each record type will have it's own schema.  In the above example record type 01 has 2 fields: F1 - record_type  - byteint F2 - created date - date Record type 10: ...
1323 May 2014 @ 03:21 PDTToolsTopicTPT - Can you load from a file containing multiple record types?If we have a file which contains multiple record types, each with a different number of fields and record length but identified by the value in the first field, is it possible to load this using TP...
1222 May 2014 @ 03:27 PDTGeneralReplyErrors When Loading XML DataIt looks like it is failing on the first and second steps.  Are the files XML_FILES_LIST.txt and XML_STYLESHEETS_LIST.txt in the directory you are running the code in?  The errors are say...
1119 Mar 2014 @ 02:27 PDTGeneralReply list all TASM delayed queries for a user over a specific time periodLook at delaytime in dbqlogtbl.  If it has a value > 0 then the query was delayed, and it also shows how long it was delayed for. There are also other columns that may be useful - tdwmrule...

Pages