All forum activity

#DateUserForumTypeThreadPost
3243514 Jun 2013 @ 11:52 PDTNarasapalli dineshTrainingReplyteradata DBA trainingHi, I'm interseted to learn teradata dev, Please suggest me any one which institute is best in hyderbad..
3243414 Jun 2013 @ 11:40 PDTNarasapalli dineshTrainingReplyTeradata Training Material availableHi Todd, I am very much intrested to learn teradata and do certification in TD14, can you please share the material to my email id : dinesh.narasapalli@valuelab.net Thanks&regards, N.Dinesh
3243314 Jun 2013 @ 10:58 PDTgrybackViewpointReplyDCSDBAgree with Steve. Viewpoint 13.12 released in August 2011 so you are missing features from three major versions (14.00, 14.01, 14.10) and a slew of patch releases. 
3243214 Jun 2013 @ 10:28 PDTjlbViewpointTopicData Labs UsernamesCreating a Lab group also creates a username. What happens with I set a profile to that username with password expiration in number of days? Who changes that password?
3243114 Jun 2013 @ 09:58 PDTrhuamanToolsTopicTTU 64-bitHello,   When I submit a request for the TTU - Windows installation package, I receive a link for the 32-bit version. Does anyone know how I can get the 64- bit version?   Thank you, ...
3243014 Jun 2013 @ 08:37 PDTnaaniEnterpriseReplyfastloadThanks Dieter!!
3242914 Jun 2013 @ 07:43 PDTdnoethDatabaseReplyDetermine number working day between two datesHi Vlad, this can be further simplified, you don't the sys_calendar: SELECT start_date, end_date, end_date-start_date+1 AS period_length, period_length - holiday_days AS working...
3242814 Jun 2013 @ 07:41 PDTraf_vandormaelDatabaseTopicUsed CPU & IO compared to max CPU & IO, both per hour ==> SQL??Dear esteemed experts, I need to deliver to one of my end-users, an overview of the Used CPU & IO compared to their maxs, preferrably per hour. I know i have to look at the resusage and dbql ...
3242714 Jun 2013 @ 07:41 PDTraf_vandormaelDatabaseTopicUsed CPU & IO compared to max CPU & IO, both per hour ==> SQL??Dear esteemed experts, I need to deliver to one of my end-users, an overview of the Used CPU & IO compared to their maxs, preferrably per hour. I know i have to look at the resusage and dbql ...
3242614 Jun 2013 @ 07:13 PDTVBurmistAnalyticsReplyUII and PJI?p.s. earlier these metrics were known as LHR (Larry Higa Ratio) and HLR (Higa Larry Ratio), named after the Teradata performance tuning expert Larry Higa.
3242514 Jun 2013 @ 07:09 PDTVBurmistAnalyticsReplyUII and PJI?PJI (Product Join Indicator) = CPU * 1000 divided by I/O. UII (Unnecessary I/O Indicator) = I/O divided by (CPU * 1000). The metrics are used to make an idea about query efficiency for consuming ...
3242414 Jun 2013 @ 06:24 PDTdnoethDatabaseReplyImprove performance of like queries.You might try to rewrite this LIKE using POSITION or SUBSTRING, but it will probably not reduce CPU.   Dieter
3242314 Jun 2013 @ 06:14 PDTdnoethEnterpriseReplyfastload#1: Yes, but you don't create the error tables, this is done automatically by the tool. You just might change their default names.   #2: MLoad: aquisition phase -> ET-table and appli...
3242214 Jun 2013 @ 06:13 PDTombestDatabaseReplyStats collection inside SP'sFound a workaround for dinamic SQL and collect stat on volatile tables. Set SQL SECURITY INVOKER Creating volatile tables, fill it and others.. and before collecting stat write dummy statement l...
3242114 Jun 2013 @ 05:59 PDTVBurmistDatabaseReplyDetermine number working day between two dates CT A(START_DATE DATE,END_DATE DATE); INS INTO A VALUES('2013-06-03','2013-06-13'); INS INTO A VALUES('2013-06-06','2013-06-12'); INS INTO A VALUES(...
3242014 Jun 2013 @ 05:29 PDTnaaniEnterpriseReplyfastloadHi Gurus, I'm new to Teradata. Please excuse me if I ask some silly questions. Below are my questions: 1. Can I use "CREATE" in Fastload and Multiload? If not, how the error tabl...
3241914 Jun 2013 @ 04:48 PDTpema_yozerDatabaseReplyDetermine number working day between two dateshi Bikky, I dont think it quite solves the problem. you are taking those dates which fall in betwen the dates and marking them as yes, but the second table is already a list of holiday   e...
3241814 Jun 2013 @ 01:34 PDTAdamLEnterpriseReplywhy should we use SET table ?In reference to third comment posted by Fred,    I created a similar table T2_S1 as original source table T1. CREATE volatile SET TABLE T2_S1 (c1 INTEGER NOT NULL,c2 INTEGER...
3241713 Jun 2013 @ 11:52 PDTKishore_1DatabaseTopicResponding Session: CPU Use and Impact CPUI am observing a session thru View Point , which is in responding state for the past 10 days The CPU Use is 0 but the Impact CPU is 33.7 Similary I/O is 0 but I/O skew is 55%. Could anyone expla...
3241613 Jun 2013 @ 11:17 PDTbarani_sachinDatabaseTopicImprove performance of like queries.Hi All,     Is there anyway to improve the performance(Reducing the CPU consumed is the main aim for now) of queries involving like in the where clause.     WHERE FIRST...
3241513 Jun 2013 @ 11:07 PDTterasumDatabaseReplyHUT LockYou have to go to viewpoint/manager and from there go to database console and open up showlocks utility.
3241413 Jun 2013 @ 10:15 PDTKishore_1DatabaseTopicHUT LockWhat is the command to see the tables that are locked by HUT (Host Utility) locks on a Teradata database?
3241313 Jun 2013 @ 05:47 PDTdiogenesesantoCloud ComputingTopicShutting down Teradata in EC2 keeping data and avoiding Amazon chargesHi team, I appreciate to understand the better way to "hibernate" Teradata in Amazon EC2 keeping data and avoiding charges from Amazon. I guess running a Teradata tpa stop and Amazon st...
3241213 Jun 2013 @ 10:14 PDTteradatatesterDatabaseReplyJARO_WINKLER_SIMILARITY Function for Teradata?Anyone already made a UDF for the JARO_WINKLER_SIMILARITY Function?
3241113 Jun 2013 @ 09:58 PDTTonyLToolsReplyTPT script to move data from table to fileIt's not possible because a date column is required to filter the rows.

Pages