#DateForumTypeThreadPost
5408 Oct 2014 @ 02:50 PDTGeneralReplyhow to create new table as old table and aditionally two columns in new table?   ---New table with data dbname.test123 is an existing table with 2 columns(col1,col2)   create table dbname.new_test123(col1,col2,col3,col4) as (select col1,col2,NULL,...
5324 Sep 2014 @ 04:03 PDTDatabaseReplyTimestamp format you may check the below query and see which one is good from performance perspctive.   select  cast (cast(columnname as date format 'yyyy-mm-dd')||' '||trim(ext...
5203 Dec 2013 @ 11:24 PSTDatabaseReplyNeed to increase the query performance As suggested by doneth, Change the target table(PAMKTB.CUSTOMER_POS) as a MULTISET TABLE. Then in your select statement add group by condition to remove duplicate records getting inserte...
5130 Jan 2013 @ 11:19 PSTDatabaseReplyFORMAT symboli also want to know about this formatting symbol meaning. Any help?
5014 Mar 2012 @ 12:08 PDTDatabaseTopicdelete partition but not the data from partition I have a table t1 which is partitioned by rptg_dt column for interval as 1 day I want to remove the partitions(partition number) but not the data from partition. (i.e. table structure modifi...
4930 Jan 2012 @ 12:20 PSTDatabaseReplyredistribution or not Ulrich, your understing is correct.   Thanks  
4829 Jan 2012 @ 08:47 PSTDatabaseTopicredistribution or not I have PI on (COL1,COL2,COL3) of a table. If I use col1 and col2 in WHERE clause while fetching the data from the table,then is the tables data gets redistributed according to (col1,col2) ro...
4729 Jan 2012 @ 08:05 PSTGeneralReplydirty read record Thanks a lot for the information...
4620 Jan 2012 @ 01:04 PSTGeneralReplydirty read record My Question is when user A is inserting one record to table1, At that point of time if user B runs a select query to see all the records using ACCESS lock then where does the record inserted by ...
4519 Jan 2012 @ 04:26 PSTGeneralTopicdirty read record In access lock when dirty read happens.where exactly the records are stored. Is it in spool space?   Thanks  
4430 Dec 2011 @ 04:46 PSTGeneralReplyUnderstanding hash join Can anyone elaborate the above mentioned thing.   Thanks  
4321 Dec 2011 @ 03:42 PSTGeneralTopicUnderstanding hash join Hash join: One or both tables that are on each AMP are fit completely inside the AMP's Memory. A hash join uses memory or cache to hold small table and joins it by hash value to an unsor...
4225 Nov 2011 @ 03:56 PSTGeneralReplydata distribution in amp when more amps added Thank you Carlos...
4125 Nov 2011 @ 02:36 PSTGeneralReplydata distribution in amp when more amps added I can find out number of amps and number of records in each amp. But my question is when  PI column value is rowhashed and 32 bit rowhash is generated. The 1st 16 bit is used to id...
4025 Nov 2011 @ 02:09 PSTDatabaseReplyhow does we retrieve exact record in case of hash collission thank you all for your clarification.  
3924 Nov 2011 @ 12:49 PSTDatabaseTopichow does we retrieve exact record in case of hash collission Hi, There is a table as given below and some data.NUPI is on lastname column. hash collission has happened for persons whose lastname are jones and homes. When the below query is fired ...
3824 Nov 2011 @ 12:17 PSTGeneralTopicdata distribution in amp when more amps added Hi,   I have a table t1 having 20 unique records.UPI is defined in 1st column i.e. on col1. I have 4 AMP system. All amps hold 5 records. 4 more amp got added. If i inser...
3722 Nov 2011 @ 02:44 PSTAnalyticsTopicdata distribution concept Need to kow these basic things from teradata guru's. I have a table employee having 4lac record.emplno and deptno are columns apart from other columns. I have a table  dept hav...
3615 Nov 2011 @ 09:14 PSTDatabaseReplyUnable to login througj BTEQ i can see only "127.0.0.1 localhost" in my host file. How to login. i tried to login using .logon ***.***.**.**/username password:******* but getting error CLI 224. &nb...
3514 Nov 2011 @ 12:28 PSTGeneralReplyHelp with COLLECT STATS Dieter, Can you please provide the link for going through the manual.. Thanks
3423 Mar 2011 @ 09:14 PDTDatabaseReplyIndex selectionThanks. Got it..
3322 Mar 2011 @ 09:58 PDTDatabaseReplyIndex selectionHi Dieter, So do u mean to say for case-1 it is PPI and for case-2 it is VOSI. Or is it like create a VOSI on reporting date column for case-1 and case-2. Lets say there is a billin...
3221 Mar 2011 @ 01:21 PDTToolsReplyHow to load multiple files to fast loadcreate three scripts,in fast 2 scripts don't use .end loading statement. In the 3rd script use .end loading statement. Then run three scripts.
3120 Mar 2011 @ 11:58 PDTDatabaseReplyTeradata Queryselect x.col1,x.col2,max(x.newcol3),max(x.newcol4) from ( select col1,col2,col3,case row_number() over(partition by col1,col2 order by col3 desc) when 1 then col3 else null end newcol3, case ro...
3020 Mar 2011 @ 10:40 PDTDatabaseReplyIs is possible to use Aggregate functions inside CASE statement?sum(case condition) and group by the columns will work

Pages