792 | 21 Apr 2006 @ 12:44 PDT | JayRecruit | Jobs | Topic | Teradata DBA in New Hampshire, USA | Location: Keene, NHDuration: 6 months right to hireSkills and description:Our direct Client is seeking a highly motivated Sr. Teradata Data DBA for their Enterprise Data Warehousing initiative. The... |
791 | 21 Apr 2006 @ 12:17 PDT | dcasady | Database | Topic | Teradata User Group -- Seattle, Washington | Hi,Does anyone know of a Teradata User Group in Seattle, WA? I am new to the area and would like to participate. If one does not exisst, does anyone know what is required to start one?Thanks |
790 | 21 Apr 2006 @ 11:49 PDT | bp597 | Database | Topic | Authority Issue | New Teradata Customer with an authority issue.I create a new user TEST2.The user is created by SYSDBA.The user resides under DEDW_USERSExample: SYSDBA DEDW DEDW_USERS ... |
789 | 21 Apr 2006 @ 10:56 PDT | BBR2 | UDA | Reply | Syntax to create surrogate keys in a table | I don't know if you have got any replies on this.We had implemented separate KEY and MAP tables in past.These key tables will have a surrogate key and also their natural key counterpart. In fact th... |
788 | 21 Apr 2006 @ 10:40 PDT | BBR2 | Database | Topic | Collect Stats Report | All,Is there a way (SQL) we can get information as we get from Teradata Administrator to check statistics information. Sample output from TD AdministratorDate Time Unique Values Column Names06... |
787 | 21 Apr 2006 @ 08:58 PDT | dharma | Analytics | Reply | Randomied sample | Paul,Thanks a lot.I will have to try it.Your logic should work ...thanksteja |
786 | 21 Apr 2006 @ 07:48 PDT | Viswanathan | Connectivity | Topic | issue with Teradata ODBC 03.05 in AIX5.2 | HiI need some quick help with Teradata ODBC Driver in AIX.All these days 03.04 version is working fine.I upgraded my system to 03.05.Now when attempting to connect to a Teradata Server it gives me ... |
785 | 20 Apr 2006 @ 09:34 PDT | pwsegal@gmail.com | Analytics | Reply | Randomied sample | Well if you treat the table as the population, then as the sample you draw from that population increases, the closer that the mean of the sample will be to the mean of the population.So if you wan... |
784 | 20 Apr 2006 @ 12:14 PDT | young | Database | Reply | How to get tablename | help database dbname;you can get all tablename within your dbname |
783 | 20 Apr 2006 @ 12:08 PDT | young | Database | Topic | question about de-normalization | what is the relationship between physical de-normalization and join index?substitute or they two mean the same thing?need your help, |
782 | 20 Apr 2006 @ 11:50 PDT | BBR2 | Database | Reply | Write/Read external file from within Stored Procedure? | Craig,Why don't you consider populating a volatile or global temporary table instead of permtable. You can export out with same bteq session.Again if the record set is very high, you would need a l... |
781 | 20 Apr 2006 @ 11:41 PDT | Craig.Schweizer | Database | Reply | Write/Read external file from within Stored Procedure? | Thanks Stami! |
780 | 20 Apr 2006 @ 11:36 PDT | stami27-2406 | Database | Reply | Write/Read external file from within Stored Procedure? | Hi Craig, sorry for the html mistake above.The rihgt notation of the unix Command for the bteq above (say its name is select_test.bteq) were:bteq < select_test.bteq > select_test.outthanks stami27 |
779 | 20 Apr 2006 @ 09:48 PDT | stami27-2406 | Database | Reply | Write/Read external file from within Stored Procedure? | Hi,had a similar problem.My stored procedure write in a table and then whith a simple bteq (on Unix) exported the table to a file.Example of bteq:---------------------------------------------------... |
778 | 20 Apr 2006 @ 08:49 PDT | Craig.Schweizer | Database | Reply | Write/Read external file from within Stored Procedure? | Thank you for the update. Unfortunately a table won't work since the data needs to be sent out of house via flat file. |
777 | 20 Apr 2006 @ 08:25 PDT | dharma | Analytics | Reply | Randomied sample | Thanks a lot paul.but the problem i have at hand is by the query above i will be picking accounts with ASR that is near to the avarage ASR of the table.But all i want is i would like to table accou... |
776 | 20 Apr 2006 @ 05:35 PDT | pwsegal@gmail.com | Analytics | Reply | identity columns | A little late with this, but however:You can use the ROW_NUMBER ordered analytical function.So something likeSELECT ROW_NUMBER() OVER(order by col2),col2FROM tableBwill give you Col1 Col21 ... |
775 | 20 Apr 2006 @ 05:21 PDT | pwsegal@gmail.com | Analytics | Reply | Randomied sample | First you need to decide what you mean by "close to". For the example code I'll assume that close is within 1/2 a standard deviation of the average.One way of doing it is:SELECT * FROM big_tableWHE... |
774 | 20 Apr 2006 @ 12:28 PDT | Kks | Training | Reply | Link to Teradata Basics Web-Based Training (WBT) | and info.ncr.com will give you all the documentation |
773 | 19 Apr 2006 @ 06:50 PDT | Jim Chapman | Database | Reply | Write/Read external file from within Stored Procedure? | There is no good way to do that with Teradata. Even if methods for accessing the host OS file system were available, it probably would not be useful on MPP configurations, since you don't have con... |
772 | 19 Apr 2006 @ 11:21 PDT | BBR2 | Database | Reply | Number of weeks in a given month and year | Feroz,Good catch.I should have checked for other months as well.Vinay |
771 | 19 Apr 2006 @ 11:02 PDT | shaik.feroz@aaa-calif.com | Database | Reply | Number of weeks in a given month and year | hello Vinay!SELDistinct Year_Of_Calendar (TITLE 'YEAR'),Month_Of_Year (TITLE 'MONTH'),Week_Of_Month + 1 (TITLE 'WEEK') --,Calendar_Date (TITLE 'DATE')FROM sys_calendar.calendar WHERE year_of_calend... |
770 | 19 Apr 2006 @ 10:46 PDT | BBR2 | Database | Reply | Randomied sample | I think you can use ordered analytical functionsSEL KEY_COL,AVG(ASR) OVER() FROM TEST SAMPLE 1000; instead of 1000, you can probably give a % of record as .15 (for 15% of records).You can use this... |
769 | 19 Apr 2006 @ 10:29 PDT | BBR2 | Database | Reply | weird issue importing from excel to TD..... | Mike,You may want to remove all column header information from the export report file. This should help.For the date issue, you will need to change the format to match the date format (for the colu... |
768 | 19 Apr 2006 @ 10:25 PDT | BBR2 | Database | Reply | Number of weeks in a given month and year | Abdul,You can use the following SELDistinct Year_Of_Calendar (TITLE 'YEAR'),Month_Of_Year (TITLE 'MONTH'),Week_Of_Month + 1 (TITLE 'WEEK') --,Calendar_Date (TITLE 'DATE')FROM sys_calendar.calend... |