20 | 03 Jul 2008 @ 10:42 PDT | Analytics | Topic | Max Value across several columns in a row | Hi ,I have a problem. For every row in a table , i have to find out max across 5 columns. Though i can use Case statement, I want to know the most efficient way of doing this. For eg- id data1 dat... |
19 | 19 Mar 2007 @ 02:04 PDT | Jobs | Reply | How to use COALESCE fun with date datatype | Try using current_date |
18 | 18 Mar 2007 @ 07:31 PDT | Jobs | Reply | How to use COALESCE fun with date datatype | Hi,COALESCE(Field name , 'Any string or Valid Date')Hope this helpsCheers!! |
17 | 04 Mar 2007 @ 06:26 PST | Analytics | Topic | Matrix Query | Hi, I have a table like this . Customer id Product Held Prod A Prod B Prod C Prod D Prod E1001 A 1 1 0 1 1 01001 B 0 0 0 0 0 01001 C 1 1 0 1 1 01001 D 1 1 0 1 1 01001 E 0 0 0 0 0 01002 A 0 0 0 0 0 ... |
16 | 28 Jul 2006 @ 04:29 PDT | Database | Reply | NUSI Bitmapping? | Hi,Ya it compares the rowids ThanksAngel |
15 | 21 Jul 2006 @ 07:33 PDT | Database | Reply | NUSI Bitmapping? | Hi,If you do collect statistics on all NUSI ,then PE gains the ability to utilize Bit mapping. When multiple NUSI values are compared with AND operator, PE may choose a plan to create NUSI Bit map.... |
14 | 18 Jul 2006 @ 07:34 PDT | Tools | Reply | MLOAD VARTEXT FORMAT | Hi,No i dont think so it will support. You can use integer format ThanksAngel |
13 | 13 Jul 2006 @ 01:10 PDT | Tools | Reply | Access module error while running MLOAD | Hi,Thanx for the response. I tried giving the quotes around and also applied the FORMAT command. It is still not working but this time it is not throwing any error. It is just not able to read/reco... |
12 | 12 Jul 2006 @ 07:19 PDT | Tools | Topic | Access module error while running MLOAD | Hi,I'm getting access module error while running mload script from command prompt. FYI- I'm using a demo version of teradata V2R5. The text file is as simple as aaxabcdddddaaaaaand the table is emp... |
11 | 07 Jul 2006 @ 09:00 PDT | Training | Reply | HELP on Teradata Application Developer exam | Hi,Do you have any sample questions/PDF apart from the ones available on the sites.thanksAngel |
10 | 03 Jul 2006 @ 06:09 PDT | Tools | Reply | FastLoad Performance Tuning for large volumes of input data | HI,As stated ion your query you have NUPI defined on the table. You have not mentioned whether you table is SET or MULTISET. Assuming your table is SET, then Teradata does a duplicate row check for... |
9 | 19 May 2006 @ 02:14 PDT | Database | Topic | Data Distribution | Hi,Suppose we have a 10 AMP system. I have a table with 5 rows. How will the rows be distributed on the 10 AMP system.ThanksAngel |
8 | 16 May 2006 @ 08:07 PDT | Database | Reply | Query to get the last day of each month in a year. | Thanks Dieterit worked well |
7 | 16 May 2006 @ 08:04 PDT | Database | Reply | Query to get the last day of each month in a year. | Hi,If possible can you give me the exact query.Thanks |
6 | 16 May 2006 @ 05:06 PDT | Database | Topic | Query to get the last day of each month in a year. | hi,I have a empl table. i want to get a report for all those employees who joined on the last day of each month. Let's say for year 2005all employees who joined on 31st jan, 28 th feb, 31 march---... |
5 | 21 Mar 2006 @ 11:58 PST | Analytics | Reply | Teradata function equivalent to 'LIKE %..%' in Teradata | Hi,We can use ESCAPE to locate a wildcard character.For example SELECT TABLENAME FROM DBC.TABLESwhere tablename like ('-------\_%)' ESCAPE '\'This will return all tables where '_' is in eighth posi... |
4 | 03 Mar 2006 @ 02:34 PST | Tools | Reply | Loading from a .txt file using OLE load | Hi,It has a graphical interface where you can just select the source database and its columns and then select the target where you want to load the tables .Once you are done with that, just tell it... |
3 | 01 Mar 2006 @ 01:01 PST | Database | Topic | Secondary Index | HI,can anyone tell me why do we need Secondary Index when we already have PI. Cite some example where we we use both PI and SIThanks |
2 | 01 Mar 2006 @ 12:40 PST | Database | Reply | Secondary Index | Hi,It is of the utmost importance to collect statistics on all NUSIs. Statistics might impact whether or not the optimizer chooses to use a secondary index, which could result in substantial differ... |
1 | 03 Jan 2006 @ 04:43 PST | Tools | Topic | .DISPLAY in MLOAD | Hi,I have a file which contain date fields. There is a possibility in which one of the fields can be blank so i am using .DISPLAY command to output the message to MVS. But it gives the error "End o... |