#DateForumTypeThreadPost
72112 Jun 2014 @ 06:04 PDTDatabaseReplyDiretct User Login Vs. Query banding. Both are for security. Query Banding allows to pass parameters into sql script.   eg: SET QUERY_BAND='MSTRReportDate=20100110>=20091231;Projektf=4<56;'   ...
72011 Jun 2014 @ 08:56 PDTDatabaseReplyFinding the difference between two records in a table.Thinking of  UNION of SELECT : example pseudo: SELECT ......min(LST_RVW_DT)     over (partition by clnt_id           order by LST_TMST...
71911 Jun 2014 @ 12:12 PDTDatabaseReplyHow to read VARBYTEWhich TD version you have? Do you use FROM_BYTES function ? Maybe these links can help you? http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1145_111A/Conver...
71809 Jun 2014 @ 05:58 PDTGeneralReplyTo convert rows into columns in teradataIt would be good if you can share what you have and what do you expect.  You can refer to some links here like: http://forums.teradata.com/forum/general/teradata-pivot-function-equivalence-of...
71709 Jun 2014 @ 03:21 PDTDatabaseReplyConcatenate AND aggregate row values to columnsI m in 14. I work out this way: select customer_id, sum(product_price),tdstats.udfconcat(trim(product_code)) from db1.table1 group by 1;
71608 Jun 2014 @ 02:17 PDTToolsReplyis Teradata Query Scheduler included in TTU Release 15?Hi Paul, Is it this link you are looking? http://www.info.teradata.com/templates/eSrchResults.cfm?prodline=&txtpid=&txtrelno=&txtttlkywrd=TTU15.0&rdsort=Title&srtord=Asc&w...
71506 Jun 2014 @ 10:26 PDTGeneralReplyApproach to be implemented with the keys It is my viewpoint. There is nothing correct or not correct. But you can gauge yourself based on the flow, infrastructure, demography , homogeneous, heterogeneous sources etc etc.   ...
71405 Jun 2014 @ 08:25 PDTConnectivityReplyConnection between SSIS and Teradata DestinationIt can also be due to network issue. You can check the network simultaneausly ...ping,netstat,traceroute,telnet,ifconfig, nslookup ..... With less information, it can be due to anything. You may ...
71305 Jun 2014 @ 06:55 PDTDatabaseReplyHow to calculate a character occurance in a string in teradataIf you have strtok function then you can think of  doing something like this: select case when strtok('12/45/23/67/90/32/41/56/435/10','/',6) is not null then strtok('12/...
71204 Jun 2014 @ 10:35 PDTTeradata StudioReplyWhere to see table created in Teradata StudioIt may be that you have created the table  and pressed the button, but  it errored out and never got created too. Try to refresh. You can also double check by using select databasename,...
71104 Jun 2014 @ 10:07 PDTTeradata ApplicationsReplyIs anyone actual using Unity Source Link to read Oracle from Teradata?I was very curious when I saw this link sometime back. The reason was that Oracle has been using dblink since many years, within oracle only. http://developer.teradata.com/database/reference/unity...
71004 Jun 2014 @ 09:44 PDTGeneralReplyDisadvantages of denormalization in teradata If you can visualize the structure of data with no normalization,ist normal form, 2nd normal form... then you can realize it.   Having a wider row , may not fit the data block size....
70930 May 2014 @ 08:53 PDTToolsReplyBTEQ - show command loses formattingIt can be on the unix/linux settings. You can see someone's .profile file FOR  the settings of screen maybe. With xterm/rxvt/gterm  we can adjust with (xterm -sl 100 or some numbers...
70829 May 2014 @ 10:01 PDTGeneralReplyTD 13.10 Reference an User GuidesWhaw 13.10!!!! Please see if this link helps or has info that your require. http://www.info.teradata.com/HTMLPubs/DB_TTU_13_10/index.html Since it is only for a stored proc syntax, you can try s...
70729 May 2014 @ 03:37 PDTDatabaseReplyUnique secondary index violation errorYou could have shared more info.. about  ddl,  Indexes .... Di you check the SELECT alone without insert? Duplicates may be there.   Performance wise also it will be slow if huge...
70629 May 2014 @ 01:41 PDTDatabaseReplyTeradata Express 14 Database Installation GuideYou could have posted  under cloud-computing (http://forums.teradata.com/forum/cloud-computing). There are lots of discussions about it eg http://developer.teradata.com/database/articles...
70529 May 2014 @ 12:54 PDTAsterReplyHow does SQL, SQL-MR query works internally in Teradata aster?An SQL-MapReduce job is automatically started when you issue a query that includes an SQLMapReduce function. A GUI is there to monitor the job too. In Aster Developer Guide 6.00, these ste...
70428 May 2014 @ 04:23 PDTAsterReplyHow does SQL, SQL-MR query works internally in Teradata aster? Let me try to share my limited knowledge. I am not an expert in Aster.   You can access data stored in HDFS using Aster SQL-H. SQL-H interacts with HCatalog, a sort of metadata libr...
70327 May 2014 @ 11:29 PDTDatabaseReplyCollecting Sample StatsCollection of full table stats can be time-consuming :). If you can, maybe you can think of running them when less load on the system. It is all about planning,synergyzing etc maybe doing part by p...
70227 May 2014 @ 04:38 PDTTeradata ApplicationsReplyEasyloader data transfer issueStrange!!!! Maybe you ran easy loader in unix environment and session settings could be different. Whereas you ran TPT wizard you choose Character set etc as something else, that is right? It is ju...
70126 May 2014 @ 11:04 PDTDatabaseReplyHow display list of foreign key constraints, including WITH [NO] CHECK OPTION setting?Hi Bill, If the work is repititive and huge number of tables, then probably an automation unix script is required. Export(bteq or fastexport) ddl or sql to a file. Then in the same script run u...
70026 May 2014 @ 01:42 PDTTeradata ApplicationsReplyEasyloader data transfer issueIt looks like a data issue. You can check the source and target data and data type, comparing source and target. The error Conflicting data length for column(41) - CUSTOMER_LGD_DT. Source co...
69925 May 2014 @ 07:47 PDTDatabaseReplyAvoid all rows scan on partial varchar accessI feel that creating new table with event_id and extracts of event_id and source_key_column1 one time if it suits business requirements may help -with UPI event_id for joining back. But testin...
69824 May 2014 @ 12:07 PDTGeneralReplyTeradata PIVOT function || Equivalence of ORACLE or SQL Server PIVOT function in TeradataSimulate this if it helps you.Since you come from Oracle background, you are quite familiar with emp table. Next level you can tweak as per your requirement. Hope it helps you.   Oracle ...
69722 May 2014 @ 11:38 PDTDatabaseReplyString pattern match using regular expressionsI hope I can read Dieter's letter, since it is open :). Hope he does not mind. How about  SUBSTR(CAST(REGEXP_SUBSTR('<ABC:5419928542>', '[0-9]+') AS integer),-1...

Pages