All forum activity

#DateUserForumTypeThreadPost
2155203 Nov 2011 @ 03:41 PDTvenugopal2705DatabaseReplyObject dependency I am not sure abt dependency even I am searching for that but you can use top down approach.....This wont work for bottom up approach SHOW sel * from tablename
2155103 Nov 2011 @ 02:18 PDTAnand.LouisDatabaseTopicActivity Count from DBC.SYSEXECSQL in a Stored Procedure   Hi, I am executing a SQL using DBC.SYSEXECSQL in a Store Procedure . Can any one suggest me way to capture the activity count of sql executed  Regards Anand ...
2155003 Nov 2011 @ 12:45 PDTAmirtharaj.uDatabaseReplyHelp required in query Pandeesh ,               Use the below query and check whether its satifying your conditions. SELECT       A.start_date, &nb...
2154902 Nov 2011 @ 10:30 PDTAmirtharaj.uDatabaseReplyFormat funciton ignored from SQL Assistant Hi,    SQL assistant has its own format for Date and timestamp values. In SQL assistant , You can't see the date output in the format specified in the query while it displays. ...
2154802 Nov 2011 @ 10:28 PDTpmurthyThird Party SoftwareTopicTeradata ODBC Connector Hi, does anyone know if it is possible to connect to the teradata database, from within a BizTalk project, using the ODBC connector for teradata. I am new to this, and unsure as to how this can ...
2154702 Nov 2011 @ 06:25 PDTTim_QiuDatabaseReplyQuestion on restoring database using Teradata Arcmain Thanks so much, Garlos.
2154602 Nov 2011 @ 02:41 PDTalexcolGeneralTopicManaging Datastage Applications for execution Good afternoon   I need your help please: Let me describe briefly the scenario to understand better my concern: In a Datastage application there are 1 sequential jobs and ab...
2154502 Nov 2011 @ 01:59 PDTK-MANToolsReplySQL Assistant 13.10 ODBC test connect Did you make sure the Service Name, User Name, and Password was all correct, in case-sensitive?
2154402 Nov 2011 @ 12:20 PDTK-MANToolsTopicConversion from type "DBNull" to type 'Integer' is not valid. Would anybody know why I would be getting this error with Teradata 13.10.0.08, and not with Teradata 12? Conversion from type "DBNull" to type 'Integer' is not valid. &...
2154302 Nov 2011 @ 12:09 PDTm.tahoonDatabaseTopicFormat funciton ignored from SQL Assistant Format funciton is kind of ignored from SQL Assistant SELECT CURRENT_TIME (FORMAT 'HH-MI-SS'); 20:56:50+00:00 SELECT CURRENT_DATE (FORMAT 'DD-MM-YY'); 02-Nov-11 ...
2154202 Nov 2011 @ 08:42 PDTCarlosALDatabaseReplyQuestion on restoring database using Teradata Arcmain Tim_Qiu:   COPY DATA TABLE (tbase) -->> Destination Table FROM (tbase) -->>Name of the table archived (source). FILE = tbase -->>Name of the file used when...
2154102 Nov 2011 @ 07:49 PDTsmeherToolsReplyFastload: Incorrect number of bytes returned from a File Read Sometime teradata behaves strangely... this error may be coming because of incorrect order of fileds in the control file. Recheck/regenerate the control file and try again. I had faced this ...
2154002 Nov 2011 @ 07:25 PDTpandeeshDatabaseTopicHelp required in query Hi, My requirement is as given below: My table contains three columns: start_date,id, prev_date -------------------------------- 1-NOV-2011,1,1-NOV-2010 1-NOV-2010,2,1-NOV-2...
2153902 Nov 2011 @ 07:09 PDTTim_QiuDatabaseTopicQuestion on restoring database using Teradata Arcmain Dears, It's my first encounter with teradata, the following question might be stupid :) I was told to use Teradata Arcmain to restore database, but I have a query for the follow...
2153802 Nov 2011 @ 05:10 PDTkashifriazToolsTopicHandling mutli-value columns in ODI   Could anybody please tell me whether we have any built-in functionality for handling mutli-value columns in ODI (Oracle Data Integrator)?  I mean, can we transform a multi-va...
2153702 Nov 2011 @ 03:14 PDTrohanpatil008DatabaseTopicNeed teradata material Hi, Can anyone please suggest me a link to a pdf which contains manual for teradata architecture, mload, fast export, tpump, fast load, amps and other teradata related stuffs. Please reply m...
2153602 Nov 2011 @ 01:12 PDTAndreasToolsReplyIssues with 'Teradata.Client.Provider.TdType' in Port of .NET Application using Teradata Client 13.11.00.01 AArkaah, You might want to take a look at the Teradata .Net Provider documentation to be found here: http://developer.teradata.com/doc/connectivity/tdnetdp/13.11/webhelp/webframe.html ...
2153501 Nov 2011 @ 07:51 PDTftshtlMarketing & CRMTopic[ARM6.4] Unable to get password from PasswordManager. Proceeding and assuming that the password is unencrypted   I try intstalling ARM6.4. Database Initialization And Migration , Install Metadata Administrator Utility And Install or Update TRM.WAR are All successfully.   When I ...
2153401 Nov 2011 @ 06:06 PDTgeo_edwardsJobsTopicAtlanta, GA - FT Senior DBA with Delta Community Credit Union   Delta Community Credit Union is hiring for a full-time Senior DBA position managing a large Teradata warehouse and a set of SQL Server application servers.  Experience in Busines...
2153301 Nov 2011 @ 12:56 PDTtjwongConnectivityTopicSQL Server linked server to Teradata specifying authentication mechanism (LDAP) Have had success establishing and using SQL Server linked server (SQL Server 2008 R2) connected to Teradata using OLE DB Provider for Teradata (Version 13.10.0.1) using native Teradata (TD2) aut...
2153201 Nov 2011 @ 12:35 PDTdvsathishkumarToolsTopicLoad Testing on Teradata Unity - Help required Hi, I am working on a POC on Teradata Unity. One of the tests we are planning to execute is to simulate huge load on the Teradata databases systems without using Unity and then repeat the sa...
2153101 Nov 2011 @ 11:08 PDTteradatatesterDatabaseReplyBest practice for backing up Teradata Table Structures (DLLs)? With a Netezza database I run one job and all the tables structures are backup to a file. Does Teradata have anything similar?
2153001 Nov 2011 @ 10:34 PDTTnewbeeDatabaseReplyTune qry Dieter , can you help me please?
2152901 Nov 2011 @ 09:25 PDTSreenathConnectivityTopicConnecting to Suse linux VMware database while on VPN Hi all, I have a problem connecting to Suse VMware image for Teradata database. It works OK at work place. But at home, when I am on VPN, I can't access the database from the Windows 7 h...
2152801 Nov 2011 @ 06:57 PDTAmykkTrainingReplyWant Teradata SQL Tutorial Hi Paresh,   Can you please send me the Teradata basic Certificate Material to amitarudra@gmail.com     Thanks  

Pages