394 | 08 Jan 2014 @ 08:34 PST | Database | Reply | Statistics Creation on Tables and Stat Subsets to Enable Faster Join Queries | Hi,
The best way to check the required stats is to use help stats diagnostics.
You can use it as follows:
DIAGNOSTIC HELPSTATS ON FOR SESSION;
Explian Your_Query
Then go to the end of expl... |
393 | 08 Jan 2014 @ 08:19 PST | Database | Reply | OREPLACE | oops, I thought you were asking about the string length.
Well, according to the documentation "The maximum length of a VARCHAR or CLOB result value is the maximum length that Teradata support... |
392 | 08 Jan 2014 @ 03:17 PST | Database | Reply | Query with TOP and COUNT | Ratnam,
Without order by clause the database will return any 10 rows from the table, but this result may not be truely random. The random function does extra processing to generate a rando... |
391 | 08 Jan 2014 @ 02:59 PST | Tools | Reply | BTET/ANSI Transaction in TPT/FASTLOAD | San,
Sure, you can do that test, but remember here the rows are inserted into error table due to data error, and this will fail transaction in case the errors exceed the defined error_limit.
&nbs... |
390 | 08 Jan 2014 @ 01:29 PST | Database | Reply | OREPLACE |
JF,
According to the documentation the purpose of OREPLACE is to replace a part of string with another, to get the max string size you can use:
Select ... |
389 | 08 Jan 2014 @ 12:52 PST | Database | Reply | Find out all the groups in a data. | Barani,
Your dataset is confusing, Do you want to find groups based on common To_Number and From_Number?
|
388 | 07 Jan 2014 @ 08:27 PST | Database | Reply | Converting Number to Character | So you want to suppress any trailing 0z,
This will work for you:
SELECT
CAST(11 AS DECIMAL(18,6)) / 1000.00 (FORMAT 'GZ(I)DZZZZZ')
|
387 | 07 Jan 2014 @ 07:59 PST | Tools | Reply | BTET/ANSI Transaction in TPT/FASTLOAD | Santanu,
In Teradata utilities there are two kind of tables to handle errors, one is to handle UV violations and the other is used to store rows with errors, these errors are usually related to da... |
386 | 07 Jan 2014 @ 07:51 PST | Database | Reply | Converting Number to Character | Stephen,
Basically in order to avoid this round off you need to devide by the same percision as the value.
for example in case of 18750 we need to case it to decimal to get result as decimal and ... |
385 | 07 Jan 2014 @ 12:39 PST | Database | Reply | Converting Number to Character | Hi Stiphu,
Try this:
SELECT
CAST(CAST(2400 AS DECIMAL(18,1)) / 1000 AS VARCHAR(6))AS div
|
384 | 03 Jan 2014 @ 10:29 PST | Training | Reply | Regarding Certification Exams - Pass % | Ashoke,
Thats great, if you are working on a client side then I think there should be a proper way to get all that material. You can discuss it with your manager, he will surely guide you ho... |
383 | 03 Jan 2014 @ 10:26 PST | General | Reply | Question | Cheeli,
No, You cant switch from TD-12 to TD-14 like that, you will have to start from TE0-141 :)
|
382 | 03 Jan 2014 @ 10:25 PST | General | Reply | Question | Monita,
I suggest you to start with TE0-141, because TD-12 certifications will expire and you will have to bridge at any cost.
|
381 | 02 Jan 2014 @ 10:50 PST | Training | Reply | Regarding Certification Exams - Pass % | Ashok,
I have heard that is a good book, You will have to purchase that. But if you are not an employee of Teradata or have not worked on Teradata then whats the benifit of certification?
|
380 | 02 Jan 2014 @ 10:36 PST | Database | Reply | Join two tables using like statement | Dieter,
My bad, I ignored that condition, thanks for the correction :)
|
379 | 02 Jan 2014 @ 09:14 PST | Database | Reply | Join two tables using like statement | vandeberg,
Agree with you, using a function, especially a string function will not only increase spool and full table scan, but also will cause the optimizer to use a product join strategy to reso... |
378 | 02 Jan 2014 @ 03:47 PST | Database | Reply | Strange behavior while moving data from Integer columns to Varchar columns |
I dont know why I am unable to paste the code, but In fact Teradata is implicitly converting the integer to Varchar, it happens as follows:
Integer 1 is convertes as ----... |
377 | 02 Jan 2014 @ 03:01 PST | Database | Reply | Join two tables using like statement | Hi caka,
While looking at your data, 12345 in T1 has three 12345/1,12345 /2,12345/123, So in either left or inner you will get three values against a single value in table1, whic... |
376 | 02 Jan 2014 @ 02:44 PST | General | Reply | Question | Hi,
Yes, you can only jump from TE0-123 to TE0-143, and then attempt exam from TE0-144 to TE0-147.
Other wise you will have to take start from TE0-141.
http://www.teradata.com/tcpp/teradata-cert... |
375 | 02 Jan 2014 @ 02:29 PST | Tools | Reply | When are secondary indexes required? | Bliane,
I didn't get what you want to conclude from this, but the discussion whther to use SI on a PPI or not, and when it is accessed by the optimizer.
You can see in all the... |
374 | 02 Jan 2014 @ 02:20 PST | Database | Reply | Strange behavior while moving data from Integer columns to Varchar columns | Hi,
It is not the strange behaviour rather it is default behaviour. An when an intger is converted to varchar, it requires 11 characters for representation. So when you try to insert the i... |
373 | 02 Jan 2014 @ 02:01 PST | Database | Reply | Order of partition columns in MLPPI | Hi San,
The base of decisions in defining MLPPI is to improve access, so you need to consider access and then decide about which col should be at the top and which at the lowest level.
&n... |
372 | 01 Jan 2014 @ 11:18 PST | Database | Reply | Perm Space and Spool space | Hi,
When you assign spool space to a user it defines the maximum spool limit that a user can use, but allocated only at run time according to the requirement. So deleting users does not mean that ... |
371 | 01 Jan 2014 @ 10:40 PST | Tools | Reply | When are secondary indexes required? | Hi San,
I must appreciate the effort you have put to simulate the scenario.
Once again I would say, the final decision is of optmizer to use which index at which scenario. for example even if opt... |
370 | 01 Jan 2014 @ 12:14 PST | Tools | Reply | When are secondary indexes required? | Hi VandeBergB,
The case you are refering is the best scenario of partition and this is the most optimal case in PPI. Secondary indexes are mostly recomended when the partition by column is not par... |