#DateForumTypeThreadPost
2430 May 2013 @ 02:36 PDTDatabaseReplyTable partitioning on TIMESTAMP(3) in Teradata 13Hi,   We are on TD 13.10. We implemented PPI on timestamp column with below syntax, CREATE SET TABLE ..... . . .   UNIQUE PRIMARY INDEX ( DATASOURCE_NUM_ID ,INTEGRATION_ID ,X_...
2325 Apr 2013 @ 02:21 PDTAnalyticsReplyWhy subqueries in case are not working in teradata?Hi Dieter, Thank you very much for your suggestions and modifications. But still i am getting "Illegel expression in WHEN clause of CASE expression".   Yes this query is running ...
2224 Apr 2013 @ 11:41 PDTAnalyticsReplyWhy subqueries in case are not working in teradata?Hi Dieter,    As you said the syntax should work on TD 13.00, but same is not working on 13.10. Can you pls suggest some changes to achieve same on TD. Below is my complete query, &nb...
2124 Apr 2013 @ 10:47 PDTAnalyticsReplyWhy subqueries in case are not working in teradata?Thanks Dieter.   We are on TD 13.10 but its not working as is, so trying to rewrite as outer join.   Regards, Ashish  
2024 Apr 2013 @ 06:24 PDTAnalyticsReplyWhy subqueries in case are not working in teradata?Hi Dieter, I am also facing the same issue, for converting one oracle query to Teradata. Oracle Query: case when W_PARTY_PER_D.X_DISTRICT in (select upper(WC_ORG_EXT_XM_F.attrib_04) from wc_org_...
1904 Apr 2013 @ 03:13 PDTDatabaseReply¿Alternatives to increase the performance of this query?Hi ,   We are getting different behaviour while firing same query multiple times on database. Every time its takes different time to execute. First it took 2 min then 5 min then 15 min. its i...
1815 Mar 2013 @ 06:08 PDTAnalyticsReplyrow concatenation for dummies? AKA oracle wm_concat() teradata equivalentKindly help me for same
1715 Mar 2013 @ 03:51 PDTAnalyticsReplyrow concatenation for dummies? AKA oracle wm_concat() teradata equivalentDEALER_WID DIVN_WID                       EVTLOC_WID           MONTH_WID           &nbs...
1615 Mar 2013 @ 02:36 PDTAnalyticsReplyrow concatenation for dummies? AKA oracle wm_concat() teradata equivalentHi Rajeev, Thanks for giving solution. But the problem is this logic is working if i have only one column in GROUP BY and ORDER BY. This is not working if i have multiple columns for groupin...
1507 Mar 2013 @ 02:15 PSTAnalyticsReplyrow concatenation for dummies? AKA oracle wm_concat() teradata equivalentHi,   Can anyone guide on how can we implement WM_CONCAT as explained above in Teradata ? In our case some Oracle logics are built on this, there should be some way to replicate this in Ter...
1422 Jan 2013 @ 04:54 PSTDatabaseReplyOracle numeric data type equivalent on Teradata.Thank you very much for quick response Dieter,   Regarding DATE columns, yes we have already addressed that one by making Oracle DATE columns(Has date, time and AM/PM ) as TIMESTAMP(24 hrs) ...
1322 Jan 2013 @ 01:09 PSTDatabaseReplyOracle numeric data type equivalent on Teradata.Thanks Dieter,   We are migrating to TD13.10.   We are thinking to replace NUMBER as DECIMAL(38,14) in teradata, is it good idea to replicate same as Oracle?   or should we fir...
1221 Jan 2013 @ 10:16 PSTDatabaseReplyOracle numeric data type equivalent on Teradata.Hi, Extending thread a little bit. In oracle we have datatype as NUMBER without any precision and scale. So it can accept large values i.e. around 38 digits and 14 decimals. So for these, what i...
1128 Dec 2012 @ 06:46 PSTToolsReplyProblem in writing MULTILOAD scriptThanks feinholz,   We also thought of the same alternative but it was not performence gainer.   So finally we confirmed the business logic behind that table and decided to go with UPI...
1027 Dec 2012 @ 05:51 PSTToolsReplyProblem in writing MULTILOAD scriptHI dnoeth,     We are getting same error. We are using MLOAD on a table which is PARTITIONED on column ORDER_TYPE and NUPI on another column ROW_WID. Here we are using MLOAD UPSERT whe...
921 Nov 2012 @ 09:37 PSTToolsReplyTeradata PT 12.0 error output schema does not matchThanks feinholz, :)   I moved ahead but now i am getting different error stating its not able to load shared library libodbcop.so. I checked whether this file exists or not, but its there o...
821 Nov 2012 @ 03:56 PSTToolsReplyTeradata PT 12.0 error output schema does not matchHi feinholz,    Can u pls help me out for below erros that i m getting while running TPT script to load data from oracle table to teradata table.I am not able to figure out the root caus...
701 Oct 2012 @ 12:37 PDTAnalyticsReplyCalling a bteq Script from informaticaHi Murugan,   Can u pls explain how to invoke a BTEQ script in a command Task after the required session.   Below command is not working... sh ./opt/teradata/client/13.10/bin/bteq<...
630 Sep 2012 @ 02:00 PDTToolsReplyfastload issue with inmod pathThank you very much for ur suggestions.   Our Teradata version is 13.10.   We are using informaticawith FLOAD to load data from oracle but it's giving very bad performance when lo...
508 Sep 2012 @ 12:08 PDTDatabaseReplydeleted a table hi dieter,     I am new to TD. I would like to extend this thread... as i got the questions now.   As we have flashback recovery options in oracle to recover tha ...
409 Aug 2012 @ 08:23 PDTToolsReplyfastload issue with inmod path Hi,   Hi i am a beginer for INMOD routines.   Can anyone pls explain how i can use INMOD with fastload to get data from oracle tables and insert it directly into terada...
321 Jun 2012 @ 06:05 PDTGeneralReplyFailure 2646 No more spool space in Hi,   I am also getting the same error for user etluser as   [Teradata][ODBC Teradata Driver][Teradata Database] No more spool space in etluser   I am runn...
229 May 2012 @ 02:37 PDTExtensibilityReplyData Migration from Oracle (Data Import)Hi everyone, If we will use Ora2TD for data migration, will it create tables also on teradata platform? Or it will only load the data? If not can anyone please suggest which tools we can ...
124 May 2012 @ 05:57 PDTThird Party SoftwareReplyOracle to Teradata Database Migration Tool Hi, We are migrating from oracle to teradata. Can anyone please guide about how we can proceed for migration. Our current production environment details are as below,   ETLTool ...