#DateForumTypeThreadPost
2830 Aug 2016 @ 10:36 PDTToolsReplyCan TTU 14.10 on Linux connect on a15.10 RDBMSInformatica 9.6.1 probably? Some story here. TTU 14.10 is 2 versions upward compatible (excluding new features in newer versions ofcourse). So 15.00 and 15.10 are supported, but 16.00 (not out yet)...
2719 Aug 2016 @ 01:24 PDTGeneralReplyDisable Logging in TPTThe script/program that calls the TPT also specified the logging and the detail of the logging. You need to look into that.
2617 Aug 2016 @ 03:54 PDTTeradata StudioReplyHow to solve the error "Creating connections to local Teradata Database has encountered a problem" ?The first user on the database is dbc/dbc. Is that what you are looking for?
2516 Aug 2016 @ 10:54 PDTDatabaseReplyCreating a snapshot from Type 2 behaviourI remember that the INTERVAL function could be usefull. This prevents a product join to your calendar dimension. We ended up with making the tables physical for maximum performance and to make it e...
2411 Aug 2016 @ 11:32 PDTDatabaseReplyCapturing MAX marks for Each Student when the MArks are in ColumnsSELECT GREATEST(50,100,70)
2311 Aug 2016 @ 11:32 PDTDatabaseReplyCapturing MAX marks for Each Student when the MArks are in ColumnsWHAT does not work. Given the example data for id 4 the statement returns 100:  
2209 Aug 2016 @ 11:05 PDTDatabaseReply Merge the continuous rows with date range( sequential rows should merge)this topic did help me in the past: https://forums.teradata.com/forum/general/need-help-merging-consecutive-and-overlapping-date-spans i ended up using dnoets olap function (how typical). however...
2109 Aug 2016 @ 10:53 PDTData ModelingReplyAJI creation for a single high priority querySAP data... Microstrategy... naming convention like that of TAS solution from Teradata... cool! is a sparse ji also a solution? on spend = Y with a partitioning on fiscal period name. by the way:...
2008 Aug 2016 @ 11:09 PDTGeneralReplyImprove performance on an analytical query , mulitple columns using same set of partitionsAnd what would a simple sum/group by do? I sometimes think that an analytical fuction is executed seperately. It is cool stuff, sometimes performs like crazy. But in some case it doesn't.
1906 Aug 2016 @ 04:57 PDTDatabaseReplyUser's DDLMaybe, but I did not check, the new Teradata Studio can generate the SQL for you.
1806 Aug 2016 @ 04:55 PDTTeradata Database on VMWareReplyODBC on Teradata on VMIf I remember it correct tdicu is listed as a dependency for tdodbc, but I never installed it. tdicu is for some language dependend messages. We stayed on English and no problems so far.
1721 Jul 2016 @ 05:28 PDTDatabaseReplyProblems installing in TDExpress15.00.02_Sles11_40GBAfaik is Data Services most of the time installed on Windows. The DS Designer tool runs only on Windows?
1619 Jul 2016 @ 10:42 PDTViewpointReplyMoving Data from One Viewpoint Server to a new Viewpoint ServerIf you want to move everything: move everything in the /backup folder to the new server in the /backup folder there and restore the data/configuration. The restore process is described in chapter 6...
1518 Jul 2016 @ 02:10 PDTDatabaseReplyHow to CREATE TABLE(copy) without any index and parititions present on source tableI stand corrected ;-)
1418 Jul 2016 @ 02:08 PDTConnectivityReplyconnecting to Teradata from Oracle DB &SAP BWYes this is possible with a product from the Teradata SAP COE. TVAS/TELS the product was called. But you need to contact them.
1315 Jul 2016 @ 08:39 PDTToolsReplyTPT Export vs Fast ExportThey are the same except Fast Export is legacy and TPT is the future.
1215 Jul 2016 @ 08:38 PDTDatabaseReplyHow to CREATE TABLE(copy) without any index and parititions present on source table CREATE TABLE UDWETLWORK_D5.MBR_COV_TST_tmp AS ( SELECT * FROM UDWETLSANDBOX.ADJD_MCE_TST ) WITH NO DATA WITH PRIMARY INDEX (FIELD1, FIELD2);   This should work
1113 Jul 2016 @ 11:25 PDTToolsReplyTPT deadlock Issue.15.00/15.10 has several improvements around locking for TPT: dbc.accessrights has another PI and there is the partition level locking. I strongly suggest that you familiarize yourself with the new...
1011 Jul 2016 @ 12:34 PDTViewpointReplyViewpoint SUSE CompatibilityVP 15.10 is compatible with SLES10. VP15.11 is only SLES11. Why not upgrade to SLES11/VP15.11?
922 Jun 2016 @ 01:02 PDTAnalyticsReplyCPU disk ratio error from 'like' statementsProbably the like statements results in a full table scan and thus a high io/cpu estimate. Here the effect is a bit explained: http://www.dwhpro.com/teradata-indexing-2/
816 Jun 2016 @ 01:35 PDTConnectivityReplyODBC performance on LinuxNo-one?
710 Jun 2016 @ 12:01 PDTDatabaseReplySeeing Junk character when inserting hyphen (-)The utf-8 session recommendation I knew, but the detailed explanation why in this case it is going wrong... wow. Beside that: don't query DBC.TABLES, but query DBC.TABLESV if available on your...
609 Jun 2016 @ 11:58 PDTDatabaseReplyDATE - 'SELECT DATE' RETURNS AN INCORRECT DATESELECT DATE returns the current date from the database/OS. I guess your VM date/time is not up-to-date...
509 Jun 2016 @ 11:57 PDTDatabaseReplyCurrent date as column name in select querySet the alias between double quotes: AS "CURRENT_DATE"
408 Jun 2016 @ 11:12 PDTDatabaseReplyMulti-level partition or differently partitioned JI?Hi Dieter, The reporting guys are complaining that it is "difficult" for them to present a year-week number in the report, and in the SQL select on the date... So changing the SQL from t...

Pages