#DateForumTypeThreadPost
6324 Mar 2014 @ 06:23 PDTDatabaseReplyFASTLOAD errorAfter checking above which Raja has mentioned,  Please check if  Varchar data type is used for all the columns in the scripts ?
6221 Mar 2014 @ 07:48 PDTCloud ComputingReplyHow do I access a VMWare hosted Teradata Express from a local TD Mapping ManagerYes. By installing TTU 14.x. The new TTU tools such as TD Administrator, sql assistant on your windows 7 host machine, you can access the teradata server running on Linux (through vm player) Need ...
6121 Mar 2014 @ 07:08 PDTToolsReply Issue while loading space delimited flat file using fastload on TPTAs feinholz said above, please try changing VARCHAR TextDelimiter = 'space', to VARCHAR TextDelimiter = ' ', in the script and try.    
6021 Mar 2014 @ 06:56 PDTTrainingReplyTERADATAHi Senthil,   Regarding training of Teradata you can find below links to find some info. (Be cautious in finding suitable training for you. Take demos or sample classes to decide) http:/...
5921 Mar 2014 @ 06:37 PDTToolsReplyError in MLOADIt seems mload failed from no point of return. The log shows it is a rerun. Better don't include create table statement in mload script. To fix and run from 0th record onwards you ...
5821 Mar 2014 @ 06:24 PDTTrainingReplyOnline trainingHi Rakesh, The VM ware image of Teradata is already installed on Suse linux. we no need to install any thing. it is a plug and play image. Regarding training of Teradata you can find below links...
5718 Mar 2014 @ 06:52 PDTDatabaseReplyCDC create volatile table delta as( sel case when a.custnum is null then 'D' when b.custnum is null then 'I' when (a.custname=b.custname and a.dob=b.dob and a.gender=b.gend...
5618 Mar 2014 @ 06:36 PDTToolsReplyData mismatch while migrating data from SAS to Teradata using TPTPlease find out the entire row level duplicates in source. This count should explain why the records less in target table, as you are using the fast load functionality. (Fast load can't support...
5517 Mar 2014 @ 04:03 PDTDatabaseReplySET tablesyou can load 5 tables with 32 NUSIs each using ML.   Please see the Dieter response at below link to similar questions- http://forums.teradata.com/forum/analytics/why-fastload-does-not-supp...
5412 Mar 2014 @ 06:30 PDTToolsReplyFASTLOAD SCRIPT ISSUEIs this error after writing some data on to file or initiatlly even before starting the export. Ensure you didn't keep this file open before you start your fastexport.    
5324 Feb 2014 @ 09:53 PSTGeneralReplyTeradata Express for Windows http://www.teradata.com/express-download.aspx?dlid=2 you can try through above link to download windows 32 bit supported Teradata 13. (Need to register for 1st time) Best OS would be XP SP...
5218 Feb 2014 @ 02:20 PSTDatabaseReplyHow to find AMP numbe using Row-Hash value?Hi Dieter,  The Hassh values is of 32 bit.  HBN is the first 16/20 bits of hash value. Is there any significance of remaining bytes of hashvalue ?  or these bits reserved for future...
5118 Feb 2014 @ 02:15 PSTDatabaseReply0WSA E HostUnreach: The Teradata Server can't currently be reached over this networkSome times it could be of Firewalls or antivirus installed. Can you check for a moment by deactivating them. Some times this happens when we don't install the component in the sequence mention...
5018 Feb 2014 @ 02:02 PSTDatabaseReplyALTER_PPIyes. So it is clear that for Range partition only alter table syntax would work. for case parition it is only the workaround of Create new and insert/select. --Thank You. Sri
4918 Feb 2014 @ 01:57 PSTDatabaseReplyWant to check if two specific columns exist in more than one tableyep..its good.. Thank you . --Sri
4818 Feb 2014 @ 01:53 PSTDatabaseReply0WSA E HostUnreach: The Teradata Server can't currently be reached over this networkYes as Adeel said, ensure your service control is up. you can check the left bottom of the service control window for the status of teradata engine. It should give a message "Teradata is ...
4718 Feb 2014 @ 01:48 PSTDatabaseReplyHash Index and Single Table Join IndexSantanu, For your 4th question - The extra unique column in hashindex is the actual basetable's rowid. I believe this exist in Hash index to join with the base table fast &nbs...
4617 Feb 2014 @ 08:59 PSTDatabaseReplyWant to check if two specific columns exist in more than one tableHi Adeel, It is interesting. Can you give any sample query on DBC.columns for above requirment pls.   --Sri
4517 Feb 2014 @ 08:57 PSTDatabaseReplyOrder by Operation Across all the AMPs (The actual Space i.e perm space is distributed across all the AMS equally. Unused permspace is used as spool)
4417 Feb 2014 @ 08:56 PSTDatabaseReplyHashmap Hashing won't stop but there may be a scenario of hash collisions. Where two different primary index rows would get same hash value. To resolve this there exist one more 32 bit values gen...
4317 Feb 2014 @ 08:51 PSTTrainingReplyAny best Training Centres you guys know in Hyderabad??ok. Thanks Sudeer. It helps.
4217 Feb 2014 @ 07:08 PSTDatabaseReplyOrder by Operation Once all the AMPs sort their porttion of data in their spool, the Message passing layer(Bynet + PDE) Merge all these units to get overall sorting to provide final output. -Sri
4117 Feb 2014 @ 06:03 PSTDatabaseReplyALTER_PPII see Create table syntax above.  I think you mispasted the content. Can you please correct if you have alter ppi of case_n partition. I tried similar as range n alter statement  but not...
4017 Feb 2014 @ 04:59 PSTTrainingReplyAny best Training Centres you guys know in Hyderabad??Hi Sudeer, Thanks for the input. Just to clarify are you refering Manohar with id sunmanu9@gmail.com the speaker of below video ? http://www.youtube.com/watch?v=h6_zs6Pvb_ck
3917 Feb 2014 @ 04:57 PSTDatabaseReplyALTER_PPINo. I don't think we have option to modify case_n partition.

Pages