#DateForumTypeThreadPost
65221 Nov 2013 @ 12:35 PSTDatabaseReplyPerformance tuning of a Fast Load Script-correct - at least if the AVG varchar length is < char length -2. As varchar will add up to additional 2 bytes for the actual length of the varchar (e.g. it need to know how long the value is to...
65120 Nov 2013 @ 08:53 PSTMarketing & CRMReplyBusiness solution without TechnologyI don't get it - in this case you can answer you question yourself. But what will be the value of the question of this generic question and an yes to others?
65020 Nov 2013 @ 08:50 PSTDatabaseReplyNeed help in understanding Teradata's behaviourit is very difficult to answer you these questions on your pseudo code - the first query is syntax whise incorrect as columns names are missing. Not a big deal but it means it is manual pseudo code...
64920 Nov 2013 @ 06:44 PSTDatabaseReplyCASE STATEMENTHi MBR, what do you exptect others to do? You don't share DDL and data (as inserts!!!). So how could you expect that syntactially correct code is posted?  And even now you don't sha...
64820 Nov 2013 @ 06:41 PSTDatabaseReplyNeed help in understanding Teradata's behaviouryou don't have at some point an where on B.x = something? This would convert the outer to an inner join and would filter out rows.
64720 Nov 2013 @ 02:35 PSTDatabaseReplyfetching data by joining 2 tables in a viewhow many rows has your table t2?  
64620 Nov 2013 @ 12:44 PSTMarketing & CRMReplyBusiness solution without TechnologyWhat do you expect with this kind of Twitter questions? Will yes or no answer help???
64519 Nov 2013 @ 12:43 PSTDatabaseReplyfetching data by joining 2 tables in a viewBut this might be done more efficiently with an aggregation T2 before joining to T1. But again if you can not share some example DDLs and example data  (please as insert statements) it will b...
64418 Nov 2013 @ 08:17 PSTDatabaseReplyPerformance tuning of a Fast Load Script-it will depend on your source data.  In some cases network bandwidth is an issue. If you have a wide interface and it is defined with fixed and it contains many variable length char target co...
64318 Nov 2013 @ 08:11 PSTDatabaseReplyStart from specific sql in Stored Procedurecheck the manuals  you have if then else and case construct to achive what you want. Ulrich
64218 Nov 2013 @ 02:10 PSTToolsReplyInstalling BTEQ / MLoad on Windows 7Hi Peter, the TTU is downwards compatible usually - Not 100% sure if 14.10 would still work with R5 systems. But it will work with 13.10. But all components need to be on the same level. So MLOAD...
64114 Nov 2013 @ 12:03 PSTDatabaseReplyProblems with the CASE structureHi, T1 = TRIM(TRAILING FROM Str1) type(TRIM(TRAILING FROM Str1) ) states that this is a varchar(10) - so you put in a char(10) and convert it to a varchar(10). -> LT1 = CHARACT...
64013 Nov 2013 @ 08:43 PSTDatabaseReplyfetching data by joining 2 tables in a viewit sounds you have some kind of combinatoric problem. Can you explain why the data is stored in this way and what you achieve with these joins? For a chance to understand your problem you would...
63908 Nov 2013 @ 08:01 PSTDatabaseReplyProblems with the CASE structureHm, not 100% sure but row one is stored as '          ' in the char field and '' in the varchar field to my understanding. Given your code the case result...
63808 Nov 2013 @ 06:53 PSTDatabaseReplyDynamic Table Nameswhat is the reason for creating one table per month? Can't you have one table and partition it by a date colume with RANGE_N each month?
63708 Nov 2013 @ 06:32 PSTDatabaseTopicAlgorithm and sql ways for Sorting and matching data IIHi, I was not able to post to the orig post at http://forums.teradata.com/forum/database/algorithm-and-sql-ways-for-sorting-and-matching-data#comment-118553 So here a try to overcome the techica...
63608 Nov 2013 @ 04:19 PSTDatabaseReplyJoining tables from two different serverswhat do you want to achive this this join?
63527 Oct 2013 @ 11:10 PDTDatabaseReplyNeed help with "TIMESTAMP WITH TIME ZONE"A bit of ugly but it shoud use the 3-4 partitons only SELECT * FROM Test_Table1 WHERE TestCol1 between timestamp '2013-09-30 00:00:00' and timestamp '2013-10-02 23:59:59' and ...
63425 Oct 2013 @ 12:32 PDTToolsReplyMulti load through java application.read the terms for Teradata Express - it's a development license and is not allowed for production. also read the inital comment from tomnolan JDBC fastload into empty table and merge can do w...
63321 Oct 2013 @ 04:34 PDTToolsReplyWhere can I find BTEQ?no, so far bteq and the other utilities are not supported on Mac OS. Only TD Studio is available for Mac OS.
63217 Oct 2013 @ 07:46 PDTDatabaseReplySub query vs OLAP approachHi Khurram, what do you mean with row at a time for the corelated subquery. The correlated subquery example below seems to be set based operations to me - not so effcient as the OLAP query in thi...
63116 Oct 2013 @ 03:46 PDTDatabaseReplyprimary index in IN clause or exists clause >?the datatype need to match and both columns need to be PI on the table.  And again - check the explain. Is one of the tables redistributed? In case yes, no PI join. You could also rewirte yo...
63015 Oct 2013 @ 11:40 PDTDatabaseReplyprimary index in IN clause or exists clause >?it will depend if id is the pi of table_b and id has the same data type as emp_id. you can veryfy be your own by reading the explain. 
62914 Oct 2013 @ 01:45 PDTDatabaseReplyUse of Analytical Functions in Join Indexfrom the manuals:   Aggregate Join Indexes An aggregate join index is a join index that specifies SUM or COUNT aggregate operations. No other aggregate functions are permitted in the defini...
62803 Oct 2013 @ 11:32 PDTDatabaseReplywhat happens when you drop a table that is used in a running insert query?what makes you sure that the table is droped while the insert/select is still running? Did you checked the DBQL records for the two statements? Do you still see the insert/select session in viewpoi...

Pages