All forum activity

#DateUserForumTypeThreadPost
36723 Feb 2006 @ 09:19 PSTManoj_Kumar_ParmarToolsReplyBteq in Report formatHi, I cant give the actual field name and data, and I think the problem is not with data, but it is something in different format of report generating, because when I am generating the report with ...
36623 Feb 2006 @ 05:36 PSTXTUPIEDatabaseReplyinfluance record length on the performanceHi Just for your information, when looking at PERM and Spool space think of the following:Perm is like a the fuel in your cars tank when you reach it you job fails. Spool on the other hand is like ...
36523 Feb 2006 @ 05:30 PSTXTUPIEToolsReplyDate Format In Teradata SQL AssistantHi The above reply is correct, and you could also use the CAST function.select CAST((date1 (format 'yy/mm/dd')) as char(8)) from testuser.test3;
36423 Feb 2006 @ 05:18 PSTXTUPIETrainingReplyHow many Certified Teradata MastersHiI am not sure but I think it is around 800 worldwide. I know there are five TD Masters in South Africa, I am one of them and TD Master number 3 in South Africa.
36323 Feb 2006 @ 05:16 PSTXTUPIEDatabaseReplyBTEQ ConnectionHiYour BTEQ must start with.logon TDEMO/USERID,password;It think for the TeraData demo it is.logon TDmon/dbc,dbc;Also BTEQ will not work unless your etc host file does not contain the following ent...
36223 Feb 2006 @ 05:08 PSTXTUPIEToolsReplyBteq in Report formatHII suggest you set your export titles correctly for this to work. If you gave me more information, like table layout and sample data I could recreate it on my computer and send you the results.Her...
36123 Feb 2006 @ 04:56 PSTXTUPIETrainingReplyPreparation for the Teradata SQL examHi AGAIN!Before anyone asks me for the link for the TeraData Demo CD it is http://www.teradata.com/t/page/129759.This demo will work on your PC or Laptop and is a "full" version of TeraData but onl...
36023 Feb 2006 @ 04:54 PSTXTUPIETrainingReplyPreparation for the Teradata SQL examHi Sorry my tying fingers are not working today.Lick should be LUCK... No Such LUCK....
35923 Feb 2006 @ 04:53 PSTXTUPIETrainingReplyPreparation for the Teradata SQL examHiNo such lick guys. I suggest reading the SQL manual as supplied on the TeraData demo CD and practice every comaand till you understand it.
35823 Feb 2006 @ 04:51 PSTXTUPIEJobsReplylooking for job: advanced teradata certified professionalthat was for the record....
35723 Feb 2006 @ 04:50 PSTXTUPIEJobsReplylooking for job: advanced teradata certified professionalHi For the record a TD Advance Professional has completed the following certification courses:Certified ProfessionalCertified Implemetation SpecialistCertified SQL Specialist
35623 Feb 2006 @ 04:48 PSTXTUPIEToolsReplyMultiload vs TpumpHiJust a short list:MultiLoad=========* Loads data to TeraData from aMainframe or Lan flat file* Multiple tables can be loaded in the same MultiLoad.* Up to 20 INSERTS, UPDATES, or DELETES on upt o...
35523 Feb 2006 @ 03:58 PSTsethiyaguDatabaseReplyMaterialized view in TeradataHi Barry,Yes, I am practicing it in the same way.Thank you so much,Stration
35423 Feb 2006 @ 03:48 PSTsethiyaguDatabaseReply10065 WSA E HostUnreach: The Teradata Server can't currently be reached over this networkHi Manjesh,Check whether the Teradata Services are running on your machine. if not start it by using the Windows services.Hope it helps!Stration
35323 Feb 2006 @ 03:16 PSTPravin14uUDATopicIndependent Data MartsI have the following architecture as my proposal(Using independent data marts). I request you to have a look into it and give your comments.The INDEPENDENT DATA MARTS that i consider represents the...
35222 Feb 2006 @ 10:39 PSTManjeshDatabaseTopic10065 WSA E HostUnreach: The Teradata Server can't currently be reached over this networkHi,I am getting following errorNCR TDATA.DLL10065 WSA E HostUnreach: The Teradata Server can't currently be reached over this networkOne of my friend who is in same network is able to connect but m...
35122 Feb 2006 @ 10:18 PSTBwillyJobsTopicTeradata DBATeradata / Oracle DBA – 100-120KNew York City Retail Company is looking for a DBA with 3-5 years experience in Teradata and Oracle 8/ 9i. Need to have experience in Unix scripting and Teradata u...
35022 Feb 2006 @ 09:27 PSTsharadDatabaseTopicidentity column reached its maximum limitDear All,We have a table where the primary key has been defined as INTEGER Generated By Default AS Identity. The table till now is having 60 rows only, but recently when I tried to insert a row (no...
34922 Feb 2006 @ 03:13 PSTBarry-1604DatabaseReplyMaterialized view in TeradataThere is no such thing as a "materialized view" in Teradata. The equivalent in Teradata would be a join index (or aggregate index) with a corresponding view put on top of it. The command to create...
34822 Feb 2006 @ 03:09 PSTBarry-1604ToolsReplyMultiload vs TpumpMultiload performs better in almost all cases. The only time TPump's performance approaches Multiload is when you are updating a very small percentage of the rows. Tpump could probably beat Multi...
34722 Feb 2006 @ 02:18 PSTsethiyaguToolsTopicMultiload vs TpumpHi Guru's,I am a newbie to Teradata, What are all the key differences between Multiload and Tpump?. which one performs best in bulk insert, update & upsert?. How can i measure the performance?. ple...
34622 Feb 2006 @ 02:00 PSTsethiyaguDatabaseTopicMaterialized view in TeradataHi Guru's,What is the SQL command to create a materialized view in Teradata?.Thanks in advance,Stration.
34522 Feb 2006 @ 10:40 PSTgiriJobsReplylooking for job: advanced teradata certified professionalok
34422 Feb 2006 @ 09:26 PSTShri RaoConnectivityTopicunable to install Teradata odbc driver 03.05.00I am trying to install the teradata odbc drivertodbc_windows_i386.03.05.00.00.exe as I am using MDAC 2.8.1. It gives me the following errorThe NTVDM CPU has encountered an illegal instruction.Thank...
34322 Feb 2006 @ 08:35 PSTfrarapThird Party SoftwareTopicSSH for MP-RASWhere can I download the SSH package for NCR MP-RAS? Or if opensource, which SSH? I am running MP-RAS 3.02 on a Dell S2600.Thanks in advance.Frank

Pages