#DateForumTypeThreadPost
16905 Nov 2013 @ 09:42 PSTDatabaseReplyHow Compression WorksHi, When you define compression on some columns in TD, Teradata stores the compressed values in the table header. So if you are compressing a large number of columns, the header size will become l...
16805 Nov 2013 @ 05:51 PSTDatabaseReply3976: Incorrect referential constraint definitionHi, Can you please share the parent table definition as well. As the error might be due to the definition of QuarterPeriodNum column.  This column must be defined as UNIQUE and NOT NULL...
16705 Nov 2013 @ 05:09 PSTDatabaseReplyNull values in unique index not equal in merge statementHi,  for WHEN MATCHED condition the second row in the table is matched and will be updated without any issue. the first row will go to WHEN NOT MATCHED part, so it will try to insert values ...
16605 Nov 2013 @ 12:16 PSTToolsReplySecondary indexHi, You can use the secondary indexes in the following situations: To improve access of frequently accessed columns which can not be defined as PI. To enforce uniqueness using USI &n...
16504 Nov 2013 @ 03:57 PSTData ModelingReplyPPI table having a column for same PI and SI Hi, If the column is PI, then what do you need SI? 
16403 Nov 2013 @ 12:46 PDTToolsReplyBTEQ login errorHi, You need to make an entry of the server IP address in the windows host file.  
16301 Nov 2013 @ 09:31 PDTDatabaseReplyHow to simplify query that runs out of spool space?Place the following before your query: DIAGNOSTIC HELPSTATS ON FOR SESSION; --Please your query here. Now press F6, at the end of explain plan, you will get the required stats to be collected....
16201 Nov 2013 @ 09:27 PDTDatabaseReplyHow to simplify query that runs out of spool space?Have you collected the required stats?
16101 Nov 2013 @ 08:50 PDTDatabaseReplyHow to simplify query that runs out of spool space?These joins are quite simpler for Teradata. The things you can modify about these join is to make sure that the data types of joining columns are are same. Collecting statistcis will most probably ...
16001 Nov 2013 @ 05:35 PDTGeneralReplyBackground tasksHi raja, Some of these tasks are Deadlock detection, Cylinder defragmentation, transient journal purging, periodic cache flushes, these process usualluy during idle time.  
15930 Oct 2013 @ 11:32 PDTDatabaseReplyhow to get maxmum/minimum number between multiple columns in a rowI think you can transpose the columns into rows and then use simply MIN and MAX Window functions.  
15830 Oct 2013 @ 03:31 PDTDatabaseReplyfetching data by joining 2 tables in a viewHi Arun, Can you please paste some sample data, 2-3 rows from each table? I have little confusion about the line " the values of field A and D of T1 is present in the column E of T2 in ...
15729 Oct 2013 @ 10:41 PDTDatabaseReplyUPDATE Teradata Field with NULL valueoops, I thaught you are executing it from some sp. but still your value is explicit character 'NULL' which can not be converted to date, as date is stored as numeric.  Try this: ST...
15629 Oct 2013 @ 10:15 PDTDatabaseReplyUPDATE Teradata Field with NULL valueHi, I am not sure & is a concatenation operator in Teradata, I have read only | and !, secondly your string will result in 'NULL' which will be of character data type and cant be store...
15528 Oct 2013 @ 04:41 PDTDatabaseReplyProblem with CASE WHEN statementHi, When you got a syntax error, you do not have to reas blogs, instead read you code :-) You have misplaced the parenthesis at the following part: Source Code removed based on formal request fr...
15428 Oct 2013 @ 12:44 PDTDatabaseReplyFiltering records that have overlapping datesHi, Why dont you use overlap function for Dates?  
15326 Oct 2013 @ 04:46 PDTDatabaseReplyTranspose rows to columnsHi Diether, Can you please suggest some good place where I can learn Teradata functions, UDFs. I am unable to find a source or list of all these functions. Thanks,  
15225 Oct 2013 @ 11:53 PDTDatabaseReplyNo More Spool Spacehi, Is this simple select * you are using or there are some joins in the select statement?  The second thing is select insert is most optimal when both the source and target table have the s...
15125 Oct 2013 @ 11:06 PDTDatabaseReplyCreate Table Failed [3076] Problem between the ")" and the AS.Posting text removed based on formal request from Owner of the associated Intelectual Property.
15025 Oct 2013 @ 10:49 PDTDatabaseReplyCreate Table Failed [3076] Problem between the ")" and the AS.You are using the subqury to make a field, but it is returning mutiple rows that is not allowed. You must either restrict the subquery to return a single row, OR you can move this subquery to a der...
14925 Oct 2013 @ 09:53 PDTDatabaseReplyCreate Table Failed [3076] Problem between the ")" and the AS.Ok, This error means that your subquery is reutrning more than one row, while you are using it in condition that expects single value. So you have to either rewrite the subquery, or change the appr...
14825 Oct 2013 @ 09:36 PDTDatabaseReplyHow to make substring with the second or third occurrence of a charaterYou can use INSTR function to find the nth occurence of a character. The syntax is as follows: INSTR(string, substring [,position [, occurrence]]) You can either specify position or occurence...
14725 Oct 2013 @ 09:18 PDTDatabaseReplywhich fields is populated which is empty in a tableHi Vince, Can you please share your solution for others help :-) Thanks,  
14625 Oct 2013 @ 09:17 PDTDatabaseReplyTransaction ABORTed due to Teradata table deadlock in InformaticaHi, When you run multiple sessions that insert into the same table, One of the sessions will lock table for write and others will have to wait.  I think you either can load this table using ...
14525 Oct 2013 @ 09:13 PDTDatabaseReplyCreate Table Failed [3076] Problem between the ")" and the AS.I think there are some no matching parenthesis, try this:   Posting text removed based on formal request from Owner of the associated Intelectual Property.

Pages