#DateForumTypeThreadPost
2426 Mar 2014 @ 04:59 PDTDatabaseReplySpace in the databaseI do not have data in my table still I see the Current Perm on the higher side.  Why is this happening? since there is no data in the table the skew factor is 0. My table is Multiset table w...
2309 Oct 2013 @ 06:39 PDTDatabaseReplyHow to convert JAN 1, 2007 12:00:00 AM into timestamp format 'YYYY-MM-DDBHH:MI:SS' ???Hi Saeed, The source is actually a csv file. We have loaded it to teradata table with varchar() data type. Now we need to load it to the target table with data type Timestamp(0) that is also...
2209 Oct 2013 @ 04:43 PDTDatabaseTopicHow to convert JAN 1, 2007 12:00:00 AM into timestamp format 'YYYY-MM-DDBHH:MI:SS' ???I have data coming from source as JAN 1, 2007 12:00:00 AM . In my target I have the column with datatype Timestamp(0). How to cast JAN 1, 2007 12:00:00 AM to format 'YYYY-MM-DDBHH:MI...
2120 Sep 2013 @ 03:10 PDTDatabaseTopicHow can I load special character A^ ie A cap in teradata?I have data in Oracle like this 'A^'. Actually ^ should go on top of 'A', i.e I have A cap in one of my columns in Oracle. When I loaded to Teradata the row got rejected. So I have...
2020 Sep 2013 @ 03:04 PDTDatabaseReplyShould I create staging tables with PI or shall I create NOPI tables?Thank you..Saeed and Raja. I am using TPT and NOPI tables as staging tables. I was in a doubt that NOPI tables will increase skewness but it looks fine. cheers :)
1919 Sep 2013 @ 10:11 PDTGeneralTopicShould I create staging tables with PI or shall I create NOPI tables?My source is Oracle, and my staging tables are in Teradata. Should I create staging tables with PI or shall I create NOPI tables? What is recomanded? Thanks, Sayak.G
1819 Sep 2013 @ 10:09 PDTDatabaseTopicShould I create staging tables with PI or shall I create NOPI tables?My source is Oracle, and my staging tables are in Teradata. Should I create staging tables with PI or shall I create NOPI tables? What is recomanded? Thanks, Sayak.G  
1730 Jul 2013 @ 11:18 PDTGeneralTopicTEO-122 dump requiredHi All, If anyone is having TEO-122 dump, please share it. I have to clear it by this month and I am not sure of the questions. If you have please send it to 'sayakghosh7@gmail.com'. Ple...
1630 Jul 2013 @ 11:12 PDTTeradata StudioReplyRequire TERADATA EXPRESS STUDIO for 64bit Windows 7...both Client and Server....plz helpThank you for the reply..Actually I want to install teradata in my system of 64 bit(both client and server). I guess its not possible at this moment without VMwire. But if you have something plea...
1503 Jul 2013 @ 10:30 PDTTeradata StudioTopicRequire TERADATA EXPRESS STUDIO for 64bit Windows 7...both Client and Server....plz helpHi all, I want to install TERADATA EXPRESS STUDIO in my personal laptop having 64bit windows 7.  Can anyone please provide me the same. I want both Client and Server without VMware. Regards...
1421 Jun 2013 @ 04:23 PDTDatabaseTopicLDAP authentication for Teradata Express Edition 13I have installed Teradata Express edition 13 in windows XP. I have a LDAP server as well. I want to log in to teradata using LDAP authentication. Please suggest me the steps to achieve the require...
1321 Jun 2013 @ 04:22 PDTTeradata StudioTopicLDAP authentication for Teradata Express Edition 13I have installed Teradata Express edition 13 in windows XP. I have a LDAP server as well. I want to log in to teradata using LDAP authentication. Please suggest me the steps to achieve the require...
1221 Jun 2013 @ 04:20 PDTPrivate Forum
1121 Jun 2013 @ 04:19 PDTTeradata ApplicationsTopicLDAP authentication for Teradata Express Edition 13I have installed Teradata Express edition 13 in windows XP. I have a LDAP server as well. I want to log in to teradata using LDAP authentication. Please suggest me the steps to achieve the require...
1021 Jun 2013 @ 04:17 PDTPrivate Forum
921 Jun 2013 @ 04:09 PDTCloud ComputingReplyTD Express 14 and LDAP authenticationHi Tom, Please help me to make LDAP authentication in teradata express edition 13. I have installed teradata express 13 in my system. I have LDAP server as well. I want to make LDAP authenticatio...
812 Mar 2013 @ 02:53 PDTTeradata ApplicationsTopicHow to optimize the query? The Explain plan is given below. Its showing no more spool space.Explain SELECT LDA_RDM_JPMCC_NM_ADDR_MTH_V.CUSTOMER_OBJECT_ID, LDA_RDM_JPMCC_NM_ADDR_MTH_V.ACCOUNT_NUMBER, LDA_RDM_JPMCC_NM_ADDR_MTH_V.WORK_PHONE_NUMBER, LDA_RDM_JPMCC_NM_ADDR_MTH_V.SRC_SYS_CD...
710 Dec 2012 @ 04:38 PSTTeradata ApplicationsTopicQuery to get the first name , middle name and surname from a given nameLet a name be 'Sayak chandra venkateshwar' I want the output as first name: Sayak second name: chandra surname : venkateshwar
616 Oct 2012 @ 07:08 PDTTeradata ApplicationsReplyQuery to convert Decimal(15) to date format 'yyyy-mm-dd'Thanks Ulrich......its working! @Satyaki-- sorry for incomplete info. its teradata 13...!
524 Sep 2012 @ 05:10 PDTTeradata ApplicationsTopicQuery to convert Decimal(15) to date format 'yyyy-mm-dd'Can anyone help me with the query to convert a decimal eg (19890523) to date format (1989-05-23)....
411 Sep 2012 @ 06:52 PDTTeradata ApplicationsTopicTo find if the column is notnull, if the column contains ( , ,'',-), if the column is valid decimal(15) in a single query we want a single query for checking 1. if the column is null or not 2. if it is not null then we should check that it doesnt contain  , - ''  3. if the above 2...
305 Sep 2012 @ 07:40 PDTTeradata ApplicationsReplyBteq script required to validate record count of Source and target table. Thank u....dnoeth & Babbi......it worked...cheers...!
204 Sep 2012 @ 10:16 PDTTeradata ApplicationsReplyBteq script required to validate record count of Source and target table. I have 3 sources and a target with 3 instances of it. I want a post session failure, i.e. after the session succeds, if we find there is a mismatch in record count of source and target, then the...
104 Sep 2012 @ 07:38 PDTTeradata ApplicationsTopicBteq script required to validate record count of Source and target table. I have a source and a target. I want to make a post session failure command based on the record count of my source and target tables. Thanks