#DateForumTypeThreadPost
1914 Feb 2016 @ 10:39 PSTTrainingTopicPlease Contact for TD developer Training or backup Job support on Teradata/InformaticaAny working professionals from USA Please contact me at venkylingutla@gmail.com for more details !!
1801 Feb 2016 @ 02:07 PSTToolsReplyBTEQ .SET RECORDMODE ON; in Unix creating illegible characters.DATA : returns the results of a query to a file for processing by other programs. BTEQ returns data in Record mode and stores it in FastLoad format output file. Use this format to interchange data ...
1714 Jul 2015 @ 08:09 PDTGeneralReplyBteq to unload/load BLoB/CLOB data Hi , You did multiple casting while exporting and using the format as like table structure in import. It trying to treat entire record as one field and failing. Better do export with some delimete...
1613 Jul 2015 @ 03:28 PDTDatabaseReplyBest way to add a partition to an existing tableHi Kaushik, 1 way is the good one. Even we follow the same in our application.
1528 May 2014 @ 04:44 PDTDatabaseReplyBest practise table creation with primary key or/and index?Hi, UPI in Teradata works to distribute the data across all AMPS. PK is not works like that.
1427 Jan 2014 @ 03:36 PSTDatabaseReplyCan 'INSERT INTO' statement handle duplicates?Hi, With Union all and Group by you cant eliminate the duplicate rows. Use Union in place of Union all and no need of Group by that will insert unique records.   Thanks, Venkat
1331 Oct 2013 @ 02:00 PDTJobsReplyAny good training institute to learn teradata?I will provide online training. Please contact   9704014315   Thanks,
1204 Sep 2013 @ 02:32 PDTDatabaseReplyHelp me to improve the query performanceprovide ur original Query. you are joining table1field with all other tables which will create product join and its product degradation.   Thanks, Venkat
1128 Aug 2013 @ 02:54 PDTDatabaseReplyExtracting Domain Names from EMAIL_TXT Field  Hi, Try the below. I hope it will give you expected result sel emialtext,substr(emailtext,index(emailtext,'.')) from sch.table where emailtext like '%.%'   Ven...
1020 Dec 2012 @ 09:11 PSTDatabaseReply"verbose" explainHi All,   can anone help me what is the key word Spool Asgnlist  in verbose explain plan.     Thanks, Venky
907 Nov 2012 @ 04:24 PSTDatabaseReplyPerformance Tuning Merge Statement Hi As per the explain plan its merging the data with low confidence. you are using PI on multile columns.   Please collect the stats on join columns individually it will solve y...
810 Oct 2012 @ 04:01 PDTDatabaseReplyTeradata Update Syntax  UPDATE cust_zone_sales k FROM ( SELECT 1420 AS main_zone_id, 17 AS zone_no, COUNT(*) AS sales_count, (SUM(usd_amount) + SUM(euro_amount) ) AS sales_sum FROM new_cust_table a INNER JO...
710 Oct 2012 @ 03:36 PDTDatabaseReplyre:spool spaceall your words are correct but spool space problem depends on processing data and index selection on columns. If ur processing data goes into one emp which is holding only 1gb spool then it will fa...
625 Sep 2012 @ 04:24 PDTUDAReplyHow to exceute only integer records in character columnTo extract only integer values u can use the query as below SELECT OTRANSLATE(<columnname>, OTRANSLATE(<columnname>, '.0123456789', ''), '') FROM <<t...
512 Jun 2012 @ 11:42 PDTDatabaseReplyError from Insert Select statement Hi, It means in the table FMP_STRATEGIC_CM_BORROWER_AUTO the colmn contains unique primary index please check. with the sql statement show table <tablename>; thanks, Venkat
412 Jun 2012 @ 04:48 PDTGeneralReplyBteq script to read and execute query from a table hi Arya, please use the below logic. first export the data from the table to the file using the bewlo bteq script .LOGON dbc/userame,pwd; DATABASE dbname;; .export data file=coun...
308 Jun 2012 @ 02:13 PDTDatabaseReplyUpdate on partition by statement HI Srinivas, find the below query which will update the latest record for the specific job name. UPDATE UPDATE_JOB FROM ( SELECT NAME,MAX(STRT_TM) AS STRT FROM UPDATE_JO...
208 Jun 2012 @ 01:18 PDTDatabaseReplyTo find invalid dates? Hi Sachin, The below query will work for ur scenario.   SELECT A.jdate, CASE WHEN B.calendar_date IS NULL THEN 'Invalid Date' ELSE'Valid Date' ...
106 Jun 2012 @ 04:05 PDTDatabaseReplyShortcut Keys for Teradata SQL Assistant Use "queryman" in run prompt.   Thanks, venky