#DateForumTypeThreadPost
1908 Aug 2014 @ 12:47 PDTDatabaseReplyBTEQ Import going to DELAYED stateThanks Dieter for confirming this.
1806 Aug 2014 @ 10:27 PDTDatabaseReplyBTEQ Import going to DELAYED stateThanks 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...
1706 Aug 2014 @ 12:39 PDTDatabaseTopicBTEQ Import going to DELAYED stateHI 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...
1623 Jan 2014 @ 06:07 PSTDatabaseTopicFastLoad for multiple input filesHi 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...
1522 Dec 2013 @ 05:01 PSTDatabaseReplyON and WHERE clause for JoinsThanks you guys, thanks for quick response.
1421 Dec 2013 @ 07:13 PSTDatabaseTopicON 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...
1314 Dec 2013 @ 09:52 PSTGeneralTopicTeradata Certification re-take policyHi, 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...
1230 Oct 2013 @ 04:10 PDTDatabaseReplyDATE Index in TeradataHi 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...
1124 Oct 2013 @ 08:20 PDTDatabaseReplywhich fields is populated which is empty in a tableHello 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 ...
1020 Oct 2013 @ 09:32 PDTDatabaseReplyFASTLOAD LOCK - Table being loaded - Data inaccessibleHi 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...
916 Oct 2013 @ 08:02 PDTDatabaseReplySub query vs OLAP approachThanks 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...
816 Oct 2013 @ 04:42 PDTDatabaseTopicSub 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...
713 Oct 2013 @ 11:06 PDTDatabaseReplyPermanent JournalHi, 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...
613 Oct 2013 @ 10:17 PDTDatabaseReplyfast path insert selectHi, 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...
508 Oct 2013 @ 10:42 PDTDatabaseReplyCasting 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.
403 Oct 2013 @ 09:33 PDTDatabaseReplyTERADATA Architecture - parallelism?Vlad and Raja, thanks for your input.
329 Sep 2013 @ 12:45 PDTDatabaseTopicTERADATA 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...
221 Sep 2013 @ 10:31 PDTGeneralReplyROW_NUMBER() OVER (PARTITION BY col1,col2.... order by col1)why dont you cast it to decimal if the column exceeds the integer limit.
115 Sep 2013 @ 05:39 PDTGeneralReplyinterview helpPlease send me as well. My id is : madhukar.gaurav@gmail.com