All comment activity

#DateUserWhereItemComment
643505 Jan 2016 @ 10:31 PSTdnoethÜber SQLHow to simplify your statistics collection with a queue tableHi Kevin, this queue approach was based on TD13/13.10, but my StatsInfo query changed in TD14, I removed some columns, see New StatsInfo query for TD14 for more details. For TD14 it is ...
643405 Jan 2016 @ 10:21 PSTktewksburyÜber SQLHow to simplify your statistics collection with a queue tableDieter,  I was just found your new documents on the statsinfo (from above link to statsinfo view), but with these changes how would you implement a change to the insert into the queue table? ...
643305 Jan 2016 @ 09:31 PSTktewksburyÜber SQLHow to simplify your statistics collection with a queue tableSorry, also samplesize column was missing from the statsinfo view as well   Kevin
643205 Jan 2016 @ 09:30 PSTktewksburyÜber SQLHow to simplify your statistics collection with a queue table SELECT    CURRENT_TIMESTAMP  + (ROW_NUMBER() OVER (ORDER BY databasename, tablename) * INTERVAL '0.000001' SECOND),    dt.* FROM  (    SELECT ...
643105 Jan 2016 @ 08:59 PSTfgrimmerToolsGetting Started with Teradata Plug-in for EclipseTony, It is hard to tell what happened without a stacktrace of the error.  Maybe something to do with changing workspaces?
643004 Jan 2016 @ 08:38 PSTcarriecarrie's blogTwo Levels of Concurrency Control for Load Utilities in Teradata 13.10A utility throttle evaluates and considers delaying a utility job at the CHECK WORKLOAD END statement.  CHECK WORKLOAD END is an SQL statement that procedes the utility logon.   If a...
642904 Jan 2016 @ 08:36 PSTcarriecarrie's blogNew opportunities for statistics collection in Teradata 14.0If you wish to copy the statistics that already exist on table_A to a new table that is identical to table_A, call it table_B, the fastest and easiest way to do this is to export the stats from tab...
642804 Jan 2016 @ 08:34 PSTcarriecarrie's blogStatistics Threshold Functionality 101Laeeq,   The default settings are all zeros, your information below is correct.   The first two parameters are described above in the blog posting under the heading.   &...
642703 Jan 2016 @ 07:08 PSTrajkumar.duraiDatabaseTeradata Express 14.0 for Amazon EC2 Configuration GuideHello,   I have resgisterd for this access three weeks before. but i didn't get any confirmation email for my aws access. I have also raised another request today.   Could you ple...
642602 Jan 2016 @ 03:43 PSTericscheieToolsTeradata Python Module@aasim.nazar -  The OutParam object takes a size argument, which is the size of the buffer to allocate to receive the value of the output parameter.   Try setting this value to a value gr...
642501 Jan 2016 @ 02:05 PSTaasim.nazar@gmail.comToolsTeradata Python Modulethe Python log for above python code execution. 2016-01-01 12:00:58,261 - teradata.udaexec - INFO - Initializing UdaExec... 2016-01-01 12:00:58,261 - teradata.udaexec - INFO - Reading confi...
642401 Jan 2016 @ 01:31 PSTaasim.nazar@gmail.comToolsTeradata Python ModuleHi,    I have installed teradata python module with python 3.5.1 version. I'm calling a teradata SP that return CLOB and some VARCHAR parameters. The SP in out parameters are shown b...
642331 Dec 2015 @ 02:34 PSTDiEgoRToolsTeradata Python Modulequick and dirty way to upload massive data to Teradata with Fastload from Pyton. Feel free to improve it. Replace the .LOGON $TDPID/$$tdwallet(u),$$tdwallet(db_name); with the one you would other...
642231 Dec 2015 @ 01:41 PSTDiEgoRToolsIntroducing Teradata WalletCan the Terdata url be substituted by $tdwallet(td_url)? td_url being tdpid.mycompany.com (it works like this) so the logon string would look like this: .LOGON $tdwallet(db_url)/$tdwallet(u),$...
642130 Dec 2015 @ 03:44 PSTTDobieeApplicationsOracle BI Enterprise Edition (OBIEE) 11g Basic Configuration and Integration with Teradata AsterWhat were you doing when you got the error?  If you are trying to import metadata it won't work:  OBIEE cannot import Aster metadata. An error is displayed during the “import&rd...
642029 Dec 2015 @ 11:29 PSTchaitanya.amudalapallicarrie's blogTwo Levels of Concurrency Control for Load Utilities in Teradata 13.10Hi Carrie, Are the sessions in RESPONDING state considered for the Utility Throttle? Does the sessions in RESPONDING state have any impact on the delay queue due to TASM throttles?   Pleas...
641928 Dec 2015 @ 01:41 PSTsaifcarrie's blogNew opportunities for statistics collection in Teradata 14.0Hi Carrie, I have a question. Creating new stats on modified table or copying the stats from existing table will it make any difference for time perspective? Here New stats which I am creating i...
641824 Dec 2015 @ 09:11 PSTAS140218ToolsIntroducing Teradata WalletHi, I want tdwallet to be supported by .NET provider for Teradata on Windows. Or... any alternative to encrypt password.
641723 Dec 2015 @ 03:59 PSTMarkJBrayshawcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)Thanks very much Carrie - I'll pass this on to the Informatica Team.
641623 Dec 2015 @ 05:21 PSTlakshmigApplicationsOracle BI Enterprise Edition (OBIEE) 11g Basic Configuration and Integration with Teradata AsterYes i  changed isolatin level is serializable and configured how it is in the above article , and after installed the ASter ODBC driver in the linux machine entries are changed in odbc.ini fil...
641523 Dec 2015 @ 04:11 PSTap25912ConnectivityTeradata Connector for Hadoop now availableThanks, I can now see that documentation has been updated and is relavant to v1.4 Cheers!!
641423 Dec 2015 @ 04:01 PSTap25912ConnectivityTeradata Connector for Hadoop now availableHI, Issue with importing data from teradata table which has delimiter , \r, \n in description column text which is VARCHAR(100). As a work around we are using -enclosedby '"' paramet...
641323 Dec 2015 @ 02:36 PSTlaeeq.ahmad@teradata.comcarrie's blogStatistics Threshold Functionality 101Hi Carrie, Great informative article. I am trying to find what are the default system settings [when does the system decides to collect stats ? ] In DBS control, everything by default is set to ...
641222 Dec 2015 @ 09:01 PSTcarriecarrie's blogEasing Into Using the New AutoStats FeatureLots of things change when you go from 13.10 all the way to 15.0.  So there is no simple answer to any question involving a change in performance.   You did not say if the CDR data was ...
641122 Dec 2015 @ 08:52 PSTcarriecarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)Mark,   The number of sessions used by an Informatica TPT API Stream workflow should be able to be set in the definition of the Stream connection.  I don't have direct experience in...

Pages