#DateForumTypeThreadPost
3611 Mar 2015 @ 06:02 PDTDatabaseReplySQL Function regarding CHAR vs VARCHARHi Martijn, This is because VARCHAR accomodates the integers and CHAR doesn't. Thanks.
3511 Mar 2015 @ 05:17 PDTData ModelingTopicMax column length in ERWin for Teradata 14.10 columnsI have ERWin v9.5 std edition and working with Teradata DB v14.10. This DB version allows the column length to be 128 characters. I am trying to reverse engineer a Teradata table in ERWin where c...
3418 Oct 2013 @ 12:10 PDTDatabaseReplyJoin index and table header change- how are they related ?Table header of the base table is locked to update table's version number. If you see the 'Version' column in TVM , it should be incremented by 1. Per manuals, Table's structu...
3312 Sep 2013 @ 05:37 PDTToolsReplyJoin Index - Blocking sessionsIf you were using bulk load ie MLOAD/FLOAD scripts to load these 3 base tables then you were left with no other option but to drop JI and recreate after loading. :) In the scenario you have descri...
3208 Sep 2013 @ 01:00 PDTToolsReplyFast Export and MLoad It is never possible to load tables row by row in the way you want as MLOAD and FastExport have block level operations. Also file should be completely ready to laod in order to start MLOAD. You ca...
3103 Sep 2013 @ 05:53 PDTDatabaseReplyBig table - very big table joinThis would go for HASH join where smaller table (REP) is duplicated on all AMPs based on hashing CUST_KEY. If it is a frequently used query, then creating hash index on REP table is a good op...
3002 Sep 2013 @ 10:33 PDTGeneralReplyExporting around 3 TB of data from TeradataHave you tried TPT export? This would enhance the performance of exporting huge data compared to standalone Fexport script. You would be able to deffine multiple instances based on your system con...
2917 Apr 2009 @ 02:39 PDTUDAReplysomething about Teradata Warehouse 7.1jfyi
2825 Jul 2008 @ 03:22 PDTTrainingReplyHow many Certified Teradata Masterscourtesy td.com...http://www.teradata.com/t/page/178254/index.html
2724 Jul 2008 @ 02:10 PDTDatabaseReplyPerform Multiplication of all the values for a ColumnA small change in the above query..select (-1**dt3.c3) * dt1.c1*dt2.c2 as product_col from((select COALESCE(exp(sum(ln(abs(a)))),1) from au.dh where a <0) dt1 (c1)join (select exp(sum(ln(a))) fr...
2624 Jul 2008 @ 01:02 PDTToolsReplyQuery fails using bteq but works fine with querymanChange != to <> ..it will work..
2511 Jul 2008 @ 04:27 PDTDatabaseReplyMoving data between 2 servers in TeradataWe can make use of TPT in this case if at all installed.Then we dont need to create an intermediate physical file like in FastExport or Bteq Export.
2403 Jul 2008 @ 02:11 PDTDatabaseTopicDeleting Duplicate records...Hi,I have the following records in my multiset table:- EN ENAME----- --------------- 1 AAA 1 AAA 1 AAA ...
2330 May 2008 @ 05:05 PDTTrainingReplyWhen is the certification going to change for V2R5 to R6to be more precise...http://www.teradata.com/t/page/178254/index.html
2230 May 2008 @ 03:06 PDTDatabaseReplySimple Queryi think foll is the right query...let know in case of wrong query..select * from employee a where 5 <(select employee_number from employee b where a.employee_number=b.employee_number)
2129 May 2008 @ 03:38 PDTDatabaseReplyPerform Multiplication of all the values for a ColumnHi,i created a table 'dh' in 'au' database with column name as 'A' of integer data type.Data in this column is as follows.A-10-9-612345I wrote the query, which is just an enhancement of Carlos's qu...
2029 May 2008 @ 02:11 PDTUDAReplyBad format or character?Is myvar column of varchar data type?If myvar is varchar data type then you might get this error "bad character in format or data" with error code 2621.This happens because, column being a varchar ...
1915 Apr 2008 @ 08:08 PDTToolsReplyconfiguration of PSA in demo CDI think this can be resolved by adding an entry in "host" named file. this file resides in c:\windows\system32\drivers\etc.To add an entry, read the header section of the file..it is self explanato...
1811 Apr 2008 @ 01:56 PDTDatabaseReplyTeradata InstallationI think before re-installing you need to delete all the entries in the registry as well.As the error rightly says, we must remove all the traces of the teradata installed previously.
1708 Apr 2008 @ 04:37 PDTDatabaseTopicUser Defined Type (UDT)Hi all,I have Teradata Demo installed on my machine. I tried to create UDT but it gave me " complier not available" message. Then i installed VC++ and taking the help of some threads available in t...
1603 Apr 2008 @ 04:53 PDTDatabaseReplyHelp with pulling data from IBM Mainframe into TeradataHi Yolanda,As per my knowledge, whenever we try to load vartext file, we should have all the fields as Varchar in the layout section.Also if you could remove the single quotes in your data file for...
1527 Mar 2008 @ 02:47 PDTDatabaseReplySelect into a selectHi,I also think we cant use "select" as part of the column list in select statement.I think in case of your query, we can use select as a derived table and join it with other tables to avoide cart...
1424 Mar 2008 @ 03:07 PDTAnalyticsReplyhow to generate addition row as counterHi,Create table as mentioned below and exec the foll. query.CREATE SET TABLE ,NO FALLBACK ,NO BEFORE JOURNAL,NO AFTER JOURNAL,CHECKSUM = DEFAULT(ID_COL INTEGER GENERATED ALWAYS AS IDENTITY(START WI...
1319 Mar 2008 @ 07:19 PDTToolsReplyDBCErrorCodeError code 2794 means "Mload mark duplicate insert".It means flat file you are loading in TD table, contains the duplicate primary index values.Only remedy is fix the file.More Teradata errors and ...
1217 Mar 2008 @ 08:08 PDTDatabaseReplyMultiload (out of Range error)AFAIK its a business decision which you and your client both have to take, to make sure data is getting loaded in EDW properly. what i mean to say is , for some fields you are getting out of range ...

Pages