#DateForumTypeThreadPost
39627 Dec 2013 @ 02:07 PSTGeneralTopicPMCPHi, Is PMCP coming along with TD installation ? I am curious since I am not able to see PMCPINFO  views. Thanks and regards, Raja
39527 Dec 2013 @ 12:13 PSTDatabaseReplyInserting to a table incrementallyHi Bikky, Tools are always better. But if you dont have tools, then you have to use queries. You can think of this option,keep one table to track load based on identifiable field or fields.Use row...
39427 Dec 2013 @ 12:01 PSTDatabaseReplyFetching the data for thelast quarter dates An easier way is to use a scheduler. Maybe a stored proc too, since you can stuff your logic you want. Cheers, Raja  
39326 Dec 2013 @ 11:31 PSTToolsReplyWhen are secondary indexes required? There may be cases where queries may not use PI. Then SI comes into the picture to enhance performance and chance of avoiding FTS.Value ordered NUSI is recommended for range queries. They ca...
39226 Dec 2013 @ 11:08 PSTDatabaseReplyTeradata Dbase Error:5758 Hi Swathi, You can try and run the query and verify with data , step by step and make the changes in INSERT and see. I guess the update is fine.   Dont run the entire stuff, jus...
39126 Dec 2013 @ 10:39 PSTDatabaseReplyFetching the data for thelast quarter datesHi, The discussion , with calendar or without calendar is in this link. You could have searched for it :).  http://forums.teradata.com/forum/data-modeling/can-teradata-display-the-quarter-va...
39026 Dec 2013 @ 09:32 PSTDatabaseReplyextending MLPPI tablesAFAIK, it is not possible since it is populated table. However, you can think of or try to do thus: Note: to be 100% sure, you can take backup of entire table, because I dont know the version of T...
38926 Dec 2013 @ 09:11 PSTDatabaseReplyTable Partitionall-rows scan with a condition of ("(INFORM_USER.TABLEA.MO_ID = 201202) OR (INFORM_USER.TABLEA.MO_ID = 201201)")  Cheers, Raja
38826 Dec 2013 @ 08:49 PSTAnalyticsReplyrun queries in parallel and serialYou can use session or pack factor. You can use Pack factor with repeat  judiciously. Cheers, Raja
38726 Dec 2013 @ 03:48 PSTDatabaseReplyMany tables or many databases?Hi, I feel you need to look at things from different perspectives like, short term, long term plans. Will the group expand or shrink? How the data volume is going to grow? Think from the st...
38626 Dec 2013 @ 03:05 PSTTeradata ApplicationsReplyCLI '215' occurred while connecting to the RDBMS while using TPT utility tbuild on UnixHi, I never encounter this issue. However I found a message for the error you post thus: Network-Attached Call-Level Interface Version 2 (CLIv2) Messages    215 EM_CO...
38526 Dec 2013 @ 01:04 PSTMarketing & CRMTopicTeradata CRM   Products matter but customer satisfaction results count. Teradata CRM offers superior advantages compared to other competitors, it seems.   I have a look at Teradata Acti...
38425 Dec 2013 @ 09:10 PSTToolsReplybteq blank Spaces Hi, Did you try with trim and cast together? I hope you will be using  .SET SIDETITLES OFF; .SET TITLEDASHES OFF; .SET RECORDMODE OFF;  example:   select CAST( fie...
38325 Dec 2013 @ 08:39 PSTDatabaseReplyTeradata Dbase Error:5758Hi Swathi, Your query is very long and I see a lot of trim :). Since you know the joining condtions and fields very well, an explanation is given in this link: http://www.info.teradata.com/HTMLPu...
38224 Dec 2013 @ 06:16 PSTDatabaseReplyDoes one need unicode compression in Tredata 14.0In the context of table joins, I feel that we need to be careful so that both  the joining fields are of the same characters, else there will be performance degrade. I have heard quite a numbe...
38123 Dec 2013 @ 08:44 PSTGeneralReplyTeradata Lock - 3 Insert StatementsHi Rohit, It is processed in sequence. Cheers, Raja
38023 Dec 2013 @ 08:23 PSTDatabaseReplyTop FunctionHi Ratnam, Sample mainly for getting samples of row from table or view. We can use SAMPLE n, where n is an integer or can be decimal between 1.00 and 0.00. We can also use SAMPLEID.   ...
37922 Dec 2013 @ 11:12 PSTMarketing & CRMReplyManaging Control Groups within TCRM ApplicationHi, I am not able to see the download. Am I looking at the right link? like this: http://www.info.teradata.com/ApplSoft/eApplSoft-BrowseBy.cfm Thanks and regards, Raja
37822 Dec 2013 @ 11:04 PSTGeneralReplyTeradata Lock - 3 Insert Statements User P1: BT; LOCKING ROW FOR WRITE SELECT y FROM t WHERE x=1;   UPDATE t SET y=0 WHERE x=1 ET;   User P2: BT; LOCKING ROW FOR WR...
37722 Dec 2013 @ 09:53 PSTAnalyticsReplyFASTEXPYou can use these commands like .SET, .ACCEPT, to assign variable values and then you can use them in query.Also , we can define .LAYOUT to take the fields from input file to be used in the select ...
37621 Dec 2013 @ 09:48 PSTDatabaseTopicNeed urgent help on new laptop for installing TeradataApology for creating at two places. Please see my urgent help needed. Apology, for putting in wrong heading. But since it is top of the page, so I think it may help. I put it here: http://forums....
37521 Dec 2013 @ 09:13 PSTGeneralReplyTeradata Lock - 3 Insert StatementsYes it has to wait till other process completes: LOCKING ROW FOR WRITE is used to lock row for write. Deadlock can occur  when two PI SELECTs are followed by PI UPDATES and the SELECT...
37421 Dec 2013 @ 08:46 PSTGeneralReplyIdentify tables whose partition has to be changed relatively to incorporate new year values in narrow windowI feel that UNKNOWN partitioning is not needed after you specify IS NOT NULL. Let us hear from other experts too. Cheers, Raja
37321 Dec 2013 @ 08:08 PSTCloud ComputingTopicNeed urgent help on configuration I am buying a new laptop very urgently as I need to surrender my current laptop. I need to install TTU 14.10 in the new laptop. I chose this Lenovo laptop with this configuration below. The ...
37220 Dec 2013 @ 07:57 PSTDatabaseReplyTeradata vs oltp Hi,   I have seen many comparisons. First we need to know both the technologies  very well and then we can comment. Teradata has so many features of OLTP then and now also. See...

Pages