12 | 03 May 2016 @ 01:51 PDT | Database | Reply | Common Table Expressions (CTE) | Also, could you please share any link or pointer where I can find complete details about the CTE
|
11 | 03 May 2016 @ 01:46 PDT | Database | Reply | Common 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... |
10 | 30 Apr 2016 @ 12:24 PDT | Database | Reply | Common 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?
|
9 | 30 Nov 2015 @ 11:37 PST | Tools | Reply | Regex function REGEXP_REPLACE not accepting parameter | Anish,
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
|
8 | 26 Nov 2015 @ 01:52 PST | Database | Topic | How to calculate Space saved & project it in terms of dollars | Hello 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... |
7 | 24 Nov 2015 @ 11:38 PST | General | Topic | Join Strategy followed | Hello 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,... |
6 | 13 Nov 2015 @ 04:53 PST | Tools | Reply | Error 9128 : Transaction exceeds max. number of Row Hash locks | Hi 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... |
5 | 13 Nov 2015 @ 02:35 PST | Tools | Topic | Error 9128 : Transaction exceeds max. number of Row Hash locks | Hello 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... |
4 | 02 Nov 2015 @ 11:03 PST | Tools | Reply | Difference in Aquisition phase of Mload & FastLoad | Thanks 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... |
3 | 02 Nov 2015 @ 07:01 PST | Tools | Topic | Difference in Aquisition phase of Mload & FastLoad | Hello 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... |
2 | 27 Sep 2014 @ 08:39 PDT | Teradata Studio | Reply | How 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
|
1 | 02 Apr 2012 @ 01:47 PDT | Tools | Topic | Teradata 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... |