498 | 03 Feb 2014 @ 10:29 PST | Private Forum |
497 | 03 Feb 2014 @ 10:24 PST | Private Forum |
496 | 03 Feb 2014 @ 10:19 PST | Database | Reply | Query Optimisation | Wrong 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... |
495 | 03 Feb 2014 @ 10:15 PST | Database | Reply | Secondary indexes | Using TPT is the best option in this scenario.
|
494 | 03 Feb 2014 @ 10:06 PST | Database | Reply | CLIv2 program and TimeStamp | Am sure you will take care .... but just beware of the out-of-memory exceptions. They can occur in this sort of implementation.
|
493 | 03 Feb 2014 @ 10:01 PST | Database | Reply | Question regarding Fastload | For 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
|
492 | 03 Feb 2014 @ 10:00 PST | Database | Reply | Question regarding Fastload | Teradata 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... |
491 | 03 Feb 2014 @ 09:56 PST | Database | Reply | Formatting CURRENT_TIMESTAMP | Its 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.
|
490 | 03 Feb 2014 @ 09:52 PST | Database | Reply | Statistics Creation on Tables and Stat Subsets to Enable Faster Join Queries | As 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... |
489 | 03 Feb 2014 @ 09:49 PST | Database | Reply | Statistics Creation on Tables and Stat Subsets to Enable Faster Join Queries | DIAGNOSTIC 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... |
488 | 03 Feb 2014 @ 09:45 PST | Database | Reply | Question regarding Fastload | Have a look at Jimm's reply on following link:
http://forums.teradata.com/forum/enterprise/how-to-load-data-without-single-quotes
|
487 | 03 Feb 2014 @ 09:27 PST | Database | Reply | Generating Surrogate Key Using ROWNUM | Also, how is the fact table populated? Like is it populated from single source? Or does it have multiple sources populating data into it?
|
486 | 03 Feb 2014 @ 09:25 PST | Database | Reply | Generating Surrogate Key Using ROWNUM | Try the solution given in the last post of following thread:
http://forums.teradata.com/forum/database/generate-surrogatekey-with-a-huge-table
|
485 | 03 Feb 2014 @ 05:44 PST | General | Reply | How to use dynamic column name in a query? | You can implement it using an SP. Which version of TD you are using?
|
484 | 03 Feb 2014 @ 05:41 PST | General | Reply | CAPTCHA | 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.
|
483 | 03 Feb 2014 @ 05:38 PST | General | Reply | Update Query Optimization | Try using UPSERT instead of UPDATE and COALESCE or DEFAULT (table level) instead of CASE.
|
482 | 03 Feb 2014 @ 12:21 PST | Private Forum |
481 | 02 Feb 2014 @ 11:39 PST | Database | Reply | Space in the database | Absolutely correct Dieter .... i was sleepy while mentioning B i guess :)
|
480 | 02 Feb 2014 @ 11:36 PST | Database | Reply | Discuss Teradata training and certification | Nothing matches with hands-on experience. Certification material is available .... visit following website for further details:
http://www.teradata.com/teradata-certified-professional-prog... |
479 | 02 Feb 2014 @ 11:34 PST | Database | Reply | GROUP BY Processing in TD 14 | For a similar description .... wait for Dieter's reply. :)
|
478 | 02 Feb 2014 @ 11:34 PST | Database | Reply | GROUP BY Processing in TD 14 | GROUP 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
|
477 | 02 Feb 2014 @ 11:27 PST | Database | Reply | Question regarding Fastload | As 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.
|
476 | 02 Feb 2014 @ 09:30 PST | Database | Reply | Optimizing Teradata SQL query | As Dieter suggested .... orignal query with explain is required to further comment on the issue.
|
475 | 02 Feb 2014 @ 09:28 PST | Database | Reply | Tactical Queries | As 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 .... ... |
474 | 02 Feb 2014 @ 09:25 PST | Database | Reply | CLIv2 program and TimeStamp | What exactly are you trying to code?
|