#DateForumTypeThreadPost
1203 May 2016 @ 01:51 PDTDatabaseReplyCommon Table Expressions (CTE) Also, could you please share any link or pointer where I can find complete details about the CTE
1103 May 2016 @ 01:46 PDTDatabaseReplyCommon Table Expressions (CTE) Thanks Todd. If I understood it correctly, first form of CTE is more similar to a view and second form is similar to a volatile/derived table. For the first form, do we need to compile or create it...
1030 Apr 2016 @ 12:24 PDTDatabaseReplyCommon Table Expressions (CTE) Hi All, Could someone help me understand what a CTE means? By the looks of it, Can i assume that it's something similar to a recursive query?
930 Nov 2015 @ 11:37 PSTToolsReplyRegex function REGEXP_REPLACE not accepting parameterAnish, Ideally it should work in prod box as well. By the looks of it, it seems quotes are missing in the query for RAM & SHYAM
826 Nov 2015 @ 01:52 PSTDatabaseTopicHow to calculate Space saved & project it in terms of dollarsHello All, As part of our work, we have applied Multi Value Compression on tables that are huge in size and reduced the space usage. The space saved was around 40TB. However, along with projectin...
724 Nov 2015 @ 11:38 PSTGeneralTopicJoin Strategy followedHello All, Can someone help me understand the join strategies followed by Teradata for each of the below join scenarios between 2 tables ? I tried many times to understand looking at explain plan,...
613 Nov 2015 @ 04:53 PSTToolsReplyError 9128 : Transaction exceeds max. number of Row Hash locksHi Todd,  Thanks for clarifying. But I'm not able to understand the point "Since that is more locks than all but the largest systems can manage simultaneously, Teradata will&nbs...
513 Nov 2015 @ 02:35 PSTToolsTopicError 9128 : Transaction exceeds max. number of Row Hash locksHello All, I am trying to load a file with aroun 12 million records to an empty table and I tried using BTEQ. I am included begin transaction & end transaction statements in my BTEQ import sc...
402 Nov 2015 @ 11:03 PSTToolsReplyDifference in Aquisition phase of Mload & FastLoadThanks Fred. So, if I understood you point correctly, be it phase-2 of fastload or application phase of Mload, data is just committed to the actual target table. Redistribution/hashing of data to m...
302 Nov 2015 @ 07:01 PSTToolsTopicDifference in Aquisition phase of Mload & FastLoadHello Everyone, I have a question on Mload & FastLoad. Lets assume that I have an empty table and I am trying to  load a file into this table using Mload or fastload. Now, based on below...
227 Sep 2014 @ 08:39 PDTTeradata StudioReplyHow Do You Create A Teradata Database?Hi All, I have created Teradata Studio Express 15.0. But I am finding it difficult to create a connection profile. Can you please help
102 Apr 2012 @ 01:47 PDTToolsTopicTeradata Mload Vs FastLoad Vs TPump Hi All, I am new to Teradata and to this forum. Some questions popped up in my mind when I was understanding teradata architecture and data loading tools. The difference between Mloa...