#DateForumTypeThreadPost
5113 Jan 2016 @ 10:07 PSTDatabaseReply Arcmain Could you provide more detail (complete log) to analyze further.
5016 Dec 2015 @ 01:33 PSTToolsReplyHow to call TPT scripts from Shell ScriptsSet tbuild directory path in .bash_profile or use fully qualified path in the shell script e.g /opt/teradata/client/15.10/bin/tbuild Thanks!
4909 Dec 2015 @ 01:53 PSTToolsReplyTPT Oracle JDBC connectionThanks for the followup Steve.  
4808 Dec 2015 @ 12:06 PSTToolsReplyTPT Oracle JDBC connectionThanks Steve and Vishnu. As you both pointed I was using wrong non-branded drivers. ODBC connectivity to Oracle works after repointing ODBC.ini dirver to 64bin "_Tora27.so" Was referrin...
4703 Dec 2015 @ 07:26 PSTToolsReplyTPT Oracle JDBC connectionThanks Vishnu. Forgot to mention earlier, we tested the ODBC connectivity after setting both env variables export ODBCINI=/home/xxxxxx/odbc.ini export LD_LIBRARY_PATH=/opt/teradata/client/...
4602 Dec 2015 @ 08:11 PSTToolsReplyTPT Oracle JDBC connectionWe tried using default ODBC driver from TD 15.10 to connect Oracle referencing below library files. Test case failed with following error. I believe 15.10 ODBC driver is trying to refer DataDirect...
4502 Dec 2015 @ 07:38 PSTToolsReplyTPT Oracle JDBC connectionThanks for the clarification Steve
4402 Dec 2015 @ 01:31 PSTExtensibilityReplyJava interface to TPT OPERATORSDo we have any change in Teradata position to provide Java interface for TPT in recent and upcoming release. Thanks! TDThrottle  
4302 Dec 2015 @ 01:23 PSTToolsReplyTPT Oracle JDBC connectionHi Steve, Does Teradata TPT support connectivity to Oracle Database using JDBC in any of the recent releases. If no, ODBC is the only solution available to connect other Relational database from T...
4204 Nov 2015 @ 03:15 PSTDatabaseReplyHow to reduce duplicate Access Rights entries from Teradata database This script helps to list ALL duplicated Direct grants in Accessrights table. LOCKING ROW FOR ACCESS SELECT A.Username AS Username , A.Databasename AS Databasename, A.Accessright AS Accessr...
4104 Nov 2015 @ 03:12 PSTDatabaseReplyParameterization of Layout fileYes we use TDWallet. Teradara userid is authorized from the designated ETL/Application server without password. Thanks.
4004 Nov 2015 @ 03:08 PSTDatabaseReplyQuery runs for 5 hoursTry creating a temporary table and do the join so multiple OR condition is eliminated. CREATE MULTISET VOLATILE TABLE E_TBL_LIST ( SYS_ID VARCHAR(10), ACCT_TYPE_CD INTEGER ) PRIMARY INDEX ...
3916 Aug 2015 @ 07:13 PDTDatabaseReplyTranspose of dataIf your using TD 14 and above, use TDSTATS.UDFCONCAT for transpose column to row select year, week, date, type, tdstats.udfconcat(count)) from table_name; Thanks!!
3811 Aug 2015 @ 06:14 PDTDatabaseReplyspool space errorCheck for the step/join condition the query spool out and analyze the column/data further: a. Rows per value (use HELP STAT). Less number of RPV will lead selective AMP's are used during data ...
3711 Aug 2015 @ 05:34 PDTToolsReplyError 2673 with TPT from Wherescape Hi Johan, Can you check bicc_store.L_AR1_GL_DETAILED_DATA_E1 to know the errorcode/reason behind skipping this records.   TPT completed with Warning 4 and loaded all data into E...
3611 Jul 2015 @ 07:52 PDTDatabaseReplyUDF You can build and distribute C/C++ UDFs without revealing the source code to users or purchasers.   Example: 'CS!myudfsource!C:\mycode\myudfsource.c'   CI!name_...
3507 Jul 2015 @ 01:08 PDTViewpointReplyVery long running queries impacting performance due to frequent re-classificationSuspect wrong/stale stats and OLAP function is driving through wrong estimates. an you share rough figure on number of AMP's and the piece of code using OLAP function. Also, the explain plan...
3407 Jul 2015 @ 12:39 PDTConnectivityReplyCannot find terasso libraryWhat is the client version you use? Teradata now bundle all TTU packages in a single suite. Uninstall all available tools and utilities from your windows system and install using recent TTU packag...
3307 Jul 2015 @ 10:37 PDTDatabaseReplyTASM ReportingAlso, you can built reports based on TASM data/info using System Performance Monitor and Production Control API http://www.info.teradata.com/HTMLPubs/DB_TTU_15_00/index.html#page/General_Refe...
3206 Jul 2015 @ 06:31 PDTToolsReplyTeradata tptHi Abhishek, For TPT sample scripts refer $TERADATA_HOME/Teradata Parallel Transporter/sample/userguide from you client system. Thanks!!
3106 Jul 2015 @ 05:17 PDTHadoopReplyCan we recommend TDCH for Extract-Load processThanks Tom and Todd for sharing expertise inputs. @Tom Yes, we are Teradata customers will submit an enhancement request to "Teradata At Your Service" for TDCH internal.fastload to su...
3004 Jul 2015 @ 04:02 PDTHadoopTopicCan we recommend TDCH for Extract-Load processHi, We all knew TDCH use JDBC connectivity to establish connectivity between Hadoop and Teradata and to move data across these platforms. My question is using JDBC, if FastLoad operation is inter...
2924 Jun 2015 @ 08:14 PDTDatabaseReplyGenerate SurrogateKey with a huge tableOption-2: Use ETL approach 1. Create a copy of t1 for table ids 500 to 1000 2. Delete t1 for table ids 500 to 1000 3. Update <t1-copy> using t2 4. Insert <t1-copy> back to t1 You c...
2824 Jun 2015 @ 07:42 PDTDatabaseReplyAn owner referenced by user does not have REFERENCES accessWith Creator privilege, you should be able to grant Reference privilege to others. GRANT REFERENCES (reference columns) ON MYDB.PRODUCT TO DBUSER1; /*Only on references columns */ Thanks!!  
2723 Jun 2015 @ 08:06 PDTToolsReplyReceiving Failure 2673 The source parcel length does not match data that was defined while importing using BTEQ When using fixed length input file, variable declaration should match the table layout and inputfile characters.   133232      mallik         &nbs...

Pages