#DateForumTypeThreadPost
720 Apr 2015 @ 01:20 PDTDatabaseTopicSplit the table data into multiple filesHi All,   I have a requirement where I need to fast export the data using TPT and the exported data should split into multiple files based on date column. e.g: Table Data 1  abc 2015...
625 Mar 2015 @ 10:19 PDTDatabaseTopicNeed help in generating sequence numbers in BTEQ script Hello,   I am a requirement to generate a sequence numer(e.g 000000000000,000000000001 etc) (the columns should be 12digits).    Query :   SEL ...
523 Jan 2015 @ 08:02 PSTDatabaseReplyNeed help in tuning a QueryHi Dieter, Thank you for your suggestion..UNION ALL is working better than UNION,reducing the run time from 69minutes to 58mins but consuming more spool space of about 1100GB which will not be pro...
423 Jan 2015 @ 05:41 PSTDatabaseTopicNeed help in tuning a QueryHi All, The below Query is facing Spool space issue while executing ... SEL I.DLVR_POINT_NO, SUM(I.SALES) AS InvoiceAmtLast12, CAST(NULL AS DECIMAL(18,2)) AS InvoiceAmtLast24,  CAST(N...
319 Dec 2013 @ 04:42 PSTDatabaseReplyjoining two tables using SUBSTRThank you Saeed Khurram..The code is working...
217 Dec 2013 @ 09:16 PSTDatabaseTopicjoining two tables using SUBSTRHi All, I have a requirement where there are two tables Tbl1 and Tbl2 .i want to join these two tables based on the columns Cntry_code. The Data is like : Tbl1          ...
107 Sep 2011 @ 11:10 PDTJobsReplyWe can Help you in gettng JOB in Teradata Hi Srinivas Mandala, I am working on teradata from last 3years but haven't get a chance to work much on Utilites.I want to learn Teradata utilites ,so can you suggest on how can I impro...