#DateForumTypeThreadPost
74129 Oct 2014 @ 01:05 PDTDatabaseReplySubquery in Case Statementcheck the manual    Modulo (remainder).  MOD calculates the remainder in a division operation. For example, 60 MOD 7 = 4: 60 divided by 7 equals 8, with a remainder of 4...
74029 Oct 2014 @ 12:37 PDTDatabaseReplyDeadlock on dbc.accessrightsP.S. there are changes comming   From the Partners Presentation on TD15.0:   Reindexing of DBC.Accessrights  > Feature restructures the DBC.Accessrights table and...
73929 Oct 2014 @ 12:27 PDTDatabaseReplySubquery in Case Statementmaybe I can give also an explanation mod calcualtes the rest based on a devision - 1 mod 3 = 1, 4 mod 3 = 1,  6 mod 3 = 0 etc. now you calculate the difference between 2 dates. 1.1.1900 was...
73829 Oct 2014 @ 12:14 PDTGeneralReplyIs Teradata good for Operational Online Applicationshaha - you can book me also ;-)
73729 Oct 2014 @ 11:49 PDTDatabaseReplyDeadlock on dbc.accessrightsThis dbc table has a PI on databasename and username.  As all three jobs want to create or drop objects with the same user on the same DB it can result in the dead lock situation you face. S...
73629 Oct 2014 @ 07:14 PDTGeneralReplyIs Teradata good for Operational Online Applications  In general it is possible and also quite common to source some OLTP like applications (e.g. like call centre applications) on Teradata systems. But you need to have a proper design as well...
73529 Oct 2014 @ 04:13 PDTDatabaseReplyDate field behaving different in different environmentwhich tool do you use to run the query? you use the same tool for both queries? run show your_SQL; on both environments. check if the date field contains different format strings in the differ...
73428 Oct 2014 @ 11:49 PDTDatabaseReplyErrormessage: The file "errmsg.cat" cannot be opened. Fastload Teradata 14.10Hi, so installation seems to correct. But can't help you any further as I don't have access to Informatica currently. Is it possible that this is pointing to a old version? Ulrich
73328 Oct 2014 @ 08:02 PDTDatabaseReplyCpu and io skew -99%The SQL is much more complex as you code is showing as you seem to access views which contain also some complex logic - are you aware of this? The high skew is most likely to be related to missing...
73228 Oct 2014 @ 07:58 PDTDatabaseReplyErrormessage: The file "errmsg.cat" cannot be opened. Fastload Teradata 14.10Are you sure that CLI & fastload are both on 14.10? Is BTEQ starting? Is it showing 14.10?
73128 Oct 2014 @ 06:42 PDTGeneralReplyIf we create a 32 secondary indexes on table what might be the performance  Decreases performance of what? 
It will definitely add space requirements and also any insert/update and delete on this table will take longer as all 32 indices might need to be maintain...
73027 Oct 2014 @ 09:58 PDTData ModelingReplyCasting integers....but this means that at least one row contains a value which can't be converted into an integer. Which version are you on?
72927 Oct 2014 @ 07:42 PDTDatabaseReplywrite SQL UDF in TeradataSQL UDFs are "only" wrapper to encapsulate some SQL code to make code reusable and more readable. What you descibe sounds much more like a Stored Proceedure
72827 Oct 2014 @ 07:40 PDTUDAReply[Performance] how to avoid parsing time when executing macro via JDBC I saw a similar issue at a customer side related to JI - parsing at this time took 15 min. The workarround was to set a specific diagnostic statement which would tell the optimizer to do a less de...
72724 Oct 2014 @ 08:12 PDTUDAReply[Performance] how to avoid parsing time when executing macro via JDBC This macro is working as you posted it? I thought using group by and ordered analytic functions can not be done on the same level. Beside this - it is a fairly complex SQL - can you share the exp...
72624 Oct 2014 @ 08:03 PDTDatabaseReplySubquery in Case Statementsel top 5  Fld1,Fld2 from Table1 will give you up to 5 rows back -> so what is your expected assignment?
72517 Oct 2014 @ 01:30 PDTDatabaseReplyMatching within a windowthe requiremet is a bit unclear to me - is the condition to be meet within a single row or accross multiple rows? the first case should be clear the second case cold be solved with OLAP functions...
72414 Oct 2014 @ 11:49 PDTDatabaseReplySQL-LoopingYou should avoid multiple scans over the data - its waisting IO and CPU Try something like: replace macro yourdb.agg_demo (ref_date date) as ( select case when c.id = 1 then 'annual'...
72313 Oct 2014 @ 08:25 PDTDatabaseReplyTranspose data from wide table to long tabletry select customerid, case case when id = 1 and col1 = 1 then 1 case when id = 2 and col2 = 1 then 2 case when id = 3 and col3 = 1 then 3 ...
72209 Oct 2014 @ 05:28 PDTDatabaseReplymatch against next row select id, product_no, product_desc, product_code, job_no, cost, case when job_no <> coalesce(max(job_no) over (partition by p...
72109 Oct 2014 @ 04:38 PDTDatabaseReplyHow to avoid using QUALIFY OVER PARTITION BYdo you mean   QUALIFY row_number() OVER (PARTITION BY A.key_field ORDER BY F.date_field) = 1?   do you have max 1:1 relation...
72007 Oct 2014 @ 11:46 PDTPrivate Forum
71907 Oct 2014 @ 02:23 PDTDatabaseReplyTeradata SQL Assistant 15.00 DROP STATISTICS not workingok - adding the jpg didn't work - check syntax diagram in Chapter 16 Statistics Statements of SQL Data Definition Language Syntax and Examples  
71807 Oct 2014 @ 02:22 PDTDatabaseReplyTeradata SQL Assistant 15.00 DROP STATISTICS not workingtry  DROP STATISTICS on T1; or DROP STATISTICS COLUMN VAL on T1;   If both are not working I would raise a ticket at TD. ...
71706 Oct 2014 @ 06:54 PDTDatabaseReplyTeradata SQL Assistant 15.00 DROP STATISTICS not workingHi Peter, you are using the old stats syntax. The current / new on is    COLLECT STATISTICS COLUMN val on T1; I guess - but can't validate right now, as I don't have SQLA 15....

Pages