All forum activity

#DateUserForumTypeThreadPost
79221 Apr 2006 @ 12:44 PDTJayRecruitJobsTopicTeradata DBA in New Hampshire, USALocation: 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...
79121 Apr 2006 @ 12:17 PDTdcasadyDatabaseTopicTeradata User Group -- Seattle, WashingtonHi,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
79021 Apr 2006 @ 11:49 PDTbp597DatabaseTopicAuthority IssueNew 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 ...
78921 Apr 2006 @ 10:56 PDTBBR2UDAReplySyntax to create surrogate keys in a tableI 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...
78821 Apr 2006 @ 10:40 PDTBBR2DatabaseTopicCollect Stats ReportAll,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...
78721 Apr 2006 @ 08:58 PDTdharmaAnalyticsReplyRandomied samplePaul,Thanks a lot.I will have to try it.Your logic should work ...thanksteja
78621 Apr 2006 @ 07:48 PDTViswanathanConnectivityTopicissue with Teradata ODBC 03.05 in AIX5.2HiI 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 ...
78520 Apr 2006 @ 09:34 PDTpwsegal@gmail.comAnalyticsReplyRandomied sampleWell 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...
78420 Apr 2006 @ 12:14 PDTyoungDatabaseReplyHow to get tablenamehelp database dbname;you can get all tablename within your dbname
78320 Apr 2006 @ 12:08 PDTyoungDatabaseTopicquestion about de-normalizationwhat is the relationship between physical de-normalization and join index?substitute or they two mean the same thing?need your help,
78220 Apr 2006 @ 11:50 PDTBBR2DatabaseReplyWrite/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...
78120 Apr 2006 @ 11:41 PDTCraig.SchweizerDatabaseReplyWrite/Read external file from within Stored Procedure?Thanks Stami!
78020 Apr 2006 @ 11:36 PDTstami27-2406DatabaseReplyWrite/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
77920 Apr 2006 @ 09:48 PDTstami27-2406DatabaseReplyWrite/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:---------------------------------------------------...
77820 Apr 2006 @ 08:49 PDTCraig.SchweizerDatabaseReplyWrite/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.
77720 Apr 2006 @ 08:25 PDTdharmaAnalyticsReplyRandomied sampleThanks 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...
77620 Apr 2006 @ 05:35 PDTpwsegal@gmail.comAnalyticsReplyidentity columnsA 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 ...
77520 Apr 2006 @ 05:21 PDTpwsegal@gmail.comAnalyticsReplyRandomied sampleFirst 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...
77420 Apr 2006 @ 12:28 PDTKksTrainingReplyLink to Teradata Basics Web-Based Training (WBT)and info.ncr.com will give you all the documentation
77319 Apr 2006 @ 06:50 PDTJim ChapmanDatabaseReplyWrite/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...
77219 Apr 2006 @ 11:21 PDTBBR2DatabaseReplyNumber of weeks in a given month and yearFeroz,Good catch.I should have checked for other months as well.Vinay
77119 Apr 2006 @ 11:02 PDTshaik.feroz@aaa-calif.comDatabaseReplyNumber of weeks in a given month and yearhello 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...
77019 Apr 2006 @ 10:46 PDTBBR2DatabaseReplyRandomied sampleI 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...
76919 Apr 2006 @ 10:29 PDTBBR2DatabaseReplyweird 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...
76819 Apr 2006 @ 10:25 PDTBBR2DatabaseReplyNumber of weeks in a given month and yearAbdul,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...

Pages