We are experiencing network problems with the site. Some functions may be temporarily unavailable. Please bear with us while we work to resolve these issues.
All Forums

Share best practices, knowledge, successes and issues in Analytics, and discuss Analytical Applications. You must login to create a new forum topic.

Order of joined tables Topic by Zbirda 1 week ago
Tags:
Hi ALL, I have a simple question. Is it important the order of joind tables? What's better?: select ... from large_Table lt inner join medium_table mt on... inner join small_table st on... or?: select ... from small_Table st inner join medium_table mt on... ...
141 views
1 reply, 1 week ago
The order shouldn't matter. Inner joins are commutative, and the Teradata query optimizer will attempt to apply the operations in the order that r...
Jim Chapman
Calendar table calculation Topic by ratu 9 weeks ago Hi All,
I am a newbi to this forum so can someone help me out.

I am trying to get past 6 month/year numbers from a calendar table in TD.

For example I can query the calendar table on the current month and it will give me this….
Yr Mo
2010 01
<...
604 views
1 reply, 3 weeks ago
Quick Example with the sys_calendar (Hope it helps): SELECT year_of_calendar, month_of_year FROM sys_calendar.calendar WHERE calendar_date&...
amkumar29
Convert columns to rows. Topic by adash-7422 5 weeks ago Hi ,

I have a table with data like :

US 110 120 130
UK 50 60 70

I want data to be :

US 110
US 120
US 130
UK 50
UK 60
UK 70

The reason i want to bring all values into a single column is that I can...
586 views
2 replies, 4 weeks ago
you can also try this with recursive count3 (country, ctr) as ( select country, 1 as ctr from countries union all select c2.countr...
nguyent02
Citrix Server Compatibility Topic by DaveBarritt 09 Oct 2008 Will Teradata SQL Assistant v 7.2.0.0_11 work on a Citrix Server Client that uses Win 2003 (64 bit) for an OS?
6026 views
1 reply, 5 weeks ago
I thought I would post a comment on this post even though it's over a year old... TeraData can be published in a Citix XenApp environment using Pr...
peterzay
Alternate for 'Qualify ' analytical function Topic by praveenjanagam 5 weeks ago Hi All,

Qualify function is not working in my teradata system .I am getting error while executing the following query . It is not recognizing the 'qualify' key word. so is there any alternative to "qualify" so that i can execute the query ?

SELECT
'Total ...
399 views
3 replies, 5 weeks ago
"The exact error message is " 3706 : Synatax error : Expected something between 'QUALIFY' and ';'. And our DBA said that QUALIFY is not going to wo...
mikejbritt
Search Test String for Column Values Topic by ThisIsBob 5 weeks ago I need to search a VARCHAR(256) column for values stored in another table. Any thoughts?

Something like this:

select text_string
from table1
where text_string like any (select empnum from table2)

Note that table2 has something like 4MM rows...
245 views
2 replies, 5 weeks ago
The business partner is looking for employee numbers that are part of a comment. Stupid, yes; necessary, yes! Thanks. I'll try this out.
fore_xstra_tegy
Quartile fn Topic by adash-7422 5 weeks ago Hi,

We have a requirement where we have to show top regions based on quartile calculations. So if for example we have 48 regions, we would display 12th,24th,36th region. The no. of regions an change in future..it can be 200 as well. In that case we need to display 50,100 and so on. C...
246 views
1 reply, 5 weeks ago
Hi adash, there's a QUANTILE function, but it's outdated and should be replaced by ANSI syntax. And the nth region can be calculated using MOD, e....
mikejbritt
Getting the sum without using the columns in group by Topic by adash-7422 5 weeks ago Hi,

We have a requirement where we need to show the total sum as well as sum grouped based on levels :

eg: If there are 3000 orders , 1400 is under level 1 and 1600 under level 2, then data should be like:

Level 1 - 1400
Level 2 - 1600
Total -...
266 views
2 replies, 5 weeks ago
This is exactly what those GROUP BY-extendens are ment for: SELECT CASE WHEN GROUPING (level_code) = 1 THEN 'Total' ELSE level_code ...
mikejbritt
String Search and Replace. Topic by CapsuleCorpJX 16 Oct 2007 Is there an SQL update statement that can scan through the strings of a column, look for a particular word and replace it with another word?

The column has sentences in it, and I want to replace just one word while leaving the rest of the sentence intact.

24364 views
7 replies, 5 weeks ago
Or use Cobol on the mainframe or C on Unix, which we have had to do many, many times...
ttan
Data Mining - Best Practise Topic by STARTER 20 Oct 2009 Hi,

Can you give me pointers to best practise for Data Mining queries on Teradata data?

Thanks in anticipation,

Starter.
1116 views
2 replies, 6 weeks ago
Der DATA-MINING-CUP, jährlicher studentischer Wettbewerb und Anwenderkonferenz ... topics international experts and speakers informed about Best-P...
prash_sr
How to identify PPI columns Topic by Superflash 8 weeks ago Hi , Is there a way to identify columns used for partitoning either in PPIs or MLPPIs

select databasename , tablename , columnposition ,columnname from dbc.indices
where indextype ='Q'
order by 1 ,2,3 ;

brings back the PI of the table , not the partiti...
512 views
4 replies, 7 weeks ago
dbc.indexconstraints contains a CHECK with the partition expression. Dieter
mikejbritt
Error Loading Columns Topic by jafetw 7 weeks ago Hi All,

I was trying load columns in Data Explorer. After chosing a table from available tables, I tried to chose column from available columns, but error message pop up saying "Specified cast is not valid".

Anyone has encountered this problem?
Appreciate your shar...
191 views
0 replies
Teradata Material for 4th, 5th and 6th V2R5 Certification Topic by Pooja Arora 16 Nov 2009 Hi All,

I have cleared first 3 certification on Teradata and I am really keen to get some good material for 4th exam onwards.

for exams till 3 certification I was able to find some really good material on net but I am unable to find the same for 4th onwards.
872 views
2 replies, 8 weeks ago
hi pooja, can u send me the teradata basics material Thanks kiran kiran.kandem@gmail.com
gander_ss
Inserting '?' into a TD table Topic by manjeet 15 Sep 2009 Hi all,

How do i insert the special character '?' into a table.

Thanks
Manjeet
1483 views
3 replies, 12 weeks ago
Hi all! I've just visited this forum. Happy to get acquainted with you. Thanks. __________________
TCHINMAI
Transposing Data Topic by tdick 07 Dec 2009 I am looking to create a simple crosstab query which transposes and sums the below input data into summary output data dynamically. In this case there are 3 dates but I do not want to hard-code the dates into the query. I want the query to identify the dates automatically and place output with ...
1737 views
9 replies, 12 weeks ago
Thanks JIMM and PCPaul. PCPaul - am interested to see your case statements and associated code.
Gerardmcl
Internal Mechanism of Ranking Topic by harimon 02 Dec 2009 Hi
How does Teradata actually does the ranking internally.

Regards
Sreehari
544 views
1 reply, 12 weeks ago
Hi, Rank analytic function produces an ordered sequence of particular column or columns. We can Override this sequence by ORDER BY clause. ...
kondalmrao
Passing column name as parameter to the prepared statemnt Topic by tutika_shilpa@yahoo.com 24 Nov 2009 [font=Tahoma]Hi ,

I am trying to pass the format like 'DDMMYYYY' as parameter to the prepared statement from Java .


SELECT (created_date(TIMESTAMP, FORMAT ?) (VARCHAR(10))) from tableA

I get the following error .

com.teradata.jdbc.jdbc_4...
927 views
2 replies, 12 weeks ago
Hi, sel cast(cast(current_timestam p(0) as char(10)) as date format 'yyyy/mm/dd'); sel cast(cast(columnname as char(10)) as date format 'yyyy/mm/d...
kondalmrao
How to handle invalid date fromats in teradata Topic by VinodKumar 08 Dec 2009 i have to load data from file to td table ,in file i am getting invalid formats like '333/1/2009' .how to check this
please help on this


Regards
Vinod
435 views
0 replies
query that provides hierarchy Topic by Nolan Madson 10 Nov 2008 Can someone give me a pointer how to write a query that provides a sorted, indented organization hierarchy given a table with child org id and parent org id. Example of sorting below; I tried to show spaces in the indents, but this forum deletes leading spaces or tabs.

Org 1
O...
12233 views
3 replies, 14 weeks ago
We are using with recursive to display the metric hierarchy but its not showing up in correct sequence. Plz let us know if you have found any solut...
jufirst
Storing multiple values in a column Topic by adash-7422 04 Oct 2009 Hello,

I want to store multiple values in a column so that when i use it in IN clause all values are picked up in it as separate entities..
What I mean from above is that:
Suppose I have a table T1 with column C1, the data should be present as:
Record_Type C1
2063 views
6 replies, 15 weeks ago
carlos this is good. thanks!
Divya Upadhyay
How to calculate 90th percentile in Teradata Topic by Navnit 07 Oct 2009 Seems no build in available in tera data to calculate 90th or nth percentile for the given dataset
unlike ORACLE
1527 views
2 replies, 15 weeks ago
this is what i use. ansi, so you can use it in oracle or td. can easily be expanded out to give you the entire distibution should you want. SELE...
olamother
week issues Topic by mad_about_coffee 04 Nov 2009 Hello,







I hope someone could help me with my task:







Weekends = Fri, Sat, Sun



Weekend days = 6, 7, 1







What I ...
939 views
2 replies, 16 weeks ago
Hello Kumar, Sorry I wasn't able to get back to you as soon as I got your reply/solution... Anyways, this did solved my task. Thank you so much, s...
hays
Requirements Gathering Topic by meta 16 Nov 2009 Hi

Iam new to Teradata..can any one tell me the process of Requirements Gathering in Teradata warehousing



thanks
717 views
1 reply, 16 weeks ago
Requirements Gathering should be based on Buisness needs not on Teradata.
Tim Zeitter
Unable to COnfigure Teradata Manager Topic by sekharg9@hotmail.com 18 Apr 2009 Hi frnds!
I have download teradata express verison. Installed done properly.
All tools are working expect Teradata Manager.
Host name :- 127.0.0.1 or Localhost
1.Database set up Failure
system name 127.0.0.1
super user name = dbc / pass = dbc
console = e...
2454 views
1 reply, 17 weeks ago
I have same error showing. How can I solve it?
serko
How to search through multiple stored procedures?? Topic by ratu 28 Oct 2009 Hi All,

I am trying to search for dependencies in our database, and I have about 500 stored procedures to go through. Is there an easy way to do this?

I compiled all the show procedures as follows:

SHOW PROCEDURE database_name.procedure_name_1;
SHOW PR...
1018 views
2 replies, 19 weeks ago
Awesome! Thank you! It worked for me......
wahab lee
You must login to create a new forum topic.