#DateForumTypeThreadPost
1705 May 2016 @ 05:48 PDTDatabaseTopicBad data in table , need suggestion to isolate the problemHello, I have a unique situation here and I need your suggestions help to achieve it. I have close to 10000 tables where I have a timestamp fields which (probably) has bad data(long story behind ...
1604 Feb 2016 @ 10:20 PSTDatabaseTopicUnstable explain planHi, We have observed weird behavior in the Teradata environment , Basically some of the SQLs suddenly starts running slow and when checked and compared to the previous explain plan for which it ra...
1525 Jul 2014 @ 01:14 PDTConnectivityTopicConnecting to Teradata using PythonHi Guys,   I am strugling to connnect teradata usning python. I have a user ID and password in text file and i need to read the test file to connect to teradata.. could you please help me wi...
1411 Jun 2014 @ 10:38 PDTDatabaseReplyHow to read VARBYTEWe have TD 13 verion. Its a text that i want to present into a readable format, currently its in VARBYTE.
1310 Jun 2014 @ 05:02 PDTDatabaseTopicHow to read VARBYTEHi,   We have a table in which we have a field which is defined as VARBYTE.  could you pleae let me know if there is a way to read the VARBYTE data in readable format ?
1210 Apr 2014 @ 11:16 PDTDatabaseTopicEmail from BteqHi,   I would like to create a bteq script which will read data from a table and attach it as a .Xml or Flat file to am email and that email will be sent to specified users. Is this possibl...
1101 Jan 2014 @ 08:02 PSTGeneralReplyIssue with MLOAD Error tablesHi Raja, How to check the control file? That wil be internally generated by INFA..
1030 Dec 2013 @ 09:50 PSTGeneralTopicIssue with MLOAD Error tablesHi, We Informatica loading data into TD using MLOAD connection. Here we have Error limit as '0'. now we have seen a problem where in data is getting rejected but still the informatica jo...
902 Dec 2013 @ 06:45 PSTDatabaseTopicNeed guidanceHi,   I have a bteq job which is running MERGE on fact table. there is a JI bult on my fatc table.   while executing the MERGE suddenly the query started failing with spool space err...
820 Nov 2013 @ 08:08 PSTDatabaseReplyNeed help in understanding Teradata's behaviourHI Team,   If we add MAX to one of the column we get different result, which is actually wrong... and when we remove the MAX and add that to group by we get correct results.   any ide...
720 Nov 2013 @ 07:14 PSTDatabaseReplyNeed help in understanding Teradata's behaviourSorry i didnt get the point :   another thing which we noticed is : if we make changes as below , we get complete 100 records   select A, b, c, d, e, F ( select a...
620 Nov 2013 @ 06:09 PSTDatabaseTopicNeed help in understanding Teradata's behaviourHi Team, we  have below query , where we are geting stange results, if i just run Inner Query - A alone, i get lets say 100 records but when i run complete query , i.e. lefter outer join wi...
518 Nov 2013 @ 07:26 PSTConnectivityReplyTeradata connectivity with SAPso the SAP DS will write into teradata?
418 Nov 2013 @ 04:58 PSTConnectivityTopicTeradata connectivity with SAPHi Team,   I need information on below points , we are looking to pull data from SAP ECC system into teradata:   Can we connect using Teradata , directly to SAP or SAP BW ? ...
331 Oct 2013 @ 11:41 PDTDatabaseReplySystem utilization/ System health queriesIn viewpoint i dont see all these things.. is there any setting i would need to do to see past utilisation ?  
231 Oct 2013 @ 11:21 PDTDatabaseTopicIdentifying HOTAMP / COLD AMPHi,   I would like to find out if data is stored in HOT AMP or in COLD AMP, is there a way to find out that? Is there a way to move data from Cold Amp to HOt amp?      
119 Oct 2013 @ 12:18 PDTDatabaseTopicSystem utilization/ System health queriesHi,   I am new to Teradata, i am looking for some of the important queries which will provide me current and past system utilization. Ex. want to know which user consumed max resources in l...