35 | 22 Jun 2006 @ 09:37 PDT | Database | Reply | Duplicate value | Hi,are you thinking about duplicate rows or duplicate PI values?If you're thinking about duplicate rows, then you'll probably have a multiset table with a NUPI on it.1- if you don't want to have du... |
34 | 21 Jun 2006 @ 10:08 PDT | Database | Reply | command to see description of column in teradata | Hi, you can retrieve:1. column list using "help table " syntax2. DDL of your table using "show table " syntaxHope this helps,Bye,TDUser |
33 | 14 Jun 2006 @ 03:40 PDT | Database | Reply | New to teradata | Hi,yes you can installa Teradata on your Windows computer.I don't know if you can donwnload the demo version from one Teradata website, but you can ask for the free demo cd. It will be sent to you ... |
32 | 13 Jun 2006 @ 04:25 PDT | Training | Reply | Teradata Design Architect | Hi,the exam you are interested in is based on the same topics of the phisycal implementation one, but it requires a deeper knowledge of these topics.Take a look at http://www.teradata.ncr-education... |
31 | 16 May 2006 @ 05:12 PDT | Database | Reply | Query to get the last day of each month in a year. | Hi,what about joining your empl table with sys_calendar.calendar on employee_date = the last day of every month? Obviously you have to extract from sys_calendar.calendar view the last day for each ... |
30 | 11 May 2006 @ 07:57 PDT | Tools | Reply | Invoke Teradata BTEQ/MLOAD scripts from unix shell script | In your shell script you can use the same commends you use in windows environment:betq < the ctl filename >> the log filenamehope this helps,bye,TDUser |
29 | 11 May 2006 @ 02:40 PDT | Analytics | Reply | 3706: Syntax error: expected something between ')' and ','. For derived | Hi, what about defining alias for each field of the derived table???I haven't tested your query, but I would use correct aliasing in using derived tables as a general behaviour....Bye, TDUser |
28 | 10 May 2006 @ 05:05 PDT | Database | Reply | COLLECT STATISTICS | Hi TS,I would answer like this to your questions:1. when writing about small tables you are thinking about lookup tables, aren't you? if so, thinking about a 3NF db, I would collect stats on the pk... |
27 | 08 May 2006 @ 04:01 PDT | Tools | Reply | Multiload pre-Begin Mload Target Table DELETE ALL | Hi bc,dropping/deleting tables or doing housekeeping sql before the .begin mload statement is permitted in a MLD thanks to the support environment that is a special environment that allows you to e... |
26 | 05 May 2006 @ 04:34 PDT | UDA | Reply | How to Create Flat File | Hi, if you have Teradata RDBMS installed somewhere, on the server you'll find the executable files to run. Usually you find them in Program Files\Ncr\Teradata Client\bin\ directory.You may execute ... |
25 | 04 May 2006 @ 08:48 PDT | UDA | Reply | How to Create Flat File | Hi Nits,you can create a flat file using fastexport utility. at this file:.logtable |
24 | 04 May 2006 @ 07:13 PDT | Database | Reply | How to find a lost password for a user | Well, if you were on your personal server.... what about applying the best "stop and restart solution"? That, in your case, would be uninstall and install the RDBMS again? :-) Joking aside, I don'... |
23 | 04 May 2006 @ 06:19 PDT | Database | Reply | How to find a lost password for a user | Hi Amit,I don't think you can retireve a pwd once it has stored in the DD. If you look at dbc.DBase table you may understand the reason...If I were you I would chenge the user pwd connecting with a... |
22 | 02 May 2006 @ 09:05 PDT | Database | Reply | Error Code 2652. Operation Not allowed. | You may use an empty file if the first fastload does't perform the "end loading" command.In this case its RC is = 4, that is FastLoad paused. this is a very good way to load several files into an e... |
21 | 02 May 2006 @ 08:22 PDT | Database | Reply | Error Code 2652. Operation Not allowed. | Hi,this means that the fastload RD isn't 0. You must have a look to the log and understand what is your problem.Could you please post the fld log?However, in most of cases if one FLD job ends with ... |
20 | 02 May 2006 @ 05:05 PDT | Database | Reply | how to get the primary indexes of all the tables in a user using dbc tables | Ooopsss, sorry, I was wrong in posting the sql; you are asking about PI and not only tables.... :-) !Well, you may query dbc.indicesx view and look at indextype = 'p'.Bye!TDUser |
19 | 02 May 2006 @ 04:34 PDT | Database | Reply | how to get the primary indexes of all the tables in a user using dbc tables | Try this:select *from dbc.tableswhere databasename = '';If you query directly tablesx view, you'll get only the tables and views of the username you are logged in with.Hope this helps,Bye,TDUser |
18 | 28 Apr 2006 @ 12:55 PDT | UDA | Reply | confidence showned in explain plan | Great!I've always supposed that index join confidence was not so good, due to my direct experience; but this was probably due to having poor statistics...Thank you for you explanation, have a nice ... |
17 | 13 Apr 2006 @ 05:57 PDT | Database | Reply | question on TD partition, need help! | If:1. the values of your PI are unique2. the partitioning column isn't part of your PIthen you can define a USI on these columns.Then you're right!TDUser |
16 | 13 Apr 2006 @ 03:55 PDT | Database | Reply | question on TD partition, need help! | Hi Young,you're right: if your Primary Index is defined as not unique (but its values ARE unique), in order to ensure uniqueness you may use a USI.But you write "PI value is not unique".... I proba... |
15 | 11 Apr 2006 @ 09:09 PDT | Tools | Reply | Help required BTEQ IMPORT | Hi Musomasu,try defining fornmat for you input file....if I were you I would define format vartext and declare eno variable as VARCHAR(1).Hope this helps,Bye,TDUser |
14 | 31 Mar 2006 @ 06:16 PST | Tools | Reply | Tpump - Is blocking normal? | Hi,I've already encountered the problem you are describing here. Some colleagues of mine experienced tpump sessions locking each other.At this moment I don't remember really exactly but if I'm righ... |
13 | 13 Mar 2006 @ 12:20 PST | UDA | Reply | confidence showned in explain plan | Hi dixon,if I were you I would collect stats on the joined columns of both right and left table.I think index join confidence is bettere than no confidence; I've heard that it is worst than low con... |
12 | 09 Mar 2006 @ 05:21 PST | Database | Reply | on product join | Well, this is a bit wide question....To start, try analyzing the explain plan and collecting statistics on the join fields.Bye,TDUser |
11 | 09 Mar 2006 @ 04:09 PST | Database | Reply | teradata Certification Question model help | Hi,take a look athttp://teradata.ncr-education.com/cgi-shell/wbt/dologin.pl?learning/TDCert/loginV2R5.htmand you'll find some tests.Bye,TDUser |