#DateForumTypeThreadPost
66816 Jan 2014 @ 10:35 PSTAnalyticsReplyHelp with SQL to deal with overlapping date rangewhich release are you on?
66714 Jan 2014 @ 11:46 PSTDatabaseReplyConnection problem with TD14They are all on the same machine but quite different - the VM looks like a different computer to your laptop and therefore you need to enable that the VM can be reached from you laptop... Did you ...
66614 Jan 2014 @ 01:06 PSTDatabaseReplyConnection problem with TD14Did you try to logon with Nexus Chameoleon from the same machine as with Teradata Studio? Is ODBC installed? Teradata Studio uses JDBC
66516 Dec 2013 @ 11:38 PSTDatabaseReplyExtractin a QUERY TEXT from a Column and using this output we need to insert the data into another table.you can export the SQLs (as full Insert/selects) with bteq and can import and call these generated SQLs in the same job. Check http://forums.teradata.com/forum/general/bteq-script-to-read-and-exec...
66416 Dec 2013 @ 11:31 PSTAnalyticsReplyFast Load Vs MultiloadNot sure that above answers the orig question. I guess the number of phases are irrelevant. Usually total time to get things done is what matters. But both utilites come with limitations. Fastlo...
66316 Dec 2013 @ 11:11 PSTDatabaseReplyRESERVED WORDS:Query to find Views and macros that reference a particular table or viewcheck http://developer.teradata.com/blog/ulrich/2011/11/extract-and-analyse-database-object-dependencies
66210 Dec 2013 @ 07:40 PSTDatabaseReplyRewriting the Self joinThis should create also the same output an would do the self join only once but comes with a smal prod join SELECT case when c.id = 1 then A.MERGE_ID else B.REM_ID end, case when c.id = 1 th...
66110 Dec 2013 @ 07:33 PSTDatabaseReplyRewriting the Self join  hm, try and check the differences in explain and run times   select A.MERGE_ID, A.REM_ID, A.EFF_DT, A.FIRST_MERGE_DT , A.CURR_CUST_MERGE...
66006 Dec 2013 @ 06:40 PSTToolsReplygenerating sequention number during mloadinmods can do that but would require additional programing - check the manuals
65903 Dec 2013 @ 12:32 PSTDatabaseReplyTeradata equivalent function to FROM_TZ in Oracle REPLACE FUNCTION mydb.FROM_TZ (ts_str char(19),tz_str char(6) ) RETURNS timestamp(0) with time zone SPECIFIC mydb.FROM_TZ RETURNS NULL ON NULL INPUT LANGUAGE SQL CONTAINS SQL DE...
65803 Dec 2013 @ 07:32 PSTDatabaseReplyTeradata equivalent function to FROM_TZ in Oraclewouldn't it be just a cast? select cast('2012-12-12 23:12:59+03:00' as timestamp(0) with time zone); If you need FROM_TZ with two inpurt parameter you could create a SQL udf where yo...
65702 Dec 2013 @ 01:20 PSTAnalyticsReplyteradataR package and R 3.0.0Hi, great!!! It's working fine. I used git clone https://github.com/Teradata/teradataR/ to download it. The package required RODBC package to be installed but it works also fine with JDBC on...
65624 Nov 2013 @ 11:32 PSTDatabaseReplyAutomate my Teradata queriesCalling the SQLs from BTEQ and schedule the BTEQ calls with a scheduler, cron etc....
65521 Nov 2013 @ 02:37 PSTToolsReplyExport to delimited fileyou can also run with -s 1 option
65421 Nov 2013 @ 02:09 PSTToolsReplyExport to delimited fileYour second job is a restart. What happend at the first start? Did you changed the script? Can you run the SQL itself in SQL assitent or BTEQ or TD Studio?
65321 Nov 2013 @ 12:47 PSTDatabaseReplyfetching data by joining 2 tables in a viewOk, in this case it is too big to transform it into a SQL UDF. You facing here the problem of an de-normalized design which leads to komplex queries. CREATE MULTISET TABLE DB_TEST.T1 ( A DECI...
65221 Nov 2013 @ 12:35 PSTDatabaseReplyPerformance tuning of a Fast Load Script-correct - at least if the AVG varchar length is < char length -2. As varchar will add up to additional 2 bytes for the actual length of the varchar (e.g. it need to know how long the value is to...
65120 Nov 2013 @ 08:53 PSTMarketing & CRMReplyBusiness solution without TechnologyI don't get it - in this case you can answer you question yourself. But what will be the value of the question of this generic question and an yes to others?
65020 Nov 2013 @ 08:50 PSTDatabaseReplyNeed help in understanding Teradata's behaviourit is very difficult to answer you these questions on your pseudo code - the first query is syntax whise incorrect as columns names are missing. Not a big deal but it means it is manual pseudo code...
64920 Nov 2013 @ 06:44 PSTDatabaseReplyCASE STATEMENTHi MBR, what do you exptect others to do? You don't share DDL and data (as inserts!!!). So how could you expect that syntactially correct code is posted?  And even now you don't sha...
64820 Nov 2013 @ 06:41 PSTDatabaseReplyNeed help in understanding Teradata's behaviouryou don't have at some point an where on B.x = something? This would convert the outer to an inner join and would filter out rows.
64720 Nov 2013 @ 02:35 PSTDatabaseReplyfetching data by joining 2 tables in a viewhow many rows has your table t2?  
64620 Nov 2013 @ 12:44 PSTMarketing & CRMReplyBusiness solution without TechnologyWhat do you expect with this kind of Twitter questions? Will yes or no answer help???
64519 Nov 2013 @ 12:43 PSTDatabaseReplyfetching data by joining 2 tables in a viewBut this might be done more efficiently with an aggregation T2 before joining to T1. But again if you can not share some example DDLs and example data  (please as insert statements) it will b...
64418 Nov 2013 @ 08:17 PSTDatabaseReplyPerformance tuning of a Fast Load Script-it will depend on your source data.  In some cases network bandwidth is an issue. If you have a wide interface and it is defined with fixed and it contains many variable length char target co...

Pages