#DateForumTypeThreadPost
4914 Nov 2011 @ 06:28 PSTDatabaseReplyHelp for stats! Hi Dieter, Whats the difference in Skew Factors : ,(MAX(CurrentPerm) / NULLIF(AVG(CurrentPerm),0)) AS Skew_Factor V/S ,(100 - ( AVG(CurrentPerm) / NULLIF(MAX(CurrentPerm),0) * 10...
4829 Sep 2011 @ 09:14 PDTToolsTopicProblem with Teradata Service Control Guys, I was trying to start Teradata using Teradata Service control but facing an error "Bynet Installed, but not running. Reboot to start".I tried to reboot my system and even af...
4731 Jul 2011 @ 11:20 PDTAnalyticsReplyReagrding ProceduresGuys, did any one of you have solution to my above problem..its really urgent..Thanks...
4629 Jul 2011 @ 04:04 PDTAnalyticsTopicReagrding ProceduresDear TD Masters, I have the below procedure : REPLACE PROCEDURE ProcedureName BEGIN DECLARE stmt VARCHAR(1024); SET stmt = 'REPLACE VIEW DatabaseX.ViewA AS LOCK ROW FOR ACCESS' ' SE...
4522 Jul 2011 @ 10:18 PDTAnalyticsTopicHelp Needed in writing SQLHi All, I have the below data in 1 table : Log Date Tablename Space Occupied(GB) 1-Jul-11 Employee 1 2-Jul-11 Employee 2 3-Jul-11 Employee 3 … … … … … … 31-J...
4423 Sep 2009 @ 08:02 PDTDatabaseReplyInserting Null values into tableYou can insert NULL values like below :insert into tablename values (123,NULL,NULL);Here 2nd and 3rd columns will be inserted as NULL values.
4311 Sep 2009 @ 05:57 PDTDatabaseTopicDifference between CPUUSERV & CPUUEXEC in ResUsageScpuHi Teradata Masters,Could you please tell me the exact difference between coulmns CPUUSERV & CPUUEXEC in the ResUsageScpu table.I have gathered some information from the Resource Usage Macros & Tab...
4210 Sep 2009 @ 08:55 PDTDatabaseReplyAdding Compression to existing tableHi ,Alter does not support compression on existing tables.In such a case, there is no other option but to add a new column with compress attribute.Update all the values in old column to new column ...
4110 Sep 2009 @ 05:33 PDTDatabaseReplyAdding Compression to existing tableHi,You can use the ALTER command to add or modify the table columns and add compression information to it.For example :ALTER TABLENAME ADD columnname datatype compress (Values);
4007 Sep 2009 @ 04:18 PDTDatabaseTopicBasic differences between TD12,TD13 & V2R6Hi,Can anybody please let me know the basic differences between the latest versions TD 12,TD 13 with that in V2R6 versionsThanks in advance..
3907 Sep 2009 @ 02:45 PDTUDAReplyTeradata SchemaThanks Jimm,This means teradata supports mixed type of schema ie it is basically based upon 3rd normal form but usually also supports star or snow flake schema implementations also along with it.Co...
3806 Sep 2009 @ 08:28 PDTUDATopicTeradata SchemaHi,Could you please tell me which schema does Teradata follows:Star Schemaor Snow Flake Schemaor 3rd Normalized schema
3731 Jul 2009 @ 08:40 PDTDatabaseReplyImport Problem - Date fieldHi Ncullen,Make sure all the date field in the import file is in the format 'yyyy-mm-dd' and then try importing.I hope it works..
3620 Jul 2009 @ 03:50 PDTDatabaseReplyRegarding Query InfoHi Friends,Could you also confirm,can we use IN and NOT IN functions in Case statements also like below :When (COLUMN_1 = 'X' And COLUMN_2 in('20','21' )) Thanks for your responses
3517 Jul 2009 @ 10:56 PDTDatabaseTopicRegarding Query InfoHi All,Can I use this below condition in the case statement which have two columns from the same table like :Case When ANS.Column_mig <> ANS.Column_mig2 OR Case When ANS.Column_mig ...
3416 Jul 2009 @ 09:26 PDTDatabaseReplyStrange ProblemThanks Dieter,Before you telling me...I was going to post the same on this link that I have found the resolution to my problem ..its the same that you just mentioned ...Thanks a million for all you...
3316 Jul 2009 @ 06:20 PDTDatabaseReplyStrange ProblemHi Dieter/All,Previously I was thinking that the problem was with the transaction mode.I am using Teradata session mode only which I confirm after looking into the Session table.But now I have real...
3215 Jul 2009 @ 07:19 PDTDatabaseReplyAccess ProblemThe problem was that the databasename of the macro and the table getting created were same and this database didn't had access to create table in its own database.Thanks a lot Dieter for your reply..
3115 Jul 2009 @ 07:16 PDTDatabaseReplyHow Many Nodes/AMPs in the systemHi Pawan, Any of the below queires can tell u about the no. of Amps in the system :select count(distinct vproc) from dbc.diskspaceselect hashamp()+1Select Count( distinct vproc) from dbc.AmpUsageNo...
3014 Jul 2009 @ 08:47 PDTDatabaseReplyAccess ProblemHi Dieter,We have already executed these statements infact we have given grant access to all the onwers in the hierarchy but all in vain..
2914 Jul 2009 @ 07:53 PDTDatabaseReplyUsing Insert Mode in TeradataThanks a lot Dieter for your helpful comments.
2814 Jul 2009 @ 07:44 PDTDatabaseReplyAccess ProblemHi Dieter,The database of the macro and the table getting created are both same.
2714 Jul 2009 @ 06:38 PDTDatabaseTopicAccess ProblemHi All,I am facing an error while executing a macro which has a create table statement inside it. :" Failure 3524 An owner referenced by user does not have CREATE TABLE WITH GRANT OPTION access to ...
2614 Jul 2009 @ 05:37 PDTDatabaseReplyStrange ProblemThanks Dieter,The problem seems to be with the transaction mode only.
2514 Jul 2009 @ 05:12 PDTDatabaseReplyUsing Insert Mode in TeradataHi Dieter,Thanks for your response.So which one of the two do you think will be used if performance is considered and why ?

Pages