#DateForumTypeThreadPost
2003 Jul 2008 @ 10:42 PDTAnalyticsTopicMax Value across several columns in a rowHi ,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...
1919 Mar 2007 @ 02:04 PDTJobsReplyHow to use COALESCE fun with date datatypeTry using current_date
1818 Mar 2007 @ 07:31 PDTJobsReplyHow to use COALESCE fun with date datatypeHi,COALESCE(Field name , 'Any string or Valid Date')Hope this helpsCheers!!
1704 Mar 2007 @ 06:26 PSTAnalyticsTopicMatrix QueryHi, 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 ...
1628 Jul 2006 @ 04:29 PDTDatabaseReplyNUSI Bitmapping?Hi,Ya it compares the rowids ThanksAngel
1521 Jul 2006 @ 07:33 PDTDatabaseReplyNUSI 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....
1418 Jul 2006 @ 07:34 PDTToolsReplyMLOAD VARTEXT FORMATHi,No i dont think so it will support. You can use integer format ThanksAngel
1313 Jul 2006 @ 01:10 PDTToolsReplyAccess module error while running MLOADHi,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...
1212 Jul 2006 @ 07:19 PDTToolsTopicAccess module error while running MLOADHi,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...
1107 Jul 2006 @ 09:00 PDTTrainingReplyHELP on Teradata Application Developer examHi,Do you have any sample questions/PDF apart from the ones available on the sites.thanksAngel
1003 Jul 2006 @ 06:09 PDTToolsReplyFastLoad Performance Tuning for large volumes of input dataHI,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...
919 May 2006 @ 02:14 PDTDatabaseTopicData DistributionHi,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
816 May 2006 @ 08:07 PDTDatabaseReplyQuery to get the last day of each month in a year.Thanks Dieterit worked well
716 May 2006 @ 08:04 PDTDatabaseReplyQuery to get the last day of each month in a year.Hi,If possible can you give me the exact query.Thanks
616 May 2006 @ 05:06 PDTDatabaseTopicQuery 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---...
521 Mar 2006 @ 11:58 PSTAnalyticsReplyTeradata function equivalent to 'LIKE %..%' in TeradataHi,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...
403 Mar 2006 @ 02:34 PSTToolsReplyLoading from a .txt file using OLE loadHi,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...
301 Mar 2006 @ 01:01 PSTDatabaseTopicSecondary IndexHI,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
201 Mar 2006 @ 12:40 PSTDatabaseReplySecondary IndexHi,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...
103 Jan 2006 @ 04:43 PSTToolsTopic.DISPLAY in MLOADHi,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...