49803 Feb 2014 @ 10:29 PSTPrivate Forum
49703 Feb 2014 @ 10:24 PSTPrivate Forum
49603 Feb 2014 @ 10:19 PSTDatabaseReplyQuery OptimisationWrong forum .... what do you wish to achieve? Do you have TD accesible on your machine? If not start by downloading TD from following website:   http://downloads.teradata.com/download/databa...
49503 Feb 2014 @ 10:15 PSTDatabaseReplySecondary indexesUsing TPT is the best option in this scenario.
49403 Feb 2014 @ 10:06 PSTDatabaseReplyCLIv2 program and TimeStampAm sure you will take care .... but just beware of the out-of-memory exceptions. They can occur in this sort of implementation.
49303 Feb 2014 @ 10:01 PSTDatabaseReplyQuestion regarding FastloadFor more information, visit:   http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/Load_and_Unload_Utilities/B035_2436_071A/2436title.html
49203 Feb 2014 @ 10:00 PSTDatabaseReplyQuestion regarding FastloadTeradata recommends using TPT, older implementations still use them.   As for the drawbacks, there isn't much to say .... generally speaking .... idea of TPT was to be have single platfo...
49103 Feb 2014 @ 09:56 PSTDatabaseReplyFormatting CURRENT_TIMESTAMPIts only for display purpose. You can insert it like '2014-01-01 00:00:00' just fine .... and this is the default format that is suggested to be used with TD.
49003 Feb 2014 @ 09:52 PSTDatabaseReplyStatistics Creation on Tables and Stat Subsets to Enable Faster Join QueriesAs for the original question .... what are other details like:   - Data-size - Any other use of tables - Is it joined only on those columns or can be joined for other columns as well - Do...
48903 Feb 2014 @ 09:49 PSTDatabaseReplyStatistics Creation on Tables and Stat Subsets to Enable Faster Join QueriesDIAGNOSTIC HELPSTATS is just a guideline .... or a starting point for stats collection. It doesn't give you the complete need or end-to-end stats to be collected. Usually, it tends to solve th...
48803 Feb 2014 @ 09:45 PSTDatabaseReplyQuestion regarding FastloadHave a look at Jimm's reply on following link:   http://forums.teradata.com/forum/enterprise/how-to-load-data-without-single-quotes
48703 Feb 2014 @ 09:27 PSTDatabaseReplyGenerating Surrogate Key Using ROWNUMAlso, how is the fact table populated? Like is it populated from single source? Or does it have multiple sources populating data into it?
48603 Feb 2014 @ 09:25 PSTDatabaseReplyGenerating Surrogate Key Using ROWNUMTry the solution given in the last post of following thread: http://forums.teradata.com/forum/database/generate-surrogatekey-with-a-huge-table
48503 Feb 2014 @ 05:44 PSTGeneralReplyHow to use dynamic column name in a query?You can implement it using an SP. Which version of TD you are using?
48403 Feb 2014 @ 05:41 PSTGeneralReplyCAPTCHA One can deduce .... captcha is working brilliantly. :)   Unfortunately, it is the need of the time to avoid spam etc which can't be avoided by putting a limit on login-attempts may be.
48303 Feb 2014 @ 05:38 PSTGeneralReplyUpdate Query OptimizationTry using UPSERT instead of UPDATE and COALESCE or DEFAULT (table level) instead of CASE.
48203 Feb 2014 @ 12:21 PSTPrivate Forum
48102 Feb 2014 @ 11:39 PSTDatabaseReplySpace in the databaseAbsolutely correct Dieter .... i was sleepy while mentioning B i guess :)
48002 Feb 2014 @ 11:36 PSTDatabaseReplyDiscuss Teradata training and certificationNothing matches with hands-on experience. Certification material is available .... visit following website for further details:   http://www.teradata.com/teradata-certified-professional-prog...
47902 Feb 2014 @ 11:34 PSTDatabaseReplyGROUP BY Processing in TD 14For a similar description .... wait for Dieter's reply. :)
47802 Feb 2014 @ 11:34 PSTDatabaseReplyGROUP BY Processing in TD 14GROUP BY for TD14 is explained on following link:   http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1146_111A/ch01.032.178.html
47702 Feb 2014 @ 11:27 PSTDatabaseReplyQuestion regarding FastloadAs Dieter suggested, usually exporting utilities do that on their own. Hence if the data-file is generated manually .... EOL needs to be there as well.
47602 Feb 2014 @ 09:30 PSTDatabaseReplyOptimizing Teradata SQL queryAs Dieter suggested .... orignal query with explain is required to further comment on the issue.
47502 Feb 2014 @ 09:28 PSTDatabaseReplyTactical QueriesAs its tactical, so you need to be very precise about what information you need to keep about the workload. You shouldnt be tracking everything, rather it should only be what suits your needs .... ...
47402 Feb 2014 @ 09:25 PSTDatabaseReplyCLIv2 program and TimeStampWhat exactly are you trying to code?