#DateForumTypeThreadPost
1527 Jul 2016 @ 12:28 PDTDatabaseTopicNeed ER Modeling for Below Requirement You want to design a database to manage information on the collection of various types of taxes (stamp duty, real estate, automotive patent, gross income) by a state agency. Taxpayers are some e...
1413 May 2016 @ 01:01 PDTDatabaseTopicIssue while logging : CLI error: CLI2: BADLOGMECH(507)Hi All, While logging to Teradata system, I am facing below issue. .logon tdprod/td_user, *** CLI error: CLI2: BADLOGMECH(507): Requested logon mechanism is not available. *** Return code from ...
1304 Feb 2016 @ 09:35 PSTDatabaseTopicFind Only DuplicatesHi All, I have very big table and it has around 250 columns and this table may have duplicates. this table does not have any UPI or USI or event primary index also based on many columns. Now my ...
1209 Jan 2015 @ 12:50 PSTDatabaseReplyFind Second Highest Salary - SQL   create table retail.Find_nth_sal ( id int, Name varchar(20), sal int, Dept Char(2) ); insert into retail.Find_nth_sal (1,'SAM ',50,'D1'); insert into retai...
1122 Nov 2014 @ 06:22 PSTGeneralReplyMload vs Fastload in rejecting the duplicatesThanks Todd for your very informative answer regarding both phases of FL. Could you please explain in same way all the phases of Multiload. Thanks
1015 Nov 2014 @ 11:38 PSTDatabaseReplyHelp on Below SQLThanks Dieter for your quick response...:) Could you please below query once and Please suggest to optimize this query. SELECT SOURCE_PLACE,DESTINATION_PLACE,distance FROM RETAIL.DISTANCE ...
915 Nov 2014 @ 08:48 PSTDatabaseTopicHelp on Below SQL drop table retail.distance;   drop table  retail.distance1;  create table retail.distance  (  source_Place varchar(20),  destination_Place v...
805 Aug 2014 @ 02:32 PDTGeneralReplyhow to eliminate duplicate records in a file while loading into the target table without using fastloadHi Purushotham, To avoid duplicates, you have to use upsert with label "DO INSERT FOR MISSING UPDATE ROWS;"  into your multiload script. I have tried and it working for me. Please ...
705 Aug 2014 @ 11:53 PDTGeneralReplyhow to eliminate duplicate records in a file while loading into the target table without using fastload Hi Purushotham, In General, If your file has duplicate records and you want to load only distinct records then you have to create -- Set table or Table with UPI.  It will allow ...
603 Aug 2014 @ 01:17 PDTGeneralReplyTuning the queryHi teradatauser2, PFR.. SELECT   DatabaseName   ,TableName   ,CAST(SUM(currentperm) / 1024**3 AS DEC(9,2)) AS GB   ,CAST((MAX(CurrentPerm) / AVG(Curre...
525 Sep 2013 @ 10:06 PDTDatabaseReplyLT,WT,ET,UV tablesThanks for ur response. I just want to know how they are processing data i.e. how they are loading data.   Thanks, Abhijeet
422 Sep 2013 @ 12:05 PDTGeneralTopicHow to install Teradata for practice in windows xp.Hi, Could anyone please tell me, How can I install teradata in windowsXP. Please tell me step by step proccess. Thanks, Abhijeet
321 Sep 2013 @ 11:18 PDTDatabaseReplyCannot install Teradata Express 13 under Windows XPCan anyone tell, from where I should download Teradata_Express_130.exe.    Thanks, Abhijeet
221 Sep 2013 @ 06:29 PDTDatabaseReplyLT,WT,ET,UV tablesHi,   Could anyone please give full mload,tpump,fastload,tpts  processing in very consise manner.   Thanks, Abhijeet
111 Dec 2012 @ 07:53 PSTDatabaseReplyConvert integer to TIMEHi,   How to compile procedure's ddl which is having UNicode character in ddl. like below WHEN sr.std_response_desc LIKE '%要因%'  THEN qa.ans_txt I tried with bteq but...