169 | 05 Nov 2013 @ 09:42 PST | Database | Reply | How Compression Works | Hi,
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... |
168 | 05 Nov 2013 @ 05:51 PST | Database | Reply | 3976: Incorrect referential constraint definition | Hi,
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... |
167 | 05 Nov 2013 @ 05:09 PST | Database | Reply | Null values in unique index not equal in merge statement | Hi,
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 ... |
166 | 05 Nov 2013 @ 12:16 PST | Tools | Reply | Secondary index | Hi,
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... |
165 | 04 Nov 2013 @ 03:57 PST | Data Modeling | Reply | PPI table having a column for same PI and SI | Hi,
If the column is PI, then what do you need SI?
|
164 | 03 Nov 2013 @ 12:46 PDT | Tools | Reply | BTEQ login error | Hi,
You need to make an entry of the server IP address in the windows host file.
|
163 | 01 Nov 2013 @ 09:31 PDT | Database | Reply | How 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.... |
162 | 01 Nov 2013 @ 09:27 PDT | Database | Reply | How to simplify query that runs out of spool space? | Have you collected the required stats?
|
161 | 01 Nov 2013 @ 08:50 PDT | Database | Reply | How 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 ... |
160 | 01 Nov 2013 @ 05:35 PDT | General | Reply | Background tasks | Hi raja,
Some of these tasks are Deadlock detection, Cylinder defragmentation, transient journal purging, periodic cache flushes, these process usualluy during idle time.
|
159 | 30 Oct 2013 @ 11:32 PDT | Database | Reply | how to get maxmum/minimum number between multiple columns in a row | I think you can transpose the columns into rows and then use simply MIN and MAX Window functions.
|
158 | 30 Oct 2013 @ 03:31 PDT | Database | Reply | fetching data by joining 2 tables in a view | Hi 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 ... |
157 | 29 Oct 2013 @ 10:41 PDT | Database | Reply | UPDATE Teradata Field with NULL value | oops, 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... |
156 | 29 Oct 2013 @ 10:15 PDT | Database | Reply | UPDATE Teradata Field with NULL value | Hi,
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... |
155 | 28 Oct 2013 @ 04:41 PDT | Database | Reply | Problem with CASE WHEN statement | Hi,
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... |
154 | 28 Oct 2013 @ 12:44 PDT | Database | Reply | Filtering records that have overlapping dates | Hi,
Why dont you use overlap function for Dates?
|
153 | 26 Oct 2013 @ 04:46 PDT | Database | Reply | Transpose rows to columns | Hi 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,
|
152 | 25 Oct 2013 @ 11:53 PDT | Database | Reply | No More Spool Space | hi,
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... |
151 | 25 Oct 2013 @ 11:06 PDT | Database | Reply | Create Table Failed [3076] Problem between the ")" and the AS. | Posting text removed based on formal request from Owner of the associated Intelectual Property.
|
150 | 25 Oct 2013 @ 10:49 PDT | Database | Reply | Create 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... |
149 | 25 Oct 2013 @ 09:53 PDT | Database | Reply | Create 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... |
148 | 25 Oct 2013 @ 09:36 PDT | Database | Reply | How to make substring with the second or third occurrence of a charater | You 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... |
147 | 25 Oct 2013 @ 09:18 PDT | Database | Reply | which fields is populated which is empty in a table | Hi Vince,
Can you please share your solution for others help :-)
Thanks,
|
146 | 25 Oct 2013 @ 09:17 PDT | Database | Reply | Transaction ABORTed due to Teradata table deadlock in Informatica | Hi,
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 ... |
145 | 25 Oct 2013 @ 09:13 PDT | Database | Reply | Create 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.
|