#DateForumTypeThreadPost
7401 Nov 2009 @ 10:56 PSTDatabaseReplySite minder authentication for TeradataGuys please give your comments on this.........Doneath, Jimm, Adeel... Where are you.
7326 Oct 2009 @ 05:15 PDTDatabaseTopicSite minder authentication for TeradataHi all,Problem statement :One of my client is having BO and Teradata environment.And BO authentication is happening using site minder.But Teradata authentication is not using site minder , it is us...
7220 Aug 2009 @ 12:24 PDTDatabaseReplyhow to use Primary index efficientlySatish,Your query will not the advantage of UPI because the hash will be different for col1 and the combination of col1,col2 and col3.So if you want to take that advantage you have to use col2 and ...
7117 Aug 2009 @ 12:41 PDTDatabaseReplyHow to fetch the data from one server and insert in to other server in SQL Assistance?Won't be possible using stored procedure..You need to go for scripting which will inturn call fastload or mload.
7017 Aug 2009 @ 12:37 PDTDatabaseReplyHow to find the associated tables or view in teradata?You can achieve this by writing recursive sqlin which the vie name will be the seed for next searchRegards,Subhash
6911 Aug 2009 @ 05:33 PDTDatabaseReplyIgnore Alphanumeric data contentLet me know solution provided by jimm is working for you.Also when you are going to have all special character in where clause use backslash to supress the special meaning of the character.
6807 Aug 2009 @ 02:36 PDTDatabaseReplyIgnore Alphanumeric data contentMore Precise...........select case when upper(col1) (cs) = col1 and lower (col1) (cs) = col1 then col1 else NULL end from testO/P-------?23432412345??7326473
6707 Aug 2009 @ 02:28 PDTDatabaseReplyIgnore Alphanumeric data contentselect * from test;col1----A12323432412345&^&^%^sdjjsgafsg7326473select col1 from test where upper(col1) (cs) = col1 and lower (col1) (cs) = col1O/p-----732647323432412345
6604 Aug 2009 @ 11:26 PDTDatabaseTopicSSO Integration through site minder or LDAPIn our project setup BO uses hard coded user id and password to fetch the data from teradata.So for each user the generic ID is there in DBQL.Now we want to integrate the SSO authentication either ...
6518 Jun 2009 @ 05:31 PDTViewpointTopicsystem is not coming in drop down...Hi ,I have added the TD system in teradata view point.Also connection manager has been enabled for the same.But Still not able to see the system in drop down in view point.Is there any thing we are...
6412 Jun 2009 @ 03:00 PDTDatabaseTopicMulti Level Partitioning v/s secondary indexesWhich one is better from performance wise.What is the criteria to either go for partitioning or indexes ? Regards,Subhash
6315 May 2009 @ 12:23 PDTDatabaseReplyTuningCan u post u'r exact query or at from clause.also if can provide me the row count from uact table after applying the where condition.
6215 May 2009 @ 12:21 PDTDatabaseReplyAdvantage of not Collecting the statsYes I am completely agree what u quoted.But lets have a example of big big EDW where we are having a thousands of objects and billions of data, which is continuously hit by multiple user concurrent...
6112 May 2009 @ 06:43 PDTViewpointReplyViewpoint PDK 13.0.0.1 available for downloadHey Lewis,One QQ?Do I need to be the champ in JAVA to start working in viewpoint?
6012 May 2009 @ 03:52 PDTViewpointReplyViewpoint PDK 13.0.0.1 available for downloadThnx Neil....I am done with thisBut when I downloaded ant 1.7.1 and 1.7.0 (Tried both) the install file is coming as unknown file type.Any Idea?
5912 May 2009 @ 01:55 PDTViewpointReplyViewpoint PDK 13.0.0.1 available for downloadNeilI was trying to install view point but for this need to install JDK.Java 1.5 SDKGet the "Java 2 Platform, Standard Edition 5.0". You'll want the JDK 5.0 without the NetBeans IDE or the Java EE...
5812 May 2009 @ 12:10 PDTDatabaseReplyWhat's the quickest way to find out all the values under an attributesLast thing .........run this...select count(*) from VREMEDY_SYM_TICKETand then this select count(*) from VREMEDY_SYM_TICKET where SYMP_USERID is nullIf the answer is same for both then there is no...
5712 May 2009 @ 11:56 PDTDatabaseReplyWhat's the quickest way to find out all the values under an attributesNo it's not normalFor this conatct with u'r TERADATA DBA and get more spool memory allocation for the user which u are using.
5612 May 2009 @ 11:53 PDTAnalyticsReplyTeradata Optimization needed on query.Other then stat collection U can do these things to optimize u'r query.1) make value ordered SI on SERV_FACT.ACCT_MTH_DT.2) Before applying or implementating point 2 analyze the load strategy for t...
5512 May 2009 @ 11:40 PDTDatabaseReplyWhat's the quickest way to find out all the values under an attributesfirst run this Q:SELECT TTKT_NO, TTKT_STS, SYMP_USERID, SYMP_ACCT_NO, SYMP_USER_TN, CRTN_DTTM, DESK, DTTM_RCVDFROM VREMEDY_SYM_TICKETWHERE DESK = 'TE' AND (CRTN_DTTM BETWEEN ADD_MONTHS(CRTN_DTTM,0)...
5412 May 2009 @ 11:13 PDTDatabaseReplyWhat's the quickest way to find out all the values under an attributesWhat is this SYMP_USERID <> '?'If u are comparing with ? as a string then fine But want to compare with Null then use SYMP_USERID IS NOT NULL
5312 May 2009 @ 09:55 PDTDatabaseReplyWhat's the quickest way to find out all the values under an attributesuse this......date between add_months(date,0) and add_months(date,-4)
5211 May 2009 @ 02:14 PDTDatabaseReplyValid query or not???Can u post the exact quey ?
5109 May 2009 @ 02:22 PDTDatabaseReplyRegarding Teradata Certificationhttp://www.teradata.com/t/teradata-certified-professional-program/
5009 May 2009 @ 02:20 PDTDatabaseReplyTuningLets deal first with your Q:1) yes u can't apply compression on varchar field.2) Yes it will.And go for VONUSI in this case as u are working on date ragne.Now see in u'r query as u are using LIKE ...

Pages