#DateForumTypeThreadPost
24627 Nov 2013 @ 07:34 PSTUDAReplyCancel Rollback on a table with referential integrityHi Noel, Just to add : I am curious if it is hard RI or soft RI too(it can be strange with data volume), can you please share this info for me . Vlad, If you dont mind, can you please share the ...
24527 Nov 2013 @ 04:10 PSTCloud ComputingReplyCloud serverHi, You could have browsed more inside and see, for us to avoid re-visiting the same :). Please find this link. http://forums.teradata.com/forum/cloud-computing/cloud-features Hope , it helps fo...
24427 Nov 2013 @ 02:08 PSTUDAReplyCancel Rollback on a table with referential integrityHi, Have you tried : SELECT SYSLIB.AbortSessions(1,'your_user',0,'Y','Y');   Cheers, Raja
24327 Nov 2013 @ 12:02 PSTDatabaseReplysum of amout for the date falling in the respective month i.e months wise sum amount is requiredHi, It seems you have two tables to be joined table1 with (amt and calendar date..) and another table is sales table keeping track of order date status till closure. I suggest you put some fields...
24226 Nov 2013 @ 08:27 PSTUDAReplySupressing Titles on .EXPORT commandHi,   You can use recordmode off You can try this way:   select CAST( core_tb_name|| ',' || sem_tb_name|| '~' || (CASE WHEN anotherfield IS NULL THEN &...
24126 Nov 2013 @ 09:16 PSTDatabaseReplyExplain plan for set tableHi, What is your data volume? I feel that as  amount of data grows huge then you will see the difference of set and multiset, a duplicate check for set. Cheers, Raja
24026 Nov 2013 @ 12:01 PSTConnectivityReplyHow to establish Connection from Teradata to Hadoop and also for Hana Hi, As per my conversation with SAP Hana folks, yes it is the same SAP DS to connect to TD. They explained to me also about OLTAP, Data Sectors, OS settings and features in HANA. You can use SAP ...
23925 Nov 2013 @ 10:43 PSTConnectivityReplyHow to establish Connection from Teradata to Hadoop and also for Hana Hi, For Hadoop, you can refer this link.  http://developer.teradata.com/connectivity/articles/teradata-connector-for-hadoop-now-available I have experience on Hive, hbase, hdfs and am not a...
23825 Nov 2013 @ 08:48 PSTDatabaseReplyAny good training institude to learn teradataHi, If you are in India, there are lots of places. In Bangalore, you can enquire in many training institutes , especially in and around Koramangla, MG road, Indiranagar, JP Nagar,Jayanagar. In Hy...
23725 Nov 2013 @ 12:14 PSTDatabaseReplyAutomate my Teradata queries Hi Prateek,   You can put your modularized codes according to the way they can execute themselves with all the logics, conditional and branching required with date/time inside a sto...
23622 Nov 2013 @ 06:57 PSTUDAReplyARRAY Structure in Teradata Stored ProcedureYou are welcome. Good luck. Cheers, Raja
23522 Nov 2013 @ 04:08 PSTDatabaseReplyTeradata Data Types to OracleHi Shantanu, As I see more and more people migrating oracle to Teradata, I recommend them understanding the functionality too like , if you have nested tables, index by binary integer, varchar, re...
23421 Nov 2013 @ 11:36 PSTTrainingReplyTeradata trainingHi, Just to help you: You have not mentioned the place and mode of  training. There are a lot of training institutes. But please be aware before commiting. I know few places where they dont ...
23321 Nov 2013 @ 11:28 PSTMarketing & CRMReplyBusiness solution without TechnologyThanks for the information. The reason I am asking this is because I am from technical, techno-business consulting side and it is my flair. Please dont get offended :). I am always a friend to all....
23221 Nov 2013 @ 10:10 PSTUDAReplyARRAY Structure in Teradata Stored Procedure Hi Krutz,   I am not able to understand it clearly. However, if you want to convert columns into rows then you can do thus.   select col1 from A union all  ...
23120 Nov 2013 @ 11:33 PSTGeneralReplyProcess of Change of PI in skewd tableHi Omar, With TD 14.., there are few enhancements.We can compress Null for data types such as array,period,distinct and structured,  compression for column-partitioned tables,ALC, BLC etc....
23020 Nov 2013 @ 08:52 PSTDatabaseTopicQCD with no index Hi,   I am reposting this question from viewpoint.   Can you please provide me scenarios where I can have QCDs with no index, excepting that I exclude index subtable? ...
22920 Nov 2013 @ 08:48 PSTViewpointReplyQCD with no indexHi Gary, Thanks for direction. Regards, Raja
22820 Nov 2013 @ 08:46 PSTUDAReplyPDCRHi Gary, Thanks for the information. Regards, Raja
22720 Nov 2013 @ 07:41 PSTUDAReplyARRAY Structure in Teradata Stored ProcedureHi Krutz, How can a single value be gone into an array? I think you are trying to simulate what oracle has. For example .....select fields bulk collect into varray type or you may want to use the ...
22620 Nov 2013 @ 07:05 PSTMarketing & CRMReplyBusiness solution without TechnologyHi Ulrich, I am enterprising.  I am a solution provider. So when I am answering questions posed by clients, or someone, then I can confirm affirmatively that it is yes or no. Teradata has man...
22520 Nov 2013 @ 06:57 PSTGeneralReplyHow to post a blog?Hi Dieter, Thank you very much. Regards, Raja
22420 Nov 2013 @ 12:43 PSTViewpointTopicQCD with no indexHi, Can you please provide me scenarios where I can have QCDs with no index, excepting that I exclude index subtable? Thanks and regards, Raja
22320 Nov 2013 @ 12:38 PSTMarketing & CRMTopicBusiness solution without TechnologyHi, Does Teradata provide Business solutions without Technology? Thanks and regards, Raja
22219 Nov 2013 @ 08:56 PSTToolsReplyDiacritic character issue multiload BODSAlso Pranil, did you use Oracle Source Table -----Query Transform--- Teradata Target table? To be honest, I may have missed that vartext option, since I worked in 2010. Did you try with trim and ot...

Pages