#DateForumTypeThreadPost
29410 Dec 2013 @ 10:41 PSTDatabaseReplyWhy I do not see all the databases in Teradata Studiofgimmer, Thanks for sharing a great peace of info :)  
29310 Dec 2013 @ 10:40 PSTAnalyticsReplyFor AMP Number HASHMAP()+1Yes, the basic purpose of hashamp function is to analyse the row distriution base on PI values. The query used for this purpose is: SELECT HASHAMP(HASHBUCKET(HASHROW(PI_COLUMN))) AS AMP, COUNT(*...
29210 Dec 2013 @ 10:45 PSTAnalyticsReplyFor AMP Number HASHMAP()+1Is there any HASHMAP function exist? I know only about HASHAMP function. I believe its typo :), well I think it is due to the fact that the amp numbers start from 0 so if there are 100 amps, then ...
29110 Dec 2013 @ 10:37 PSTDatabaseReplydiff between USI and NUSIHi Ratnam, I know I am not Dieter but let me try to answer your question: In a NUSI access the message from PE is brodcasted to all the amps, the reason is to scan all the NUSI subtables, once th...
29010 Dec 2013 @ 10:32 PSTDatabaseReplyCan some one provide the solution for the below scenario?You can find YTD and MTD caiolculation examples here: http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1145_111A/App-Performance_SQL_Functions.100.06.html &nb...
28910 Dec 2013 @ 10:13 PSTDatabaseReplyTeradata Hi, You can find YTD and MTD caiolculation examples here: http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1145_111A/App-Performance_SQL_Functions.100.06.html...
28810 Dec 2013 @ 10:11 PSTAnalyticsReplyWhile we add New AMPhi, well, this is a complex process that obviously can not be explained in few lines here, you will have to read the documentation and manuals to understand it fully.  in simple words adding...
28710 Dec 2013 @ 09:44 PSTToolsReplyTTU for LinuxHi jdliau, I believe Ubunto is a variant of Linux, so the utlities for Linux must be working for Ubunto. You can give it a try, I hope they will be working.  
28610 Dec 2013 @ 09:34 PSTDatabaseReplyDifference between NULL and Emptyhi, You know well about the null, it is absolutely absense of a value, and if you find the meaning of empty the google defines it as "containing nothing; not filled or occupied" So you c...
28510 Dec 2013 @ 05:06 PSTDatabaseReplyUTF -8 or UTF-16?Hi Nishant, You can find a reasonable information about these two in the link below and then will be able to make a better decision; http://www.differencebetween.net/technology/difference-between...
28409 Dec 2013 @ 11:23 PSTToolsReplyTTU for LinuxHere you go: http://developer.teradata.com/tools/reference/ttu-install-documentation  
28309 Dec 2013 @ 10:50 PSTToolsReplyNumeric overflow Hi Parkash,   The data type DECIMAL(8,2) means that the value can include total 8 digits, including the decimal digits.   for example, in this case you can only have 6 ...
28209 Dec 2013 @ 10:39 PSTDatabaseReplyForeign KeysWell, Teradata create error tables named with TableName_Incremental digit. But this is created as a result of invalid foreign key references.  have you checked the table creation right after ...
28106 Dec 2013 @ 11:21 PSTDatabaseReplyDefault date column not aligning in xcelBy the way, what is the need to use this case statement? as You have all the dates in CAD2.LAST_PMT_DATE and want to apply the same format. You can simply apply the format to whole column...
28006 Dec 2013 @ 10:23 PSTDatabaseReplyDefault date column not aligning in xcelHi Uco, What I have understand is that you have a date format in source YYYY-MM-DD and you want this to export as 'DD/MM/YYYY'  Please confirm, and also confirm that the sample ...
27906 Dec 2013 @ 10:15 PSTDatabaseReplyScript to compare two databases (Tables and Views definitions)Thank you Kawish, I will try to use this, but if you paste some sample query, It would be a great help :)  
27806 Dec 2013 @ 10:10 PSTGeneralReplyHELP with INSERT INTO statementHi jonny, The first thing is you have not provided with the table definition in which you are inserting the rows. The second thing is this error means that the select statements you are using in ...
27706 Dec 2013 @ 09:52 PSTDatabaseReplyScript to compare two databases (Tables and Views definitions)Thank you Raja, I will try the script.  
27606 Dec 2013 @ 09:49 PSTDatabaseReplyneed a associated select query defined from view table in teradata?Yes, Kawish is right, I have read somewhere that ODBC also has a limit for string to show. I was just thinking of one possiblity, can we cast the result of SHOW Command?I think if its possible the...
27506 Dec 2013 @ 09:21 PSTDatabaseReplyTeradata sql grouping welcome uco, Just for my interest, which tool you are using to make these reports?  
27406 Dec 2013 @ 06:27 PSTAnalyticsReply-----Aggregate Designer----Hi gryback, Can you please let me know from where I can download Teradata Aggregate designer?  
27306 Dec 2013 @ 05:25 PSTDatabaseTopicScript to compare two databases (Tables and Views definitions)All, I have to compare two databases (Tables and Views defintions), Both the databases have the same number of tables and views, but I have to investigate the difference in there definitions, for ...
27206 Dec 2013 @ 04:55 PSTToolsReplygenerating sequention number during mloadhi, Can you please exaplian a little what do you want to achieve? I have done such work in one of my projects using TPT.  Give me some more explaination and I hope we can find a way.  
27106 Dec 2013 @ 12:09 PSTDatabaseReplyTeradata sql grouping Hi, You can use the following query to get all the aggregations. But to get report in this particular format you might have to use some reporting tool.  CT Test ( Date_key DATE ,Locati...
27005 Dec 2013 @ 11:31 PSTDatabaseReplyWhy I do not see all the databases in Teradata StudioI meant to login using DBC user. loging in using DBC will confirm either it is an issue with the connection or it is an access rights issue hiding other schemas.  

Pages