#DateForumTypeThreadPost
2920 Nov 2014 @ 07:45 PSTDatabaseReplyOptimization with JOIN conditionHi Marios, Everything looks correct. Did you tried by doing an explain plan?  Also do you need all the columns from both tables or only few columns?
2802 Nov 2014 @ 06:43 PSTDatabaseReplyPerformance Tips for Group by on all columnsHi Karthik, Did you checked by doing explain of that query which will give more details about the performance issue and will also show if there is any Product join involved? Is all the required s...
2730 Oct 2014 @ 05:19 PDTDatabaseReplyTablesize in GBHi Raja, I am talking about the records in Tablesize table. Staging and Target table has more or less same table structure but few other processing happens in target table by doing look up with so...
2629 Oct 2014 @ 02:29 PDTDatabaseTopicTablesize in GBHi All, I am using the below query to calculate the tablesize in GB. I am seeing multiple entries for the same table with various vproc. This is the final Mart table and the same table has stagin...
2529 Oct 2014 @ 02:00 PDTDatabaseReplyAggregate Join Index on Complex SQL statementsHi Raj, After GROUP BY there is few CASE statements. Is it possible to include in the SELECT clause and give a try?
2429 Oct 2014 @ 01:48 PDTDatabaseReplyTeradata Studios Create Local VariableHi Darres, Can you try like this. I haven't ran this but giving you the sample code snippet. REPLACE Sample_Proc (   REGION VARCHAR(20) ) BEGIN DECLARE vDivision VARCHAR(20); ...
2329 Oct 2014 @ 01:20 PDTDatabaseReplyError : A column or character expression is larger than the max size. Hi Karthik, This could be the reason. You have used the table name wrongly for RequestText in the below function. Can you change and try? REGEXP_REPLACE(B.REQUESTTEXT,A.ETL_VIEW,A.REP_VIEW,1,1...
2229 Oct 2014 @ 01:08 PDTDatabaseReplyAVG() FUNCTION RETURNING DIFFERENT VALUES FOR SAME INPUTHi Arun, If you are still facing the issue, can you share the query?
2129 Oct 2014 @ 12:47 PDTDatabaseReplySubquery in Case StatementHi Ulrich, Thanks for the details but still i am not clear about the logic of mod. When you say mod calculates rest based on dvision...for ex:14/7 = 2 is this the output or mod has some specific c...
2029 Oct 2014 @ 11:58 PDTDatabaseReplySubquery in Case StatementHi Carlos, Just wanted to know what does Mod7 does and how you are achieving the results without using SYS_CALENDAR.Calendar . DATE in the below query are you referring to current_date. ...
1929 Oct 2014 @ 05:51 PDTTrainingReplyPointers for TD CertificationHi Raja, Thanks for the details. What i meant is when i referred TD 14.10 release document for the below Topic "Changes in System Behavior", there are so many sub-topics but not all of t...
1827 Oct 2014 @ 01:38 PDTTrainingTopicPointers for TD CertificationHi All, I am looking for some good TD material which describes mainly about the TD database versions, differences and the changes/upgrade done with respect to that version, adv/disadv of the versi...
1723 Oct 2014 @ 05:22 PDTDatabaseReplyhistory handled output requiredHi Suji, Can you give some more details about the 3rd result. How you mapped US to TWD? Also what is the rule to get country as NULL for the first 2 results. Usually currency as USD will map to co...
1621 Oct 2014 @ 05:38 PDTDatabaseReplyTeradata query tunningHi Arpit, Right side of the query is not fully viewable but few things you can try: 1) Did you collect stats on only the PI columns or both PI columns and the join columns used in the query? 2) ...
1508 Oct 2014 @ 07:58 PDTDatabaseReplyFailure 2620 The format or data contains a bad characterHi drmkd17, I tried the query you had posted and it's working fine.  As Dieter mentioned, could you please confirm the data type? create volatile table V_FIELD_DATA_TYPE_CHK (&nb...
1410 Aug 2014 @ 10:05 PDTDatabaseReplyNumeric overflow issueHi, Source details as follows: Col1 Decimal(5,0) Col2 Decimal(5,0) Target details as follows: Col1 Decimal(9,0) Col2 Decimal(9,0) Col3 Decimal(3,0) but one thing i noticed is few of the val...
1308 Aug 2014 @ 09:28 PDTDatabaseTopicNumeric overflow issueHi, I am getting the below given error but the table from which i am selecting the value has datatype as decimal and the table which i am inserting also has datatype as decimal but while inserting...
1219 Jul 2014 @ 07:47 PDTDatabaseReplyBlank space check based on the positionBut when i check for the NULL/BLANK space values using '', it's not getting calculated correctly. I am not sure whether it's because of the substring value i am checking NULL or sin...
1116 Jul 2014 @ 12:28 PDTDatabaseReplyBlank space check based on the positionThanks Dieter for the details. I used substring to acheive the result but it says "SELECT Failed. 2621: Bad character in format or data". The column which i am checking has a datatype of...
1014 Jul 2014 @ 08:43 PDTDatabaseTopicPosition value for numeric, alphabets and blankI am having one column where it can have position 3-5 as blank. It can be as position 3 as blank or position 4-5 as blank. I tried using substr(colname, 5, 1) = ' ' but it's not worki...
913 Jul 2014 @ 09:27 PDTDatabaseReplyBlank space check based on the positionCan anyone help me on this?
811 Jul 2014 @ 03:24 PDTDatabaseReplyBlank space check based on the positionInput could be column A where it has value as A1234D, HGDF34 etc.. I need to get output with some case stmt return values.. For ex: If Position 1 is not B and Position 2-4 is numeric THEN 'AB...
710 Jul 2014 @ 09:46 PDTDatabaseTopicBlank space check based on the positionHi, I am having one column where it can have position 3-5 as blank. It can be as position 3 as blank or position 4-5 as blank. I tried using substr(colname, 5, 1) = ' ' but it's not w...
606 Jun 2014 @ 08:13 PDTDatabaseReplyOrder Of columns in PI for multilevel Partitioned TableHi, I don't think it will be an issue based on the order, as you are defining the PI which in turn you are going to use the same PI column for PPI. If you are not clear, could you please give ...
506 Jun 2014 @ 08:07 PDTDatabaseReplyneed syntax for for last 2 years dataHi, You can try with ADD_MONTHS function as well: SEL BUSINESSDATE BETWEEN ADD_MONTHS(CAST('2014-06-06' AS DATE ),-24) AND DATE.  

Pages