28 | 26 Jan 2016 @ 11:36 PST | Tools | Topic | TPT 15.00 is loading NULL data | Hello,
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... |
27 | 17 Apr 2014 @ 01:30 PDT | Database | Topic | How to find if system has AMFS enabled? | Hello,
Can somebody tell me to find if system has Anonymous Memory Filesystem (AMFS) enabled?
Thanks,
Shrinivas
|
26 | 25 Mar 2014 @ 10:28 PDT | Private Forum |
25 | 07 Dec 2013 @ 08:03 PST | Database | Topic | TD14.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... |
24 | 27 Nov 2013 @ 09:33 PST | Viewpoint | Reply | AWT Max Limit | Internal DBS Control parameter number 4: MaxAMPWorkerTasks
|
23 | 08 Nov 2013 @ 03:57 PST | Database | Topic | LastAlterName = All | Hello,
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 ... |
22 | 03 Jul 2013 @ 10:04 PDT | Database | Reply | DBSControl Internal flag DISABLECAR | DisableCAR - This field enables or disables column level SELECT and INSERT rights.
&nbs... |
21 | 13 May 2013 @ 11:49 PDT | General | Reply | 'Row Number () Partition By' syntax problem | Because 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.
|
20 | 13 May 2013 @ 09:57 PDT | General | Reply | 'Row Number () Partition By' syntax problem | Your 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... |
19 | 13 May 2013 @ 02:16 PDT | Viewpoint | Reply | SESDELAYED vs DELAYED |
DELAYED: The session is being delayed because query limit, imposed by a TASM throttle rule, has been met.
SESDELAYED: &nb... |
18 | 22 Apr 2013 @ 02:29 PDT | Viewpoint | Reply | DATAMOVER | You 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 ... |
17 | 22 Apr 2013 @ 02:24 PDT | Tools | Reply | TPT installation guide | Login 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)
|
16 | 22 Apr 2013 @ 01:05 PDT | Private Forum |
15 | 20 Apr 2013 @ 07:05 PDT | Database | Reply | Creating a new secondary index on table | If you have DBQL Object Logging enabled then you can check it in DBC.DBQLObjTbl under column TypeOfUse.
|
14 | 19 Apr 2013 @ 07:58 PDT | Tools | Reply | BTEQ Login anomaly | Sudipta,
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... |
13 | 15 Mar 2013 @ 03:09 PDT | Private Forum |
12 | 30 Oct 2012 @ 03:40 PDT | Private Forum |
11 | 29 Oct 2012 @ 09:00 PDT | Private Forum |
10 | 28 Oct 2012 @ 01:17 PDT | Private Forum |
9 | 13 Oct 2012 @ 12:17 PDT | Private Forum |
8 | 11 Oct 2012 @ 09:41 PDT | Private Forum |
7 | 28 Aug 2012 @ 11:47 PDT | Private Forum |
6 | 28 Aug 2012 @ 11:41 PDT | Private Forum |
5 | 22 Jun 2012 @ 09:14 PDT | Private Forum |
4 | 10 May 2012 @ 04:29 PDT | Private Forum |