#DateForumTypeThreadPost
8813 Mar 2016 @ 05:56 PDTToolsReplyTPT script: error while executing TPT scriptTry listing both your tpt script and the output files at the prompt with complete path. Ex: ls /teradata/tpt/scriptname.extension ls /teradata/tpt/output/outfilename.extension   Ensure yo...
8713 Mar 2016 @ 05:51 PDTDatabaseReplyGeneric Mload script for UPSERTYou need to use the shell script capabilities (or windows batch program/powershell) to do this. So it would be become a fram work for your robust development. Below is an high level idea - 1) Rea...
8613 Mar 2016 @ 05:44 PDTToolsReplyReceive an error message while trying to use fast load. (dot) not manditory in fastload. But it is a good practice to keep the dot. I think you need to check two things. 1) ping the server from your command prompt and see if the server is up or not ...
8513 Mar 2016 @ 05:28 PDTDatabaseReplyHow to display mismatched columns from table differencesHi You can try giving the column conditions at the bottom to compare if both have same value or not.   sel a.* , b.* from table a, table b where a.col1<>b.col1 or a.col2 <> b.co...
8402 Jan 2016 @ 09:46 PSTTrainingReplyAny best Training Centres you guys know in Hyderabad??Sunil, for you my suggestion would be download the teradata VM ware versions and practice the SQLS along with OLAP and the utilities. If you don't have much time to do self exploration, better ...
8302 Jan 2016 @ 09:34 PSTTeradata ApplicationsReplyPerformance tuning questionMay try MLPPI with Source sys Id also on your huge target table. I mean Multi level partition source sys id along with transaction date. I guess you have limited sources and so you can use hash va...
8202 Jan 2016 @ 09:29 PSTTrainingReplyAny best Training Centres you guys know in Hyderabad??Better you know basics of  RDBMS,  SQL, Datawarehouse concepts and ETL concepts to understand teradata.  Unix or Mainframe basic underatnading  also important 
8102 Jan 2016 @ 08:49 PSTTrainingReplyNeed help to find out Teradata certification material I don't think dumps are available for TD 14. You can get train from Manohar. He quotes that the training would help up to 3 levels of certification. Can attend a demo and try the s...
8002 Jan 2016 @ 08:16 PSTTrainingReplyTeradata DBA Traninig in Hyderabad?I had good expeience with Manohar's  (sunmanu9@gmail.com) online training on Teradata development and DBA. (I 've done development 2 years agao and DBA recently) Yes i agree...
7902 Jan 2016 @ 08:07 PSTGeneralReplyPosting topics into the correct forumI guess you can use TPT . In TPT, temporarily load data from oracle to teradata and with in same script, compare the temp table and corresponding teradata table, export results into an output file&...
7802 Jan 2016 @ 08:00 PSTGeneralReplyNeed logic in teradata (SCD TYPE 2)Hope you already had the logic to find the delta (change capture process) by comparing two versions of data and derive the indicator either 'I' (For new inserts), 'U' (for updates),...
7730 Dec 2015 @ 09:58 PSTDatabaseReplySimple merging of records based on DateTry this - Select min(eno), name, min (strt_dt) , max(end_dt) from emptable group by 1,3,4;  -- for simple scenario of continuos dates are assured.   For other cases need to ...
7607 Oct 2015 @ 10:42 PDTDatabaseReplySpool Space Error while running a select queryHi Sangamesh, Hope you have the partition on your huge fact table and the partition condition exist in your query. Ensure the stats exist not only on primary but on the aggregated columns, and ot...
7511 Aug 2015 @ 07:27 PDTCloud ComputingReplyHow do I access a VMWare hosted Teradata Express from a local TD Mapping Manager You can use below link Lokesh - http://downloads.teradata.com/download/database/teradata-express/vmware          
7421 Nov 2014 @ 03:23 PSTDatabaseReplyConnecting Multiple Teradata ServersI think you can use TPT.  TPT only can conect both the servers simultaneously and stream data from source to target in parallel.  or need to use any ETL GUI tools like informatica or data...
7321 Nov 2014 @ 03:21 PSTDatabaseReplyhelp on tuning a queryI didn't try SI. as it is very huge table and loaded by multiload. Even i proposed compression on both the columns as distinct values are less but as it is a DDL change need to take a complete ...
7219 Nov 2014 @ 02:03 PSTDatabaseTopichelp on tuning a querySELECT col1,col2 FROM staging_table STG INNER JOIN target_table TGT ON STG.SRC_TRAN_ID=TGT.SRC_TRAN_ID WHERE TGT.ROW_STAT_CD='Active' AND TGT.SRC_SYS='sourcename' ...
7128 Sep 2014 @ 10:50 PDTTrainingReplyAny best Training Centres you guys know in Hyderabad??Hi Dieter, Exactly, I asked the same question to Manohar when i had connected with him for DBA training.  He said that his login was revoked by the admin some how (That's what he said). ...
7027 Sep 2014 @ 11:07 PDTDatabaseReplyself join of table based on PI is spooling outHi Dieter, Partition colum is part of PI in this scenario. I don't think i can share the DDL (company has secured network)   Thank you. Srilakshmi  
6926 Sep 2014 @ 11:11 PDTDatabaseTopicself join of table based on PI is spooling outHi, I've a join requirement between two huge tables which are partitioned on same column and having same PI (composit). I thought, it would be very much efficient, if i use partition col...
6826 Sep 2014 @ 11:00 PDTDatabaseReplyText File to load table A simple way of finding the utilities in our system would be - go to command prompt and type below commnds - Ex: C:\Bteq c:\mload c:\fastload c:\fexp   These command would give...
6727 Mar 2014 @ 07:59 PDTToolsReplyBTEQ Parallel Execution to speed up executing SQL statementsHi Krishna,  increasing the sessions would make the time lesser which is the objective.  And can you clarify if the sqls are not dependet and written in MSR fashion (semicolon befor...
6626 Mar 2014 @ 08:08 PDTToolsReplyBTEQ Parallel Execution to speed up executing SQL statementsYou can try as below set more sessions and as a multi statment request - .set sessions 8; SQL statement1 ;SQL statement2 ;SQL statement3 ;SQL statement4 ...etc ;SQL state...
6524 Mar 2014 @ 08:12 PDTToolsReplyTeradata tools in VMWare Teradata ExpressPlease try installing Teradata tools on your host machine (windows 7) through below link and configure the DSNs for SQL assistant and administrator,bteq...etc with IP number of Teradata 14 linux ho...
6424 Mar 2014 @ 08:10 PDTTrainingReplyImmediat TERADATA Online training available...,Interested people drop a mail @navench@gmail.comHi Ashok, With a basic understanding of RDBMS and SQL it is easy to learn Teradata. Similar discussions happend about the trainigs  in this and other threads also. please gothrugh below...

Pages