#DateForumTypeThreadPost
2201 Jan 2014 @ 10:34 PSTDatabaseTopicOrder of partition columns in MLPPI Hi All   May be I have posted this question before in this forum, but I am reposting it because that time I did not get any reply. Now I have been asked in a technical meeting to su...
2101 Jan 2014 @ 09:48 PSTToolsReplyWhen are secondary indexes required?Hi VandeBergB Yes you are absolutely right. But my query was actually initiated from 2 specific comments in the above posts. 1. You can define NUSI in a PPI table to make a PI access single ...
2001 Jan 2014 @ 04:10 PSTToolsReplyWhen are secondary indexes required?Hi Saeed Here is the detail. 1. There are 12499 data in the table. 2. The typical rows / value for TRANSACTION_DT is 3000 3. Even though it is defined as MULTISET NUPI but the TRANS_ID fie...
1901 Jan 2014 @ 03:34 PSTToolsReplyWhen are secondary indexes required?Hi Saeed Thanks for your quick reply. But when I am trying the same in my TD DB I am getting a different result. I am not able to understand why is it different than the desired result.   ...
1801 Jan 2014 @ 02:40 PSTToolsReplyWhen are secondary indexes required?Hi Saeed I am just curious to know more about your last comment (may be what I have interpreted is wrong). "NUSI in a PPI table to make a PI access single amp" - would you kindly elabor...
1730 Dec 2013 @ 03:29 PSTDatabaseReplyQuery on Skew-Sensitivity in the TD12 above Optimizer Hi All   I have not received any update on my above query. However, I found few things by myself. I am sharing that. Hope this might be helpful to others.   1. I create...
1625 Dec 2013 @ 09:51 PSTDatabaseTopicQuery on Skew-Sensitivity in the TD12 above OptimizerHi All, I was reading Carrie's blog on skew sensitivity of TD12 optimizer. http://developer.teradata.com/database/articles/skew-sensitivity-in-the-optimizer-new-in-teradata-12   Here a...
1525 Dec 2013 @ 01:54 PSTDatabaseTopicClarification on Rowhash Match Scan and Sync ScanHi Folks,   I need confirmation on my understaning of Rowhash Match Scan and Sync Scan.    1. I am joining two tables TableA and TableB using TableA.A1 column which is PI and Ta...
1407 Dec 2013 @ 06:00 PSTDatabaseReplyTD Lock Upgrade and Downgrade OptionsThanks dnoeth for your reply.
1306 Dec 2013 @ 11:49 PSTDatabaseTopicTD Lock Upgrade and Downgrade OptionsHi In a script, at Session level the transaction isolation is set to RU (Read Uncommitted or ACCESS). At table level I am overriding to READ lock for Table1 in a SQL select.   Now if there...
1223 Nov 2013 @ 09:48 PSTDatabaseReplyTeradata Data Types to OracleThanks Saeed and Raja. We try to understand the functionality from source end before bringing them to TD. But some time it is not possible to do rnd on source data and they are being brought throug...
1121 Nov 2013 @ 10:14 PSTDatabaseTopicTeradata Data Types to OracleHi All I am having problems while loading data from Oracle to TD14. In most cases the problem is with data type, like NUMBER(p,s), LONG RAW, NVARCHAR2 including Unicode, Multi byte and different C...
1016 Oct 2013 @ 11:34 PDTDatabaseTopicMigration from Oracle to TeradataHi Guys I am working on migration from Oracle to Teradata. I am facing few issues there. I would be glad if some one please clarify below questions.   1. Oracle has VARCHAR2 and NVARCHAR2 ...
916 Oct 2013 @ 11:14 PDTDatabaseReplyHash Index and Single Table Join IndexThanks Raja .. for your reply. It is really helpful.   Santanu
805 Oct 2013 @ 08:24 PDTDatabaseTopicHash Index and Single Table Join Index Hi   There may be a discussion already in this forum about Hash and Join Index. Still I am creating this post because I want to clarify few queries for my own understanding. ...
728 Sep 2013 @ 11:43 PDTDatabaseReplyTeradata Express for WIN 32 BITHi Thanks Vlad for your reply. And to all, I am finally able to download TD 13. The link above works. I used download manager (as Vlad said). However, there are some other tricks too. You have t...
626 Sep 2013 @ 01:54 PDTDatabaseReplyTeradata Express for WIN 32 BITWell just to add on Saeed's point .. yes TD14 express is available only for VM not for Win. Santanu
526 Sep 2013 @ 01:52 PDTDatabaseReplyTeradata Express for WIN 32 BITHi Rajat and all I am following the link mentioned by Rajat to download TD Express 13. I have created account.  Initially it is showing 1.12 GB file. But it is downloading only 50% and abort...
426 Sep 2013 @ 11:54 PDTDatabaseReplyTeradata Express Database for WindowsHi Saeed The link you given above, there in the page we have another link  Teradata Express 13.0 for Windows   I presume it will take us to the download location. But on clicking it i...
326 Sep 2013 @ 08:01 PDTDatabaseTopicTeradata Express Database for WindowsIs Teradata Database Express windows version still available to download in local machine to practice and hands on or it has been obsolete? Because I can find TD Express VMware version but no...
224 Apr 2013 @ 11:33 PDTDatabaseReplyNeed Help on two questions about TD architectureThanks for your help
118 Apr 2013 @ 03:12 PDTDatabaseTopicNeed Help on two questions about TD architectureHi Friends I am new to this forum. I hope this is the right place to post below questions. I am preparing for TD Basic certification. While doing so I stumbled on two questions. Here are they. 1....

Pages