#DateForumTypeThreadPost
3803 Jan 2016 @ 08:03 PSTDatabaseTopicUser defined exceptionHi All, Can anyone explain how to handle user defined exception in Teradata with an example? Like if output from a select statement equal to a predefined value (1 or 10) it will throw an error?
3709 Nov 2015 @ 10:11 PSTDatabaseReplyMinus Vs ExistsThanks Ulrich for your reply. Those two tables are multi set but will not have duplicate rows. We are currenlt using hashrow function for CDC but in past eperienced hash collision.
3606 Nov 2015 @ 02:01 PSTDatabaseTopicMinus Vs ExistsHi, I have two large multiset tables and I need to check if they are identical. In that case which one will give better performance: MINUS or NOT EXISTS?
3506 Nov 2015 @ 12:18 PSTDatabaseTopicUser defined exception from procedureHi, I have a stored procedure which is checking counts from four tables. I need to raise exception if the counts are not matich with a predefined value. Can anyone help me on how to achieve this? ...
3428 Jun 2015 @ 09:04 PDTDatabaseReplyTable AliasingThanks Dieter. I just got one info that using table aliasing in multi table join can decrease the spool space occupied and hence improving performace. But was not sure sure about this statement. Is...
3325 Jun 2015 @ 10:37 PDTDatabaseTopicData LabHi, Can anybody give me some info about Teradata DataLab? How it works and how it is different from regular database?
3225 Jun 2015 @ 10:34 PDTDatabaseTopicTable AliasingHi, What is the benefits of using Table aliasing? Can it improve performance?   Thanks, Moutusi
3108 May 2015 @ 03:58 PDTDatabaseTopicReplacing symbols from input column Hi, From source I am getting values like '5 T', 'RT', 'S.*09', 'XV-4' etc. My requirement is to remove any space, '*', '-...
3013 Apr 2015 @ 10:00 PDTDatabaseReplyChange based threshold option for collect statsHi All, Any help on this?
2908 Apr 2015 @ 04:20 PDTDatabaseTopicChange based threshold option for collect statsHi, I need to delete and reload a large table every day. Though there may not be huge change on the data. If I use below statement will it work? My understancding is collecting unnecessary stats c...
2802 Apr 2015 @ 02:33 PDTDatabaseReplygenerate unique values for set of input fieldsThanks Dieter. How to use SHA256/512?
2702 Apr 2015 @ 10:00 PDTDatabaseReplygenerate unique values for set of input fieldsHi Dieter, I have a table T1 which have columns col1, col2, col3. I have to populate another table T2 that will have col4 the value of which should depend on the value of col1, col2, col3 in T1. B...
2601 Apr 2015 @ 06:45 PDTDatabaseTopicgenerate unique values for set of input fieldsHi, I need to generate unique values for set of input fields. For example if i have col1, col2, col3 in a table I need to populate unique value in col4 in another table whenever any of these ...
2501 Apr 2015 @ 06:37 PDTDatabaseReplyPerformance with pertitioned tableHi Samir, I can't change the datatype of STRT_DT as it is being used with timestamp values for other queries.
2426 Mar 2015 @ 10:50 PDTDatabaseReplyExecuting a multi-statement request from Informatica presql/postsqlHi all, Any info on this?
2326 Mar 2015 @ 10:49 PDTDatabaseReplyPerformance with pertitioned tableHi Ravimans, My question was whether using partition in such scenario will increase the performance or not.
2225 Mar 2015 @ 04:55 PDTDatabaseReplyPerformance with pertitioned tableThanks Dieter for your response.   No I have join condition like below: T1.STRT_DT>= CAST(T2.STRT_YR AS TIMESTAMP(0))) T2 has structure like: STRT_YR VARCHAR(100) and T2.STRT_YR value...
2125 Mar 2015 @ 12:18 PDTDatabaseTopicPerformance with pertitioned tableHi, I have a table having below structure: CREATE MULTISET GLOBAL TEMPORARY TABLE T1 ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT, DEFAULT MERGEBLOCKRATIO ( ID DEC...
2018 Mar 2015 @ 03:43 PDTDatabaseReplyHow SYSDATE will work if load is going more than one dayHi All any info on this?
1918 Mar 2015 @ 03:43 PDTDatabaseTopicExecuting a multi-statement request from Informatica presql/postsqlHi, As in Teradata bteq if we place the semicolon before the next statement like below it will be considered as multi-statement consisting of two statements.   select * from T1 ;select * ...
1807 Mar 2015 @ 03:18 PSTDatabaseReplySummary StatisticsIf I 1st time I collect stats on required columns and after that wheneer table gets refreshed I do summery stats onl will it refresh the column level stats also which I have collecte in 1st pace?
1724 Feb 2015 @ 03:56 PSTDatabaseTopicHow SYSDATE will work if load is going more than one dayHi, My code will insert system date to a target table with some other columns from source tables. If that code execution takes more than one day, or if the execution time crosses midnight, will I ...
1624 Dec 2014 @ 02:11 PSTDatabaseReplyDefining two derived tables using WITH clause ?? Hi Dieter, I need to define two derived tables using WITH clause but one will be recursive. Like below: WITH RECURSIVE TEMP_TAB(a,b,c) AS(Select a,b,c from T1 union select a,b, c+1 from TEM...
1505 Nov 2014 @ 12:49 PSTDatabaseTopicSummary StatisticsHi, What are differences between summary statistics and satistics? When we should opt for summary statistics instead of statistics?
1427 Sep 2014 @ 05:08 PDTDatabaseTopicMerge with error table Hi, Recently I came to know below feature of Merge. LOGGING ALL ERRORS WITH NO LIMIT But I found after the error table created the show Select * of error table is not referring the base tabl...

Pages