#DateForumTypeThreadPost
77111 Jul 2014 @ 10:27 PDTTrainingReplyWhere can I get the Advanced Teradata SQL pdf documentIt does not occur to me to see Advanced TD sql. Did you see this link http://www.info.teradata.com/templates/eSrchResults.cfm?prodline=&txtpid=&txtrelno=&txtttlkywrd=TDBS15.0&rdsor...
77011 Jul 2014 @ 09:27 PDTGeneralReplyHow to use reserved key words as column namesAs Dieter suggested to avoid using keywords as it breeds bigger problems in a bigger picture. A table like calendar can be used by others.It may create problems. Also if or when porting an applicat...
76907 Jul 2014 @ 10:50 PDTToolsReplyfastload no rows applied when running script in cronWithout looking at the script can't say much. However, if you can echo (resolved unix) all variables and can see and verify. Did you try and check your objects  again ?  
76807 Jul 2014 @ 04:32 PDTGeneralReplyCould anyone please tell me how to transpose from column to rows using CASE statement in teradataWhy CASE?Case is built on business logic. Is this what you are thinking of  that if contact has @ then type of contact is  email, if contact has something like >=9 digits then mo...
76707 Jul 2014 @ 02:54 PDTGeneralReplyCould anyone please tell me how to transpose from column to rows using CASE statement in teradata How about? select cust_id,contact_type1 as contact,contact1  from TEST_123 union all select cust_id,contact_type2 as contact ,contact2  from TEST_123 union all select cust_id,c...
76606 Jul 2014 @ 10:27 PDTGeneralReplyhow to transpose rows to columns, I tried i am getting the results, but id, name, salary titles are not displayingDid you also try something like this in your query: 'id    '|| Max(Case Row_no when 1 then id else null end)  ......
76506 Jul 2014 @ 09:44 PDTToolsReplyfastload no rows applied when running script in cronWhaw!!!! Can it be that when you run your script manually, it points to a different environment and when you run through a cron it is in different environment?
76404 Jul 2014 @ 11:44 PDTGeneralReplyCould anyone please tell me how to transpose from column to rows using CASE statement in teradataCan you try something thus: select id, max (case rn when 1 then tcontact else null end) ||'-'|| max (case rn when 2 then tcontact else null end) ||'-'|| max (case rn when 3 then tcontact else n...
76304 Jul 2014 @ 10:13 PDTGeneralReplyCould anyone please tell me how to transpose from column to rows using CASE statement in teradataWhich version you are in?You can use tdstats.udfconcat . 
76229 Jun 2014 @ 08:44 PDTTrainingReplyTeradata Developer CertificationHope this link can help you. Go through each hyperlinks too. You have not mentioned your location, if possible , folks here can provide direction perchance. http://forums.teradata.com/forum/traini...
76129 Jun 2014 @ 01:12 PDTDatabaseReplyChecking for difference in StringsIn my opinion, even if there is UDF to take care of  comparison, there is chance due to data entry discrepancy that space is there among  THRID, GHERU, KFFEL, JFIEL or even space in one k...
76028 Jun 2014 @ 09:36 PDTData ModelingReplyWhat is a building block approach to building semantic data models?I feel that denormalized physical semantic layer can be much better when we form it as core or base semantic layer, serving maybe other topup semantic layers, where organizations, see that differen...
75927 Jun 2014 @ 11:51 PDTConnectivityReplyHow to Connect Teradata with Informatica ? Not lately, I did the Teradata -Informatica connection set up. Hope you have Teradata driver ready.    From Windows Control Panel.........   Open ODBC Source A...
75827 Jun 2014 @ 09:30 PDTDatabaseReplyConverting hh:mi:ss format to secondsOops!!!! yes. I did not test beyond that  :). Thanks. Appreciate a lot.
75727 Jun 2014 @ 10:23 PDTDatabaseReplyadding negative numbersDo you mean to say thus? select l_orderkey,l_orderkey + (-5) from retail.itemppi ? It works.
75626 Jun 2014 @ 09:16 PDTDatabaseReplyConverting hh:mi:ss format to secondsTry this: select cast(interval '01:55:30' hour to second) as interval second(4) )
75526 Jun 2014 @ 08:32 PDTGeneralReplyHow can we rectify spool space issues.Hi, You have not shared the details of utility name. Can you please share the script too if possible? Please paste the error too . Cheers,
75425 Jun 2014 @ 10:12 PDTGeneralReplyI have alpanumeric,character and interger values in my column,by using case i want to char values as 'C',int values as 'I'.Will this help you? http://forums.teradata.com/forum/database/numeric-or-non-numeric-values
75325 Jun 2014 @ 09:46 PDTGeneralReplyTeradata statsOur great Carrie has written s many blogs. For example you can see this one. http://developer.teradata.com/blog/carrie/2013/02/statistics-collection-recommendations-teradata-14-0
75225 Jun 2014 @ 09:10 PDTGeneralReplyCould anyone please tell me when Global temporary tables and VTT comes into picture in Real time.Think of few  scenarios say when you need statistics. Each and every object in DB has its own unique feature. We cannot integrate easily with derived tables when we have series of queries in o...
75125 Jun 2014 @ 09:05 PDTTrainingReplyTeradata 14 Basis certificationThis link below has many sub links. You can check the FAQs. Each link leads to other links too. Hope it helps. http://forums.teradata.com/forum/training/terdata-certification-in-india
75025 Jun 2014 @ 08:45 PDTGeneralReplyCould anyone please tell me when Global temporary tables and VTT comes into picture in Real time.   When you want to increase performance, like reducing spool space usage by queries, simplifying complex queries,reducing many joins.When you want to avoid denormalization. Anyway it is...
74925 Jun 2014 @ 01:19 PDTGeneralReplyHow can we rectify spool space issues.Hi Purushotham, This is a good read with the note:  Note: If the user whose query unintentionally caused the spool space problem is logged on at the time you run this query, the query w...
74825 Jun 2014 @ 12:38 PDTDatabaseReplyTypes of TablekindYou can see thus: select distinct tablekind from dbc.tables. Next you see, requesttext for all those tablekind like select * frm dbc.tables maybe. It can be misleading if you consider it from the ...
74724 Jun 2014 @ 11:16 PDTConnectivityReplyExecuting Teradata sql script in Shell fileYou do not invoke  bteq..... something like this: bteq <<EOF >> $HOME/abc.dat 2>/&1 your logon  your report file .....something like : .export report file= $PWD/def....

Pages