19 | 08 Aug 2014 @ 12:47 PDT | Database | Reply | BTEQ Import going to DELAYED state | Thanks Dieter for confirming this.
|
18 | 06 Aug 2014 @ 10:27 PDT | Database | Reply | BTEQ Import going to DELAYED state | Thanks you all for your responses. I understand that the problem here is because of the TASM throttle rule.
About using the PACK option, i have tried this but it did not make a difference. I THINK... |
17 | 06 Aug 2014 @ 12:39 PDT | Database | Topic | BTEQ Import going to DELAYED state | HI All,
I am doing a BTEQ Import from a file having 400 records. Once the job starts, I checked in the Viewpoint and the Request is showing in DELAYED state. After waiting for nearly 10 mi... |
16 | 23 Jan 2014 @ 06:07 PST | Database | Topic | FastLoad for multiple input files | Hi All, I was trying to load multiple files using Fastload.
I was able to load the files using multiple Fastload scripts (First Script, do not give the END LOADING. Last script, give END LOAD... |
15 | 22 Dec 2013 @ 05:01 PST | Database | Reply | ON and WHERE clause for Joins | Thanks you guys, thanks for quick response.
|
14 | 21 Dec 2013 @ 07:13 PST | Database | Topic | ON and WHERE clause for Joins |
Hi, I have a doubt when coding ON and WHERE clause for Joins (Inner Vs Outer).
I think, for an Inner Join its does not make a difference whether we apply the condition with ON clu... |
13 | 14 Dec 2013 @ 09:52 PST | General | Topic | Teradata Certification re-take policy | Hi, Can you somebody please provide me details about the Teradata certification re-take policy.
If someone couldn't clear an exam in first attempt, the website says he/she can re-take the exam... |
12 | 30 Oct 2013 @ 04:10 PDT | Database | Reply | DATE Index in Teradata | Hi Mithun,
Can you please provide more details about DATE index, do you need secondary index on DATE column ? In that case you can create it as below-
CREATE MULTISET VOLATILE TABLE temp_table... |
11 | 24 Oct 2013 @ 08:20 PDT | Database | Reply | which fields is populated which is empty in a table | Hello Vince,
I think you can use Count(columnname) for this purpose-
create multiset volatile table emp1 (id smallint, name char(2), sal decimal(8,0)) on commit preserve rows;
insert into ... |
10 | 20 Oct 2013 @ 09:32 PDT | Database | Reply | FASTLOAD LOCK - Table being loaded - Data inaccessible | Hi Chanukya,
In case of Fastload, release lock sql wont work. What you can try is- submit the failed job again, without making any changes to the script and associated tables, but this time do not... |
9 | 16 Oct 2013 @ 08:02 PDT | Database | Reply | Sub query vs OLAP approach | Thanks Khurram, yeah i understand that OLAP will get max for each partition and to get the same in subquery i need to modify it(make it correlated). I can say-
sel * from loc3 a1 where col2 = (sel... |
8 | 16 Oct 2013 @ 04:42 PDT | Database | Topic | Sub query vs OLAP approach |
Hi,
Please see below example-
TABLE: loc3 (col1 int, col2 int, col3 int) with below data-
000015, 0000000058789756, 198520
000015, 00... |
7 | 13 Oct 2013 @ 11:06 PDT | Database | Reply | Permanent Journal | Hi, in case of dual image, 2 copies of the row which is undergoing a change will be stored. while for single image, only one copy is stored in PJ.
If a table have both BEFORE AND AFTER Journal, it... |
6 | 13 Oct 2013 @ 10:17 PDT | Database | Reply | fast path insert select | Hi, I think you should go with the second option as it is going to make use of Fast Path Insert/Select.
There is already a discussion on this - http://forums.teradata.com/forum/enterprise/fas... |
5 | 08 Oct 2013 @ 10:42 PDT | Database | Reply | Casting to An integer giving incorrect result. | Not just remove one of the zeros, even if you add one or more zeros, it works fine. Not sure whats the exact reason here but its better to go with decimal approach as Khurram suggested.
|
4 | 03 Oct 2013 @ 09:33 PDT | Database | Reply | TERADATA Architecture - parallelism? | Vlad and Raja, thanks for your input.
|
3 | 29 Sep 2013 @ 12:45 PDT | Database | Topic | TERADATA Architecture - parallelism? | Hi All,
Can you please tell me what is the component in TERADATA Architecture which is responsible for parallelism?
I mean if this component is removed, the system will no longer be parallel.
&n... |
2 | 21 Sep 2013 @ 10:31 PDT | General | Reply | ROW_NUMBER() OVER (PARTITION BY col1,col2.... order by col1) | why dont you cast it to decimal if the column exceeds the integer limit.
|
1 | 15 Sep 2013 @ 05:39 PDT | General | Reply | interview help | Please send me as well.
My id is : madhukar.gaurav@gmail.com
|