17 | 19 Oct 2012 @ 03:38 PDT | Database | Reply | Please tune this quey as it is taking terabytes spool space | Check in the step table (dbqlsteptbl) which step is creating huge spool file. There might be skew or some duplication might be happening.
|
16 | 11 Oct 2012 @ 03:42 PDT | Database | Reply | What is index join confidence | Even I am trying to understand what the meaning of the term "index join confidence".
It will be great if any of the Teradata Gurus can explain if this is good confidence level.
|
15 | 11 Oct 2012 @ 12:36 PDT | Database | Reply | RE: Stats collection and Performance | Thanks for the information!
|
14 | 09 Oct 2012 @ 03:54 PDT | Database | Reply | RE: Stats collection and Performance | In any scenario does collecting stats on the columns that are not required will degrade the performance of query. I understand that collecting stats itself is expensive as it will do FTS, but in an... |
13 | 09 Oct 2012 @ 03:52 PDT | Database | Reply | SQL to find Row Count | Dieter,
I have been doing the same way you mentioned. We are using Informatica for data movement within teradata using pushdown optimization. There can be multiple insert/merge/update statem... |
12 | 09 Oct 2012 @ 03:19 PDT | Database | Reply | Primary Index on VARCHAR column | Will there be any performance degradation when we join CHAR to a VARCHAR column?
|
11 | 04 Oct 2012 @ 01:53 PDT | Database | Topic | SQL to find Row Count | Hi,
I am trying to find if there is any way we can find the record count of queries that logged into DBQL with Insert or Update statement types. I tring to see the row count by taking the ... |
10 | 06 Sep 2012 @ 06:26 PDT | Database | Topic | RE: Stats collection and Performance |
Hi,
I am having two questions related to collect stats.
1) I using Diagnostic HelpStats On For Session to know the recommended stats. Even after collecting the stats on that column, it... |
9 | 17 Apr 2012 @ 12:51 PDT | Tools | Topic | Copy tables between two different systems |
Hi,
We are planning to copy some tables from an active teradata database to another teradata database. We are planning to use datamover. But in addition to it we also wanted to tr... |
8 | 20 Oct 2011 @ 04:37 PDT | Tools | Reply | Loading a table with BTEQ script using csv file having numeric field with thousand seperator. |
Jimm - Thanks for the clarification.
|
7 | 20 Oct 2011 @ 11:05 PDT | Tools | Reply | Last character of the file is not laoding into a table while using bteq script |
Thanks Suzzanne
|
6 | 20 Oct 2011 @ 10:48 PDT | Tools | Reply | Loading a table with BTEQ script using csv file having numeric field with thousand seperator. |
Jimm, thank you for your reply.
I understand that we can solve this issue by saving the file in different format. But I am just curious to know if it is possible in the BTEQ script (using ... |
5 | 19 Oct 2011 @ 09:43 PDT | Tools | Reply | Loading a table with BTEQ script using csv file having numeric field with thousand seperator. |
How to load data which is in csv file format into a table using a BTEQ script; Data file has a numeric field with values having thousand seperator?
|
4 | 19 Oct 2011 @ 04:57 PDT | Tools | Reply | Last character of the file is not laoding into a table while using bteq script |
I tried loading the table omitting SUBSTR function, but still I have the issue. If I just hit a enter at the end of last record and save the file, its loading the complete value.
And also, I... |
3 | 19 Oct 2011 @ 02:34 PDT | Tools | Reply | Last character of the file is not laoding into a table while using bteq script |
I am using Version is 13.10.01.08.
Bteq Script:
DATABASE ABC;
.IF ERRORCODE <> 0 THEN .GOTO LABEL_ERROR ;
.IMPORT VARTEXT ',' FILE=/xfer/BMD/extracts/For... |
2 | 19 Oct 2011 @ 02:07 PDT | Tools | Topic | Loading a table with BTEQ script using csv file having numeric field with thousand seperator. |
I am using a csv file (Saving a excel file in csv format) to load a table. I have numeric field with thousand seperator. When I am opening the csv file, the numeric field is showing up... |
1 | 19 Oct 2011 @ 11:30 PDT | Tools | Topic | Last character of the file is not laoding into a table while using bteq script |
Hi,
I am using a BTEQ script to load a table. While loading, last character of the text file is missing. For example, in the text file, last column value of a last row is "Deadline 3&qu... |