All forum activity

#DateUserForumTypeThreadPost
5876927 Jul 2016 @ 01:29 PDTM.Saeed KhurramDatabaseReplyWhat is difference between Redistribution of rows and Duplication of small table in AMPsTeradata has only one spool space, the rows are duplicated / redistributed to spool space.
5876827 Jul 2016 @ 01:26 PDTNewbieTDDatabaseTopicNeed to get View Column derivation info from teradataHi All, I want to get all view columns derviation/definition information. Is there any way to get them. eg: my table name is - DB.ORG_Table which has 3 columns namely col1,col2,col3 i have cr...
5876727 Jul 2016 @ 01:26 PDTM.Saeed KhurramUDAReplyCollect Stats n Refresh StatsThe first thing is collect only the stats required, not all stats. It will save a lot of time and provide you performance. As stats collection after every insert will take time and prolong the bat...
5876627 Jul 2016 @ 01:23 PDTM.Saeed KhurramDatabaseReplyHelp Combing Two QueriesCan you share the DDLs of both these tables?
5876527 Jul 2016 @ 12:28 PDTabhijeetgupta29novDatabaseTopicNeed ER Modeling for Below Requirement You want to design a database to manage information on the collection of various types of taxes (stamp duty, real estate, automotive patent, gross income) by a state agency. Taxpayers are some e...
5876426 Jul 2016 @ 11:52 PDTMZhangHadoopTopicTeradata connector points to old lib when runing TPT TDCH to import from Teradata to HadoopHi everyone, I have installed Teradata connector for hadoop 1.4.4 using teradata-connector-1.4.4-hadoop2.x.noarch.rpm and I can run "hadoop jar /usr/lib/tdch/1.4/lib/teradata-connector-1.4.4....
5876326 Jul 2016 @ 10:56 PDTdrmkd17UDAReplyCollect Stats n Refresh StatsI have billions of history data in tables. The jobs do an insert/ append into these tables. Can anybody recommend what is the right time to refresh stats : After each insert/append job? At the en...
5876226 Jul 2016 @ 10:23 PDTglausonDatabaseReplyHow to Write the correct syntax for JoinHi Dieter, I have a question that is related to the question posed by rahul1987 (see above, 4 weeks ago); i.e., it arises from a large Teradata exercise that's provided by a 5-week SQL course ...
5876126 Jul 2016 @ 09:22 PDTkamlesh114DatabaseReplyWhat is difference between Redistribution of rows and Duplication of small table in AMPsThank you Sachin. 2nd point is also correct ? where TD duplicate the entire table (small table )on all AMPs. And also please tell me when the rows are redistributed or duplicated then where ...
5876026 Jul 2016 @ 06:56 PDTtxrob74GeneralReplyHow to search multiple columns for specific textTo further clarify I have   Select cm# from cm_databse where 'dl123' in (id1, id2, id3)   But I get a syntax error    
5875926 Jul 2016 @ 06:47 PDTtxrob74GeneralReplyHow to search multiple columns for specific textI a m look for something like where id1 or id2 or id3 = 'dl123'
5875826 Jul 2016 @ 05:24 PDTsandi99DatabaseTopicHelp Combing Two QueriesHi there - very novice at SQL.  Looking to combine two queries and not sure how to go about. I am trying to add company_name to Query 1.  company_name is in Query 2 which uses two en...
5875726 Jul 2016 @ 04:09 PDTFredDatabaseReplyTPT ODBCSee http://knowledgebase.progress.com/articles/Article/3556 for information regarding this error.    
5875626 Jul 2016 @ 03:10 PDTM.Saeed KhurramGeneralReplyHow to search multiple columns for specific textDo you mean you want to write something like: where cm# IN (1,3) OR Where Id1 = 'dl123' or id2 = 'dl321' or cm# IN (1,3) Please clarify.
5875526 Jul 2016 @ 02:57 PDTM.Saeed KhurramDatabaseReplyhow to handle Null values in FASTloadCan you try using a single space empty string  in all these nullif literals? 
5875426 Jul 2016 @ 01:51 PDTsrikanthmatta44GeneralReplyFinding the Sub String Between < and >Hello- What if I want between '(' and ')'?  I tried to use the same logic but did not work.  I am getting paranthesis in the result set. I appreciate your help. Thanks ...
5875326 Jul 2016 @ 01:31 PDTmissgateToolsReplyExport with header using TPTAs Steve says there are not an attribute to get file with columns header. Many times i used one of two options: 1 - Use OS COMMAND to concatenate two files, headers file and export file. On windo...
5875226 Jul 2016 @ 01:16 PDTlr_shpDatabaseTopicOLAP Function for Recurring DeductionHi All,  I'm trying to come up with an OLAP function solution to a units deduction problem for various groups.  We have 3 vendors that receive product orders each week. Some weeks a...
5875126 Jul 2016 @ 12:18 PDTjohn9DatabaseTopicTPT ODBCHi All  - I have been struggling to fix my ODBC TPT script.Here is the back ground: My teredata version is 14.10 I am trying to extract the data from AS400 (accessed through DB2 client...
5875026 Jul 2016 @ 11:41 PDTFredDatabaseReplyhow to handle Null values in FASTloadFastLoad NULLIF supports a maximum of 80 characters.
5874926 Jul 2016 @ 11:28 PDTfeinholzToolsReplyExport with header using TPTThe Export (and SQL Selector) operator(s) is/are not capable of extracting out the column headers from the database.  
5874826 Jul 2016 @ 11:17 PDTFredDatabaseReplyDifferent Column Orders for Stats Recommended by DIAGNOSTIC HELPSTATS? Starting with TD14.0, the order given for COLUMN stats is respected. If columns that are being used in single-table filter predicates are listed first, followed by columns that are used for join cr...
5874726 Jul 2016 @ 10:23 PDTsrivigneshknToolsTopicExport with header using TPTHi, I am using TPT export for doing data export from TD to a file and want to include column headers to the generated file. I would like to know if there are any attributes that is included with ...
5874626 Jul 2016 @ 10:18 PDTsrivigneshknToolsReplyCtrl-A delimiter with TPT Export.Thank you Steve,  Alternatively, i tried specifying CTRL-A in the Textdelimiter attribute by giving CTRL-V CTRL-A through vi editor and this is able to export data with CTRL-A delimiter. VAR...
5874526 Jul 2016 @ 10:13 PDTMONCALIERITeradata StudioReplyTeradata Studio Express - OLD VersionsThanks Francine.  

Pages