#DateForumTypeThreadPost
84628 Aug 2014 @ 12:58 PDTGeneralReplyBackup sessions Can it be that the number of sessions, when procesing  is less than the number of amps? Maybe increasing the number of sessions can help.
84528 Aug 2014 @ 12:49 PDTToolsReplyTeradata Bteq Optimization - A single-statement request(SSR) is a single Teradata SQL statement sent as a request. - A multi-statement request(MSR) is two or more statements that are sent as a request. Semicolon placemen...
84427 Aug 2014 @ 09:43 PDTDatabaseReplyTERADATA Regular Expression FunctionYou can have a look at this link(left nav): http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1145_111A/Regular_Expr_Functions.085.01.html  
84327 Aug 2014 @ 09:37 PDTDatabaseReplyIdentifying GTT or volatile tables created during a sessionFor VT you can use help volatile table Also you can read the lines: To obtain a list of all global temporary tables in the system, query the CommitOpt column of the DBC.TablesV view. For exam...
84227 Aug 2014 @ 04:13 PDTToolsReplyTeradata Bteq Optimization I am not sure exactly about the optimization scope. In short, some of the best practices at the top of my mind - capturing the statuses of queries - Error Code, Error level assignments, ac...
84127 Aug 2014 @ 02:15 PDTTrainingReplyTerdata Certification in India How much you can read? You have loads of materials in http://www.info.teradata.com/ Click on "Teradata tools and Utilities...". I suggest you to practice to too to to get the feel an...
84023 Aug 2014 @ 03:08 PDTDatabaseReplyHow to fetch only month end dates from SYS_CALENDAR from Current dateWill this be helpful for you? select add_months(current_date -extract(day from current_date) +1,1) -1, add_months(current_date -extract(day from current_date) +1,-1) -1, add_months(current_date ...
83921 Aug 2014 @ 10:06 PDTAnalyticsReplyMerge a variable number of rows with one column, into a single rowWhich TD version? Have you seen this function, if it helps you, select tdstats.udfconcat(trim(columns1)) from your_table;
83821 Aug 2014 @ 09:53 PDTDatabaseReplyDense_rank() functionIt is there in 14.10. You can have a look at the example given there, else you have to develop a logic for it. In TD 15 , there are lots of new functions. I think it is time to upgrade to avail new...
83721 Aug 2014 @ 07:15 PDTDatabaseReplyDense_rank() functionversions??? http://www.info.teradata.com/HTMLPubs/DB_TTU_14_10/index.html#page/SQL_Reference/B035_1145_112A/Ordered_Analytical_Functions.093.057.html
83620 Aug 2014 @ 08:02 PDTGeneralReplyIntroduce sequence number on Full row duplicates dataThere were some exchanges of views on these two links . They may be what you are looking for. https://forums.teradata.com/forum/database/generate-surrogatekey-with-a-huge-table http://forums.tera...
83520 Aug 2014 @ 07:47 PDTDatabaseReplyREGEX syntax?You can refer to these links. You can see on the left nav, below too for others.  http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1145_111A/Regular_Expr_...
83419 Aug 2014 @ 10:47 PDTDatabaseReplyWant to know about save table You need to take  precautions with insert into by knowing your data. Know your data well, how it is placed.The link below explains: http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.ht...
83319 Aug 2014 @ 10:35 PDTDatabaseReplyTo find number of null values in each columns of a tableYou can try with sel 'col1', sum(case when col1 is null then 1 else 0 end)  from tablename; or you can omit the else part too.
83218 Aug 2014 @ 09:40 PDTDatabaseReplyTDExpress 15.0 unable to install on Fedora .. TimesoutHave you seen this link? Our guru's recommendation. http://forums.teradata.com/forum/teradata-applications/how-to-install-teradata-on-ubuntu Though I work with different flavours of unix/linu...
83117 Aug 2014 @ 09:14 PDTTrainingReplyTeradata 14 basics certification informationThe name basic means basic. But it depends on experience and how basic it is. You will get some clues from the practice questions, given there: Hope you see this link already: http://www.teradata...
83017 Aug 2014 @ 08:45 PDTTrainingReplyTeradata 14 basics certification informationGreat going!! I hope you have seen this link too,  http://forums.teradata.com/forum/training/terdata-certification-in-india You have loads of materials too here with reference to the certifi...
82917 Aug 2014 @ 02:05 PDTDatabaseReplyTDExpress 15.0 unable to install on Fedora .. TimesoutDoes it work on fedora? Some folks have told that they could configure in ubuntu too. But what I see here is Susie http://downloads.teradata.com/download/tools/teradata-studio-express (Read me)
82815 Aug 2014 @ 09:51 PDTTrainingReplyTraining I hope you may have seen the post(s) below(under training forum). You will good responses from many if you provide more details. mention the mode of training: virtual or in-person or classoom tra...
82715 Aug 2014 @ 08:49 PDTData ModelingReplyAny New School of Thought to Optimize Multi-TB Data Mart Analytics? An apology from my end if things do not make sense to you. It is just my viewpoint.   There was a client  before, when I used to work in a consulting company.We just ask them, ...
82615 Aug 2014 @ 05:55 PDTDatabaseReplyREGEXP_REPLACE HELP String fist letter uppercase rest lowercase!Many oracle   functions are available in Teradata 14. You can check it out. In TD 15, you will be amazed to know about various array, varray functions like oracle, aggregate function...
82515 Aug 2014 @ 03:41 PDTDatabaseReplyREGEXP_REPLACE HELP String fist letter uppercase rest lowercase!I see I like to convert: “ teST   is a TEst” to “Test is a Test”. The last word again starts with upper case. I put an initcap to the result you got above. T...
82415 Aug 2014 @ 12:15 PDTDatabaseReplyDetermine new table skew for a different PII am not aware of any dictionary table. However, if it is me, I will write a script which will loop through a table, reading fields and (also composite if need be) and then redirect the output to a...
82314 Aug 2014 @ 01:12 PDTDatabaseReplyTranspose columns to row in a single query You can try with select tdstats.udfconcat(trim(a)) from tbl and union all with a select  tdstats.udfconcat(trim(b)). It will come in one column with quotes and comma. You can ...
82214 Aug 2014 @ 11:13 PDTTrainingReplygood training institutes for teradata You have not mentioned the mode of training: virtual or in-person or classroom training or if classroom, which place.. The more you provide details, the more people can help or guide you.

Pages