#DateForumTypeThreadPost
1425 Apr 2006 @ 09:18 PDTDatabaseTopicquestion about TD data distributionas we all know TD store data based on row hash value, data from the same table will be stored together and within the same table data sorted by row hash or different table data rows will merge by t...
1320 Apr 2006 @ 12:14 PDTDatabaseReplyHow to get tablenamehelp database dbname;you can get all tablename within your dbname
1220 Apr 2006 @ 12:08 PDTDatabaseTopicquestion about de-normalizationwhat is the relationship between physical de-normalization and join index?substitute or they two mean the same thing?need your help,
1114 Apr 2006 @ 01:22 PDTDatabaseReplyquestion on TD partition, need help!thanks
1013 Apr 2006 @ 05:27 PDTDatabaseReplyquestion on TD partition, need help!thanks for your fast reply..my question is that PI is not unique, so there existing some records with same PI values, the values are not unique, how can we define unique SI on these duplicate value...
912 Apr 2006 @ 11:28 PDTDatabaseTopicquestion on TD partition, need help!If the partitioning columns are not part of the Primary Index, the Primary Index cannot be unique (e.g., Location_Number). To maintain uniqueness on the Primary Index, we can create a USI on the PI...
812 Apr 2006 @ 11:25 PDTDatabaseReplyRandomied sampletry to define value range of ASR, and then sample the records within one specific value range, you need to define the sample number of different range to make it close to avg value.
710 Apr 2006 @ 01:50 PDTDatabaseReplyIdentity Column Not Coming in a sequence. Need Suggestion.The Teradata RDBMS does not have a direct SQL function to implement System-Assigned Keys. With Teradata V2R5, the SQL Identity feature can be used to ‚Äúgenerate a table-level unique primary index‚...
603 Apr 2006 @ 06:57 PDTDatabaseReplyIdentity Column Not Coming in a sequence. Need Suggestion.FYI...SELECT RANK(employee_number) ,employee_number ,last_nameFROM CUSTOMER_SERVICE.employee;Rank(Employee_Number) 1 Employee_Number 1025 Last_Name ShortRank(Employee...
503 Apr 2006 @ 06:46 PDTDatabaseTopicTD olap func need helpSELECT storeid ,prodid ,sales ,SUM(sales) OVER (ORDER BY sales DESC ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)FROM salestbl;I got answer set:storeid 1003 prodid C sal...
427 Mar 2006 @ 09:31 PSTDatabaseReplysth wrong when logon on BTEQsucceeded :-)
327 Mar 2006 @ 05:51 PSTDatabaseTopicsth wrong when logon on BTEQhere is hosts file:127.0.0.1 localhost DemoTDATcop1127.0.0.1 jiangyo but when I tried to log betq using command:.logon DemoTDAT/dbc,dbc;the system report error:*** CLI error: MTDP: EM_...
227 Mar 2006 @ 05:51 PSTDatabaseTopicsth wrong when logon on BTEQhere is hosts file:127.0.0.1 localhost DemoTDATcop1127.0.0.1 jiangyo but when I tried to log betq using command:.logon DemoTDAT/dbc,dbc;the system report error:*** CLI error: MTDP: EM_...
127 Mar 2006 @ 05:50 PSTDatabaseTopicsth wrong when logon on BTEQhere is hosts file:127.0.0.1 localhost DemoTDATcop1127.0.0.1 jiangyo but when I tried to log betq using command:.logon DemoTDAT/dbc,dbc;the system report error:*** CLI error: MTDP: EM_...