|652||21 Nov 2013 @ 12:35 PST||Database||Reply||Performance 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... |
|651||20 Nov 2013 @ 08:53 PST||Marketing & CRM||Reply||Business solution without Technology||I 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?
|650||20 Nov 2013 @ 08:50 PST||Database||Reply||Need help in understanding Teradata's behaviour||it 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... |
|649||20 Nov 2013 @ 06:44 PST||Database||Reply||CASE STATEMENT||Hi 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... |
|648||20 Nov 2013 @ 06:41 PST||Database||Reply||Need help in understanding Teradata's behaviour||you 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.
|647||20 Nov 2013 @ 02:35 PST||Database||Reply||fetching data by joining 2 tables in a view||how many rows has your table t2?
|646||20 Nov 2013 @ 12:44 PST||Marketing & CRM||Reply||Business solution without Technology||What do you expect with this kind of Twitter questions? Will yes or no answer help???
|645||19 Nov 2013 @ 12:43 PST||Database||Reply||fetching data by joining 2 tables in a view||But 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... |
|644||18 Nov 2013 @ 08:17 PST||Database||Reply||Performance 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... |
|643||18 Nov 2013 @ 08:11 PST||Database||Reply||Start from specific sql in Stored Procedure||check the manuals
if then else and
case construct to achive what you want.
|642||18 Nov 2013 @ 02:10 PST||Tools||Reply||Installing BTEQ / MLoad on Windows 7||Hi 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... |
|641||14 Nov 2013 @ 12:03 PST||Database||Reply||Problems with the CASE structure||Hi,
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... |
|640||13 Nov 2013 @ 08:43 PST||Database||Reply||fetching data by joining 2 tables in a view||it 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... |
|639||08 Nov 2013 @ 08:01 PST||Database||Reply||Problems with the CASE structure||Hm, 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... |
|638||08 Nov 2013 @ 06:53 PST||Database||Reply||Dynamic Table Names||what 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?
|637||08 Nov 2013 @ 06:32 PST||Database||Topic||Algorithm and sql ways for Sorting and matching data II||Hi,
I was not able to post to the orig post at
So here a try to overcome the techica... |
|636||08 Nov 2013 @ 04:19 PST||Database||Reply||Joining tables from two different servers||what do you want to achive this this join?
|635||27 Oct 2013 @ 11:10 PDT||Database||Reply||Need help with "TIMESTAMP WITH TIME ZONE"||A bit of ugly but it shoud use the 3-4 partitons only
WHERE TestCol1 between timestamp '2013-09-30 00:00:00' and timestamp '2013-10-02 23:59:59'
and ... |
|634||25 Oct 2013 @ 12:32 PDT||Tools||Reply||Multi 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... |
|633||21 Oct 2013 @ 04:34 PDT||Tools||Reply||Where 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.
|632||17 Oct 2013 @ 07:46 PDT||Database||Reply||Sub query vs OLAP approach||Hi 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... |
|631||16 Oct 2013 @ 03:46 PDT||Database||Reply||primary 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... |
|630||15 Oct 2013 @ 11:40 PDT||Database||Reply||primary 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.
|629||14 Oct 2013 @ 01:45 PDT||Database||Reply||Use of Analytical Functions in Join Index||from 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... |
|628||03 Oct 2013 @ 11:32 PDT||Database||Reply||what 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... |