All comment activity

#DateUserWhereItemComment
651027 Jan 2016 @ 08:56 PSTTonyLToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskKamma1166, what is the source of the 6TB data? Is the source data on 1 or more disk files? Is the source data on an ODBC-complaint database, such as Oracle or DB2? Is the source data on a differ...
650927 Jan 2016 @ 08:20 PSTericscheieToolsTeradata Python Module@davidtzoor -  I'm working on a fix to improve fetch performance.   Progress can be tracked here:  https://github.com/Teradata/PyTd/issues/29
650827 Jan 2016 @ 08:07 PSTitboaterConnectivityTeradata Mainframe Client Utilities updateOk, I did find "Steve Goldin".  I will try to create an email to him within Teradata.
650727 Jan 2016 @ 08:06 PSTitboaterConnectivityTeradata Mainframe Client Utilities updateWho and where is the author, STEVEG.  He seems to have disappeared and no one at Teradata can identify him.  I have follow-on questions about these re-compiles.
650627 Jan 2016 @ 04:35 PSTKamma1166ToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskHi Tony,   i want migrate 6TB of data in Teradata Database, could you please help me how TPT can help me for this.
650526 Jan 2016 @ 11:47 PSTdbc1012ConnectivityAccess External Data - A Table UDFHi there thakurra, Thanks for your questions. 1) UNfortunately you can not hide the password using DbLink, but you can with Teradata views and permissions. What I recommend is that you create a v...
650426 Jan 2016 @ 11:36 PSTdavidtzoorToolsTeradata Python ModuleI get poor performance with the Python Teradata module compared to pyodbc and JDBC.  Here is a comparison of the 3 modules and the time it took to execute the query with different dataset siz...
650326 Jan 2016 @ 03:15 PSTcarriecarrie's blogRecommended Dictionary Statistics to Collect in Teradata 14.0TVM and Dbase are both tables that commonly have stats collected on them.   So I don't see a problem with collecting stats in addition to the ones usually recommended for those tables...
650226 Jan 2016 @ 01:35 PSTfgrimmerToolsTeradata Studio 15.10 now availableAaron, Does it eventually come up? I have seen an issue where it pauses for about 30 seconds. Can you install Studio outside the VM and access your Teradata system inside the VM? You will need the ...
650126 Jan 2016 @ 08:39 PSTthakurrabikant@gmail.comConnectivityAccess External Data - A Table UDFNeed some suggestion regarding the securit. 1. How i can hide the password in TD where we have put the ID/Password to connect with Oracle. 2. can we pass the query in DbLink function during selec...
650025 Jan 2016 @ 04:33 PSTasampson68ToolsTeradata Studio 15.10 now availableExperienced DBA but new to Teradata... trying to evaluate so I downloaded the TD supplied preloaded VM - a SUSE Linux system that includes Teradata Studio - but Express only which from what I can t...
649925 Jan 2016 @ 01:46 PSTkallu2020ToolsTeradata Python ModuleNp found the answer. Supported Teradata Database Versions • 13.00 • 13.10 • 14.00 • 14.10 • 15.00
649825 Jan 2016 @ 11:45 PSTcmorrisxToolsTransitioning from SQL Assistant to Studio ExpressWhen can we expect SSO to work in Studio Express? I get a pretty long exception error when I try to use Kerberos and no username/password. In another thread  you suggested modifying the r...
649725 Jan 2016 @ 11:40 PSTkallu2020ToolsTeradata Python ModuleIs this rest service/Rest API available from Td15 onwards? Could you please confirm.   Thanks, Kiran
649625 Jan 2016 @ 11:37 PSTcmorrisxToolsTeradata Studio products - choosing the right client toolA registry hack to get Kerberos to work is not an acceptible solution as a lot of users do not have write access to the registry. WHen will this be fixed???? We need true SSO support
649525 Jan 2016 @ 10:54 PSTthakurrabikant@gmail.comConnectivityAccess External Data - A Table UDFWe have installed the new version on DbLink and it is woking fine. But it is shuting down automatically. We need to start every time(That we should do). Not sure what would be the reason to shut do...
649425 Jan 2016 @ 05:24 PSTALovick3ApplicationsIn-database analytics with TeradataRAlthough TeradataR is no longer supported, there is new in-database functionality for R in TD 15.10 http://www.info.teradata.com/HTMLPubs/DB_TTU_15_10/index.html#page/SQL_Reference/B035_1147_151K...
649325 Jan 2016 @ 01:59 PSTfirstjcarrie's blogNew opportunities for statistics collection in Teradata 14.0Carrie, one more question - would the same rules apply volatile tables and would the syntax be: - COLLECT STATISTICS         INDEX ( COLUMN1, COLUMN2 )  ...
649225 Jan 2016 @ 01:45 PSTfirstjcarrie's blogNew opportunities for statistics collection in Teradata 14.0Thanks Carrie, very much appreciated
649122 Jan 2016 @ 11:11 PSTPaulSinclairPaul Sinclair's Blog on PartitioningTeradata ColumnarCPPA and CPPI require Teradata 15.10. CPNoPI was available starting in Teradata 14.0. CP may require a license and to be enabled by a support representative in order to use it. If you...
649022 Jan 2016 @ 10:38 PSTsuhailmemon84Paul Sinclair's Blog on PartitioningTeradata ColumnarHi Paul, Is CPPA only supported from 15.10? We're on TD 15.0 and when I try to run: CREATE TABLE Orders (o_orderkey INTEGER NOT NULL, o_custkey INTEGER, o_orderstatus CHAR(1) CASESPECIFI...
648921 Jan 2016 @ 02:44 PSTcarriecarrie's blogDatabase Tasks that Run on the Parsing Engine I don't think there is any "ideal" parsing time, at least that I have heard of one.  Parsing time depends on many things, such as the type of work that is undergoi...
648821 Jan 2016 @ 07:38 PSTmani.atkuricarrie's blogRecommended Dictionary Statistics to Collect in Teradata 14.0 COLLECT STATISTICS COLUMN (SUBSTRING((TRANSLATE((TVMName )USING UNICODE_TO_LOCALE WITH ERROR )) FROM (1) FOR (30 ))) AS ST_200113065866_0_tvm ON DBC.tvm COLLECT STATISTICS COLUMN (SUBSTRING((T...
648720 Jan 2016 @ 12:16 PSTHarshaKudumulacarrie's blogDatabase Tasks that Run on the Parsing Engine Hi Carrie, Thanks always for the valuable information. As per my understanding, the ideal parsing time for any query on normal system should always be equal or less than 30 Seconds. Please correc...
648620 Jan 2016 @ 10:43 PSTfgrimmerToolsTransitioning from SQL Assistant to Studio ExpressManish, I am not an expert on SQLA. Please try posting your question to the Tools Forum. thanks.

Pages