#DateForumTypeThreadPost
52123 Jan 2014 @ 09:33 PSTToolsReplynew line characterYou have not given an example and what you expect :) Maybe you can try with regex_replace: SELECT REGEXP_REPLACE('it is the first line it is the third line 2.it is the second line ...
52023 Jan 2014 @ 09:18 PSTThird Party SoftwareReplyDatastage 8.01 running with Teradata 14.10.I think like other ETL tools like I used to work before, they keep upgrading and no big hiccups. Patches and some miscellaneous stuffs are are always , almost inescapeable. However, the release doc...
51923 Jan 2014 @ 09:35 PSTCloud ComputingReplyNo internet connection in VMWAREKhurram, I am in VMWARE and I can see Linux window. I have Mozilla there. Do you feel I miss out any thing? I have C:\Program Files (x86)\VMware\VMware Workstation\ . On opening this, I land up i...
51823 Jan 2014 @ 07:15 PSTDatabaseReplyFastLoad for multiple input filesIt is just the way it works.You can put the script one by one. You can use tpt to load multiple files. Cheers,  
51723 Jan 2014 @ 03:02 PSTDatabaseReplyCount and Sum by MonthHi, Do you mean something  like this? SUM(CASE WHEN EXTRACT (MONTH FROM T_DATE) =1 THEN t_amount ELSE 0 END) AS JAN_T_AMOUNT SUM(CASE WHEN EXTRACT (MONTH FROM T_DATE) =2 THEN t_amount...
51623 Jan 2014 @ 12:25 PSTThird Party SoftwareReplyDatastage 8.01 running with Teradata 14.10.Hi, Can you please elaborate more on the concerns. I think you can use InfoSphere Information Server.   http://www.ibm.com/developerworks/data/library/techarticle/dm-0912terada...
51523 Jan 2014 @ 12:01 PSTDatabaseReplySQL statements in UNION executes serial or parallelHi bikky, Not sure from which context you are looking. However, I ran an explain test:   select databasename,tablename from dbc.tables where databasename <> 'dbc' un...
51422 Jan 2014 @ 11:33 PSTCloud ComputingReplyTeradata Express AMP DOWN   I am of the opinion that Express is configured in a cluster such that  down amp recovery journal is possible and automatic.   I heard that it can be recovered from r...
51322 Jan 2014 @ 09:32 PSTCloud ComputingReplyNo internet connection in VMWAREKhurram, It is not working. Below are the settings: In VMWARE, I click on  Network settings.There are 4 tabs:   1) Global options  a) Network Setup Method--I choose ...
51222 Jan 2014 @ 09:15 PSTCloud ComputingReplyNeed software link to downloadHi Praveen, You can check this link: http://downloads.teradata.com/download/database/teradata-express/vmware Also, you can check this link for a reading , just in  case you like to go for T...
51122 Jan 2014 @ 03:12 PSTConnectivityTopictd wallet for jdbcHi, Can someone share the idea how can we implement tdwallet using jdbc connection. Thanks and regards,
51022 Jan 2014 @ 01:43 PSTCloud ComputingReplyNo internet connection in VMWARE Khurram, My laptop ip is 192.123.2.3 say. Where can I see and assign the ip static IP to guest? Is it after opening my Virtual Player or where? Yes vmnet1, I can see after opening &n...
50922 Jan 2014 @ 12:10 PSTCloud ComputingTopicNo internet connection in VMWARE Hi,   I am not able to access internet inside VMWARE. I am able to use Teradata there in xterminal. I turned off firewall.I tried 1) Bridged 2) NAT 3) vmnet8.All these no use. &...
50821 Jan 2014 @ 11:58 PSTConnectivityReplylist database and related table in Teradata with vb6Yes it is possible. All you need to do is put your query in the code after connecting. I took one sample code( I dont have env to test and you have to make changes accordingly if need be) from net ...
50721 Jan 2014 @ 11:43 PSTDatabaseReplyWhen to use Temporal featuresHi, I am not pretty sure of your question specifically. However, let me answer it this way. It depends on the project specifications and end requirements. It can be at ODS, EDW or Semantic or eve...
50621 Jan 2014 @ 11:30 PSTDatabaseReplyWhich is efficient?My statement is subject to correction :).   You can check the explain plan for both.I feel that for small amount of data , they are almost the same. ResTree to ResTree' conversion,in ...
50521 Jan 2014 @ 09:32 PSTGeneralReplyStatus of queriesHi, There are few Monitor session functions like  SELECT * FROM TABLE (MonitorSession(1,'*',0)) AS dt Cheers, Raja
50420 Jan 2014 @ 08:38 PSTDatabaseReplyLarry Higa MacrosJFMI, can you get there at Teradata at your service? It asks for   Master Customer number at the time I register. I dont have it. Cheers,
50320 Jan 2014 @ 09:25 PSTDatabaseReplyLarry Higa MacrosNot sure! I heard they are in Teradata @ your service. But  I can't login there :(  to search. Maybe some other places I don't know.  Cheers,  
50217 Jan 2014 @ 04:30 PSTToolsReplyError while running FastExport scriptSomewhere a syntax problem, maybe a semi colon at end .logon <ipaddr>/user,password??? I guess the driectory, fname etc are fine, Cheers,
50117 Jan 2014 @ 01:19 PSTTrainingReplyTerdata Certification in IndiaHi Sri, You just need to copy and paste the link . No need to use anything(like code,B etc) from toolbar. I think this is what you need. Cheers,
50017 Jan 2014 @ 01:06 PSTDatabaseReplyAGGREGATION I am not sure about your thought.I think what you mean to say: If the column values  to be grouped by are unique , then no need to do summation. Then yes.   I suggest you paste...
49916 Jan 2014 @ 09:41 PSTDatabaseReplyAGGREGATIONBhalla, you can check it once again. Maybe you miss out the comma(s) etc. Else you paste here your create table., Sample data and what you select and what you get. Then we can help. Cheers,
49816 Jan 2014 @ 09:18 PSTTeradata ApplicationsReplyUnity Source LinkHi Gary, I will not be able to take up the training :). Hi Tom, Thanks for the information. Wish we can expand more, with other DBs in future releases. Regards,  
49716 Jan 2014 @ 09:13 PSTDatabaseReplyIndex Question You can have only one primary index  per table.However, you can create secondary indexes. So you can design in such a way that they are used in where clause.   Cheers,

Pages