#DateForumTypeThreadPost
1213 Jul 2016 @ 09:37 PDTDatabaseTopicNeed to generate a row number like column As per below data, I need to generate a rank or row number type column based upon the following scenarios:   1) For a Location-Order-ID combination, it should be a same number irres...
1102 Jun 2016 @ 11:27 PDTDatabaseTopicLenght, Character_Length Function not working in view creationHi All, I am using TRIM(SUBSTRING (WHS.LOC_NM, LENGTH (WHS.LOC_NM)-2, 3)) funtion to get last 3 characters from a string. It's working fine. But while I am trying to create/replace a view...
1004 Sep 2014 @ 08:00 PDTDatabaseTopicSelecting only non duplicate values from a set of columns Requiement:- I need to remove duplicate from the data set below. The selection criteria for duplicate selection is only the first three columns i.e. C1, C2 & C3.   While selecti...
909 May 2013 @ 05:18 PDTThird Party SoftwareTopicIssue in calling SP through DataStage TD connector stageExperts, I am not sure, if I am putting this problem in the right forum. But just want to have some inputs from you:- I have created a Stored Proedure (takes a table name as an input parameter), w...
827 Dec 2012 @ 04:21 PSTDatabaseReplySkewed data handlingHere are the DDLs: CREATE SET VOLATILE TABLE TMP_TEST_NEW ,NO FALLBACK ,      CHECKSUM = DEFAULT,      DEFAULT MERGEBLOCKRATIO,    &nbs...
724 Dec 2012 @ 01:57 PSTDatabaseTopicSkewed data handlingHow do I handle the skewed data, if I have to have this data with less AMP Cpu time & Less Skew? Query looks like: SELECT PT.COL_1, PR.COL_2 FROM TMP_TEST_NEW PT    , TABLE2 PR ...
621 Nov 2012 @ 03:08 PSTDatabaseTopicQuery with Very High CPU UsageHello All, Below query is running fine, but resulting in a Very High CPU Usage. Culprit may be the CASE statement. As per explain plan, this query is "Left Outer joined using Product Join&qu...
524 Sep 2012 @ 11:16 PDTDatabaseTopicCode ConversionExperts, I tried to convert a netezza code to Teradata. Just wanted to confirm, if I have done it correclty. NZ: LTRIM(TRANSLATE(PHONE_NBR,'  (',''),'1 ') TD: TRIM ...
410 Sep 2012 @ 10:02 PDTDatabaseTopicGet the previous row's column Value Hello All, I have got source data in following way: Col_1 | Col_2 100 | 2000 100 | 3000 100 | 4000 300 | 5000 300 | 6000 300 | 7000 I need to generate an extr...
303 Sep 2012 @ 03:56 PDTDatabaseTopicMultiLoad or TPump Utility Hello All, I want to update a multiset table which has a Sparse Join Index & a Value Ordered Secondary Index. (There may be a scenario to update 5 target tables with one source) Whic...
216 May 2012 @ 04:48 PDTDatabaseTopicConversion Query -- Decimal to Char/Varchar Hi, I want to convert a Decimal field to a Char / Varchar. CAST & few other function are useful but in a scenario like: Decimal value : -0.000124 (Minus sign at start position) ...
116 Feb 2012 @ 05:22 PSTDatabaseTopicSignificance of MaxLength column What is the significance of MaxLength column in HELP TABLE command in TD? In my case, I could see the value as 4 for an Integer column. While I select the max (column_name) from table, the&...