319 | 16 Dec 2013 @ 11:27 PST | Analytics | Reply | Fast Load Vs Multiload | Hi San,
In your first line "In case of ideal senario for FastLoad why do we consider Fastload instead of Multiload" You know that the scenario is ideal for fastload, then what made you t... |
318 | 16 Dec 2013 @ 03:44 PST | Database | Reply | Extractin a QUERY TEXT from a Column and using this output we need to insert the data into another table. | Hi,
How many rows / Select statements are there in QUERY_TXT?
Do you have to repeat this BTEQ for all the rows in QUERY_TXT?
|
317 | 15 Dec 2013 @ 11:07 PST | Database | Reply | Substring Error? | Hi,
There are two syntax available for substring:
SUBSTRING( STRING FROM FOR)
SUBSTR(STRING , START_INDEX , LENGTH)
So if you are using substring you must specify FROM and FOR instead of comma.... |
316 | 15 Dec 2013 @ 11:01 PST | Tools | Reply | Almost databases can't list in my Data Source Explorer | Hi,
Which tool you are talking about?
If you are talking about studio, then the following link might help you:
http://forums.teradata.com/forum/database/why-i-do-not-see-all-the-databases-in-ter... |
315 | 15 Dec 2013 @ 10:06 PST | Database | Reply | Why explain plan is so off | Hi,
You do not have any stats collected on any table, thats the thing misleading the optimizer. The optimizer always require stats on table to give accurate estimates, else it may give unrealistic... |
314 | 14 Dec 2013 @ 11:52 PST | Database | Reply | set table with sum vs multiset with no sum | Hi,
You have not provided information about the indexes, the second confusing thing is whether you are trying to insert the individual rows, or you need to insert aggregates? What I suppose is you... |
313 | 14 Dec 2013 @ 11:43 PST | General | Reply | GROUP BY CUBE or ROLLUP how to use it? | Hi Millan,
The first thing is what is a cube? A cube is simply used for multidimentional processing. it is also called OLAP Cube, and Teradata has extended its Group by cluase to easily handle all... |
312 | 14 Dec 2013 @ 11:19 PST | General | Reply | Teradata Certification re-take policy | Hi,
You have provided answer in the second line. you can take a retake after 21 days, and yes you will have to pay the full fee for retake exam :)
|
311 | 13 Dec 2013 @ 09:31 PST | Database | Reply | Collect stats doubt | Hi Goldminer,
Thank you for sharing your thoughts, But this limitation has been eliminated in TD 14. Now the multicolumn stats are not truncated :)
|
310 | 13 Dec 2013 @ 04:36 PST | Database | Reply | Numeric Overflow Error | Hi,
What do you mean by records of length 16? is it a numeric or character value?
Can you please provide a sample value ?
|
309 | 12 Dec 2013 @ 11:46 PST | Database | Reply | Collect stats doubt | Tiger,
It is just a recomendation I found in TD docs. It is good that you are getting the same estimates in both cases, But It is recomeneded that when you are using the columns together in equali... |
308 | 12 Dec 2013 @ 11:38 PST | Database | Reply | How to grant UPDATE to DBC on DBC.IDCol Tables? | Kawish,
Can you please explain what do you want to achieve, as discussed in the post you mentioned, you can either recycle the Identity, Or you can use START WITH, INCREMENT BY, MINMUM VALUE, ... |
307 | 12 Dec 2013 @ 11:03 PST | Analytics | Reply | secondary index | San,
Yes sure, keep posting your queries, it is a good source of learning for others as well :)
|
306 | 12 Dec 2013 @ 10:59 PST | Analytics | Reply | While we add New AMP | san,
The simple answer is:
RowID(010101..001001)=ROWHASH(010101 --- AMP9)+(001001 ---uniqueness value)
as a result of reconfiguration the hashmap is changed, the same ROWHASH passed to the... |
305 | 12 Dec 2013 @ 10:55 PST | Database | Reply | Collect stats doubt | Hi Tiger,
There are two recomnedations to collect multicolumn stats:
When the columns are being used in condition or in join condition together
When there is a NUSI defined comprisin... |
304 | 12 Dec 2013 @ 10:40 PST | Analytics | Reply | secondary index | Hi San,
a. a SI subtable is distributed just like data table to all amps. and it is not the same table, it is distributed based on row hash.
b. In case of NUSI, the PE sends a broadcast message t... |
303 | 12 Dec 2013 @ 10:01 PST | Analytics | Reply | While we add New AMP | Hi Sankalp,
RowID = ROW HASH + UNIQUENESS VALUE
Row hash is detemined by the PI value, So when ever a reconfiguration occurs, the rows are just moved to the new amps because the Row Hash in the n... |
302 | 11 Dec 2013 @ 11:40 PST | General | Reply | Fastload Error Table 2 | Hi,
when the fastload receives duplicate values for the UPI, it inserts the UPI violation rows into error table. this error table is created each time, but dropped only if there is no UPI violatio... |
301 | 11 Dec 2013 @ 09:47 PST | General | Reply | Same query taking different CPU TIME, RESPONSE TIME | Hi Raj,
The response and throughput depends upon a number of factors, at times you might have different workloads running, that might cause different response time for the same query.
|
300 | 11 Dec 2013 @ 10:58 PST | Database | Reply | Skewed Query | Hi,
Can you please share the definitions of both the source tables? Or at least the Primary index information?
Also share the row count of both the tables.
|
299 | 11 Dec 2013 @ 10:39 PST | Database | Reply | Bteq script - error handling not working, need help | Hi,
You can use the below template to handle errors, while activity count is writted to log file based on the type of statement (Insert, Update, Delete)
SELECT 'STARTDTTM' AS A, CURRENT... |
298 | 11 Dec 2013 @ 10:32 PST | Analytics | Reply | join indices | Hi Sankalp,
I do not beleive that a query can be forced to use join index, as the use of join index is a processing decision made by the optimizer based on statistics. The only way is to col... |
297 | 10 Dec 2013 @ 11:55 PST | Database | Reply | SQL to transpose (row to column) any level (nth level) of data | Hi Koushik,
There is already a thread with this topic, you can consult that:
http://forums.teradata.com/forum/database/transpose-rows-to-columns-0
|
296 | 10 Dec 2013 @ 11:01 PST | Analytics | Reply | While we add New AMP | Yes sure, you can read about reconfiguration and a lot more at the link below:
http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/Utilities/B035_1180_111A/Reconfig.15.04.html
&nbs... |
295 | 10 Dec 2013 @ 10:49 PST | Tools | Reply | SQL Assistant 12.0 | Hi Surabhi,
if you have installed TD Express 13.0, even then you can install latest TTU available on the below link and it will be working fine. I am also using this.
http://downloads.teradata.co... |