#DateForumTypeThreadPost
1327 Mar 2013 @ 08:53 PDTGeneralTopicTeradata NodeHi  What is the common configuration/specifiction of a Teradata Node?
1226 Mar 2013 @ 09:09 PDTDatabaseReplyHow to exit a SP?Are you trying to build some LOOPs inside the Stored Procedure?
1125 Mar 2013 @ 09:45 PDTDatabaseReplyMerge SyntaxHi Craig   Try changing the SET condition to the following. UPDATE SET target_column1 = src.source_column1 ,target_column2 = src.source_column2 ,target_column3 = CURRENT_DATE ,target_...
1015 Jul 2010 @ 01:42 PDTDatabaseReplyJoin where second table has dupes!Hi you can use cross join here. SELECT FROM STORY_OUT O CROSS JOIN CSA C ON C.Cust_ID = O.Cust_Id AND C.Cust_Typ = O.Cust_Typ;
915 Jul 2010 @ 12:42 PDTDatabaseReplyUnion All problemHi jporell When it comes to hard coded values, UNION and UNION all always takes the first query's number characters available. So its always better to cast it.
814 Jul 2010 @ 02:07 PDTToolsReplyFast Export producing unreadable text fileHi In FORMAT TEXT, it will produce an arbitrary number of bytes followed by an end-of-record marker, either X ‘0A’ or X ‘0D0A’ for Windows systems. So can you try with VARTEXT or UNF...
708 Jul 2010 @ 03:50 PDTUDAReplyBT/ETto continue this topic .. i have a question. Is there any difference in these 2 scenarios in terms of the the way teradata processes them? 1. using BT ET and contains 2 DML requests. 2. same...
624 Jun 2010 @ 03:48 PDTDatabaseReplyHelp in bteqyou can use BTEQ Import. example is given below. .LOGON u4455/tljc20,tljc20 .IMPORT DATA FILE = data2_2a .REPEAT * USING in_customer_number (INTEGER) DELETE FROM AU.Customer WHERE custo...
524 Jun 2010 @ 03:33 PDTDatabaseReplySubquery VS Derived TableIn simple terms, a sub query is a query within another query. If the outer part of the query does not have relation with inner part of the quesry, then its called not sub query. EX: SELECT last...
424 Jun 2010 @ 03:15 PDTTrainingReplyNeed help to find out Teradata certification materialCan you provide information for basics...
320 Apr 2010 @ 02:24 PDTDatabaseReplyMERGE vs UPSERTyou are correct... UPSERT is a concept using which you can attain "Slowly Chaging Dimension type-1". Which basically says that if a row exists update it with new data, if its not existing already, ...
226 Mar 2010 @ 02:13 PDTDatabaseReplyTD 13Is there any documentation or tutorial available which mentions the advanced features of Teradata 12 and Teradata 13?
124 Mar 2010 @ 10:46 PDTDatabaseTopicTD 13What are the main differentiating features introduced in TD 13 when compared to TD12 or V2R6? Thanks Madhavi K