#DateForumTypeThreadPost
2826 Jan 2016 @ 11:36 PSTToolsTopicTPT 15.00 is loading NULL dataHello, We are using TPT 15.00.00.03 (LOAD operator) through informatica 9.6.1 hf2. It is giving weird behavior. It is loading first 5-6 columns correct data and all rest of columns in table as NU...
2717 Apr 2014 @ 01:30 PDTDatabaseTopicHow to find if system has AMFS enabled?Hello, Can somebody tell me to find if system has Anonymous Memory Filesystem (AMFS) enabled? Thanks, Shrinivas
2625 Mar 2014 @ 10:28 PDTPrivate Forum
2507 Dec 2013 @ 08:03 PSTDatabaseTopicTD14.10 feature experience Hello, Is there anybody who have upgraded system to TD14.10? How are your experiences with different TD14.10 features? In 14.10 release definition it is written that 14.10 needs more memory per no...
2427 Nov 2013 @ 09:33 PSTViewpointReplyAWT Max LimitInternal DBS Control parameter number 4: MaxAMPWorkerTasks
2308 Nov 2013 @ 03:57 PSTDatabaseTopicLastAlterName = AllHello, I noticed that I have a few tables with "LastAlterName = ALL". RequestText is "ALTER" or "CREATE INDEX". I do have DBQL enabled for each user. But I don't ...
2203 Jul 2013 @ 10:04 PDTDatabaseReplyDBSControl Internal flag DISABLECARDisableCAR - This field enables or disables column level SELECT and INSERT rights.                   &nbs...
2113 May 2013 @ 11:49 PDTGeneralReply'Row Number () Partition By' syntax problemBecause you have not added it in SELECT part. What you want to do with RANK_ID in result set? Even if you add it then all values will be 1.
2013 May 2013 @ 09:57 PDTGeneralReply'Row Number () Partition By' syntax problemYour derived table needs a name.   SELECT Subscription_Id , Wrls_Prod_Eff_Dt , Wrls_Prod_Cd , Wrls_Prod_Ds FROM ( SELECT A.*, ROW_NUMBER () OVER (PARTITION BY Subscription_Id ORDER...
1913 May 2013 @ 02:16 PDTViewpointReplySESDELAYED vs DELAYED DELAYED:           The session is being delayed because query limit, imposed by a TASM throttle rule, has been met. SESDELAYED:  &nb...
1822 Apr 2013 @ 02:29 PDTViewpointReplyDATAMOVERYou said "below issue facing in datamover in viewpoint". I don't see any details. Did you tried to give print screen of viewpoint? Please give your error details again. Which command ...
1722 Apr 2013 @ 02:24 PDTToolsReplyTPT installation guideLogin to T@YS Software Download --> Teradata Client --> TD Client Platform (AIX) --> Select software base TTU 13.10 --> Select platform base  (Select 32bit or 64 bit)
1622 Apr 2013 @ 01:05 PDTPrivate Forum
1520 Apr 2013 @ 07:05 PDTDatabaseReplyCreating a new secondary index on tableIf you have DBQL Object Logging enabled then you can check it in DBC.DBQLObjTbl under column TypeOfUse.
1419 Apr 2013 @ 07:58 PDTToolsReplyBTEQ Login anomalySudipta, BTEQ is an interactive tool and batch tool. So if you provide password in logon string then in interactive mode it will not work. Same syntax will work if you create bteq script and run i...
1315 Mar 2013 @ 03:09 PDTPrivate Forum
1230 Oct 2012 @ 03:40 PDTPrivate Forum
1129 Oct 2012 @ 09:00 PDTPrivate Forum
1028 Oct 2012 @ 01:17 PDTPrivate Forum
913 Oct 2012 @ 12:17 PDTPrivate Forum
811 Oct 2012 @ 09:41 PDTPrivate Forum
728 Aug 2012 @ 11:47 PDTPrivate Forum
628 Aug 2012 @ 11:41 PDTPrivate Forum
522 Jun 2012 @ 09:14 PDTPrivate Forum
410 May 2012 @ 04:29 PDTPrivate Forum

Pages