101 | 21 Jun 2013 @ 04:56 PDT | Database | Reply | Unable to log on minimum number of fastload sessions | Can you please share exact error code and FL script and more detials like how many AMPs on the system, what are the value of DBS control parameter, TASM is enabled or not etc.
|
100 | 20 Jun 2013 @ 06:20 PDT | Database | Reply | Compression on Indexes | you can't use MVC to compress Partitioning column |
99 | 23 May 2013 @ 02:45 PDT | UDA | Reply | TDM vs Other Load Utilities | I don't think you can use TDM as stand alone utility like other TTU, I guess, it comes as a part managed server. Better is to check with your Teradata account manager
|
98 | 22 May 2013 @ 02:40 PDT | Database | Reply | PPI | Please don't post any marketing stuff in any techinal disucssion thread or tehnical forum.. it waste other's time ...
|
97 | 10 May 2013 @ 07:18 PDT | Database | Reply | PPI | i m not clear what exactly is your doubt.
1) you can define NUPI with PPI as well
2) order_date and customer_number both can have duplicate values, but there combination should be unique.
|
96 | 03 May 2013 @ 05:59 PDT | Database | Reply | Data Transfer using TPT | I am not sure, but I think that Teradata Database Server and Client Utilities licenses are sold separately and all the utilities are not mandatory for any customer to buy. TPT is basicall... |
95 | 03 May 2013 @ 04:46 PDT | Database | Reply | Teradata basics | Download the Book "Introduction to Teradata" for understaning basic conepts architecture of teradata and from Below link
http://www.info.teradata.com/templates/eSrchResults.c... |
94 | 02 May 2013 @ 07:48 PDT | General | Reply | Error while replying to a Post | Yes, I too had a problem with single post, but now it is working. If it happens with others also some time, we should report it to Neil, so that he can report it ... |
93 | 02 May 2013 @ 06:52 PDT | Database | Reply | Drop Temporary Tables | I guess, we can't use TEMPORARY keyword with ALL
|
92 | 02 May 2013 @ 04:25 PDT | Database | Reply | Arcmain | I have used ARCMAIN and TARA and usually they run smoothly. I am not sure what type of objects you are trying to restore. If possible, try copy instead of restore to see if it is successful or not
|
91 | 02 May 2013 @ 03:49 PDT | General | Topic | Error while replying to a Post | It seems that there is some error with below post as when I try to reply to this post it doesn't work. As a database person, I can guess, it is may be because of some locking issue or may be an... |
90 | 02 May 2013 @ 03:36 PDT | Database | Reply | Creating a new secondary index on table | Is it a custom table or a system defined DBQL table in DBC ?
|
89 | 22 Apr 2013 @ 02:46 PDT | Database | Reply | DBQLOBJTBL - unknown values | I have responed to your original post
|
88 | 22 Apr 2013 @ 02:45 PDT | Database | Reply | Creating a new secondary index on table | You Can use SQL like this
SEL * FROM dbc.DBQLObjTbl
WHERE ObjectType = 'Idx'
AND ObjectNum = 4 /* or whatever is your secondary index number 8, 12, 16 ... */
AND ObjectDatabaseN... |
87 | 19 Apr 2013 @ 06:35 PDT | Database | Reply | DBQLOBJTBL - unknown values | in simple words, the values which are not in the list mentioned in TD14 manual, but you see in your table are actully the sum of any of those values from the list ike 3 = 2 + 1, 6 = 2+ 4 etc.
So, ... |
86 | 18 Oct 2012 @ 02:10 PDT | Database | Reply | Date Conversion | Internally, Teradata does not store Date as in any speicifc Date format, it stores Date value as a four-byte signed integer value dervied based on
(YEAR - 1900) * 10000 + (MONTH * 100) + DAY
&nb... |
85 | 18 Oct 2012 @ 12:27 PDT | Database | Reply | How to identify tables that have been Block-level compressed using SQL | I guess, DBC tables don't store that information.
|
84 | 17 Oct 2012 @ 11:53 PDT | Database | Reply | Roles - Profiles Best Practices | Both serve the different purposes, but they are generally used to help manage Group of common users.
Roles are used to manage access rights. You should have at least one role defined for&nbs... |
83 | 28 Sep 2012 @ 02:40 PDT | General | Reply | How to know AMPs and Nodes list from teradata database from working application | Dieter,
Is it
exact answer: 42
or you want to say
exact answer: 2
I m not clear
|
82 | 28 Sep 2012 @ 02:37 PDT | Training | Reply | Teradata 12 Certification | Go to Teradata Certification home page
http://www.teradata.com/tcpp/teradata-12-certification-exams/
and click on Exam Objectives
|
81 | 28 Sep 2012 @ 01:59 PDT | General | Reply | Email notifications now available | i am not able to see e-mail icon, i m using IE 8
|
80 | 28 Sep 2012 @ 01:13 PDT | UDA | Reply | The input table can't be compressed | have you been successful to compress any table, if not first check your DBS Control setting. Few parameters needs to set before using BLC.
If you are getting error for any particular table. Please... |
79 | 27 Sep 2012 @ 02:37 PDT | Database | Reply | How to check if data is in upper case or not | This will tell you only wheather your first char is in uppercase or not
|
78 | 27 Sep 2012 @ 02:21 PDT | Database | Reply | Strange(?) error creating FK constraints | I have explored several dbc tables/view, but couldn't find any table/column which store this information
|
77 | 26 Sep 2012 @ 10:24 PDT | Database | Reply | Help required in querying dbc tables | I don't think, you can get this info through any of the DBC tables. I am not sure if any of the databse utilities have any such command, but I'll check.
There is one way through whic... |