#DateForumTypeThreadPost
37120 Dec 2013 @ 07:06 PSTDatabaseReplyFastLoad Date Foramt for Long Unix DateHi, There is a chain of communication about date conversion in fastload. http://forums.teradata.com/forum/tools/fastload-datetime-timestamp   TD has many date format conversion like TIMEST...
37020 Dec 2013 @ 06:26 PSTDatabaseReplyNeed alternative to DBQL processingYou are welcome. This is for temporary solution.You may need to think of long term solutions. Good luck, Raja
36920 Dec 2013 @ 04:14 PSTDatabaseReplyFinding the table size alone? I check it this way: ct raja_test(id varchar(1)) unique primary index id1(id) say. I dont insert any value(zero rows), then I check :   SELECT CurrentPerm FROM DBC.Tablesize...
36820 Dec 2013 @ 02:53 PSTDatabaseReplyTeradata architechtural behaviourHi, Yes, you can think it that way when we have skewness, with respect to data volume, uneven distribution  due to bad choice of PI, bad joins etc.But Teradata system is built for parallel...
36720 Dec 2013 @ 01:00 PSTAnalyticsReplyFast Load Vs MultiloadCheck and verify your data source. Also check and verify : SELECT  * FROM errortname1 and SELECT * FROM errortname2. Cheers, Raja
36619 Dec 2013 @ 11:30 PSTAnalyticsReplyFASTEXPHi Sankalp, Yes in  your first .begin export ----you can put your .end export but don't log off. You can start your next begin export (in the same script) and end export and then lo...
36519 Dec 2013 @ 08:48 PSTConnectivityReplyConnecting to Teradata.netThanks Dieter.
36419 Dec 2013 @ 08:42 PSTDatabaseReplyNeed alternative to DBQL processingHi Ss, For now, I am just thinking that maybe you can break up into smaller chunk, porting to other tables only what you want or maybe partition. After that you can play anyway you like. Cheers, ...
36319 Dec 2013 @ 08:36 PSTDatabaseReplyFastLoad lock TypeHi Dipanjan, I am not Dieter, but let me  give some directions: In the fastload manual: To restart the job if the Teradata FastLoad job was paused during the end loading phase 1 Use ...
36219 Dec 2013 @ 08:07 PSTConnectivityReplyConnecting to Teradata.netHi Dieter, Thanks for the info. I tried to change from Teradata.net to odbc, it does not work. This is the first time I am working with this setup Teradata.net. I dont have any idea about it...
36119 Dec 2013 @ 07:45 PSTGeneralReplyHow to configure Dial up Server on SWS Server in Teradata6650CHi Setsuo, I feel you need to check the Modem device vendor as well as the SuSE Linux 10.0 manuals or their support. This is what we did before and it took a long time to resolve at that time ,...
36019 Dec 2013 @ 07:33 PSTConnectivityReplyConnecting to Teradata.netHi Dieter, The query : CREATE SET TABLE ABC, QUEUE ( cart_qits TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6), comp_id INTEGER, amt INTEGER, city varchar(10) ) PRIMARY ...
35919 Dec 2013 @ 07:23 PSTDatabaseReplytwo similar tables - very different import speed Even if you say "regular basis" before, maybe you can check the workload history then and compare with the present one. It is just a thought.   Cheers, Raja
35819 Dec 2013 @ 04:25 PSTDatabaseReplyRegarding TVS Vproc You are welcome :). Just to add to the above point, it adds flexibility to configuration. Cheers, Raja  
35719 Dec 2013 @ 04:09 PSTConnectivityReplyConnecting to Teradata.net Hi,   I am using Teradata.Net connection in my SQL assistant. I am trying to create QUEUE table but it gives me an error " CREATE TABLE Failed. [3706] Syntax error: Expected GL...
35619 Dec 2013 @ 01:41 PSTMarketing & CRMReplyAnyone have any material about ARTIM? Hi, Are you talking about Aprimo Real Time Interaction manager? I got this link: http://www.aprimo.com/Products_.aspx?id=2266. However, much of the information you can get for Aprimo from Ter...
35519 Dec 2013 @ 01:23 PSTTrainingReplyTerdata Certification in IndiaYou are welcome. If you are in Bangalore, there are few good places in Koramangla as you can see. I heard that you need to book it in advance. Call them first. Cheers, Raja
35418 Dec 2013 @ 11:59 PSTAnalyticsReplyFast Load Vs MultiloadHi Ratnam, We use mload and fload for reasons.   I hope this is for testing only :).Teradata is primarily for huge volume of data.     Mload:   L...
35318 Dec 2013 @ 11:01 PSTTrainingReplyTerdata Certification in IndiaHi, Can you land in this page? http://www.register.prometric.com/Index.asp?tcl=1 Cheers, Raja
35218 Dec 2013 @ 09:41 PSTDatabaseReplyQuestion on Stored procedureHi, Did you check dbc.allrights table? SELECT UserName FROM dbc.AllRights  WHERE DatabaseName ='yourdb...' AND TableName ='....'  AND AccessRight = '.....
35118 Dec 2013 @ 08:23 PSTDatabaseReplyIndex Cocepts in TeradataHi, Which one : Inner join, outer join(left, right,full), cross join or product join or are you talking about these JIs? Join indexes(Single table join index,multitables join index,agg...
35018 Dec 2013 @ 08:01 PSTDatabaseReplyJoining tables on fields with varying lengthsI was about to commend on the modeling side. At least , this should have been caught in pdm or even in design phase. Cheers, Raja
34918 Dec 2013 @ 08:44 PSTDatabaseReplySpool space issue I am not able to understand your question properly. Do you mean to ask the order , in which a query has so many joins?   Cheers, Raja
34818 Dec 2013 @ 08:05 PSTDatabaseReplyRegarding TVS Vproc     Manages Teradata Database storage. AMPs acquire their portions of database storage through the TVS vproc.   The amp's link to physical disks is interposed ...
34718 Dec 2013 @ 07:54 PSTDatabaseReplyBteq script - error handling not working, need helpYou are welcome. Always try to put logs for ease of tracking. Cheers, Raja

Pages