All Forums

Share best practices, knowledge, successes and issues in Analytics, and discuss Analytical Applications.

You must login to post to the forums.
SQL works fine in Teradata SQL assistant getting error when trying to execute in Tableau custom SQL connection Topic by benjamin.porter 21 Nov 2012 tableau

Hello,
I have a SQL script that works fine in Teradata SQL assistant, but when I try in bring it into Tableau custom SQL connection, I get a "All expressions in a derived table must have an explicit name" error.  I *think* this has something to do with the FROM clause, but my chops are not good enough to be sure.  Any help is greatly appreciated.
 
 

sel

9341 views
1 reply, 7 years ago
AMPCHECK Topic by Sandi 14 Oct 2008

Hi,If I change AMPCHECK= ALL to AMPCHECK =NONE in a mload job, Will it impact the performance ?Thanks

18063 views
3 replies, 7 years ago
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 one column for each date, named as a date. Harcoding is easily done using sum-case statements but again I do not want to hard code the dates.Input Data:AccountType Date ValueBad 1/31/2009 3Bad 1/31/2009 3Bad 2/28/2009 2Bad 2/28/2009 2Bad 3/31/2009 4Bad 3/31/2009 4Good 1/31/2009 2Good 1/31/2009 2Good 2/28/2009 3Good 2/28/2009 3Good 3/31/2009 4Good 3/31/2009 4Ugly 1/31/2009 3Ugly 1/31/2009 3Ugly 2/28/2009 2Ugly 2/28/2009 2Ugly 3/31/2009 4Ugly 3/31/2009 4Desired Output:AccountType 1-31-09 2-28-09 3-31-09Good 4 6 8Bad 6 4 8Ugly 6 4 8

32507 views
14 replies, 7 years ago
Finding minimum thro' recursion Topic by gvr.ramesh.bi 21 Oct 2012

Hi,
    Is there any possible way to findout minimum in foll. case thro' SQL Script or Stored procedure. I have two tables TX11 and MX11. I need to take the rec. from TX11 tbl and insert into MX11 tabl with foll. cond.
Assume 
 

TX11 (table)

 

id

SVC_id

301

1001

101

1001

201

3295 views
0 replies
PARTY DEMOGRAPHIC HIST in CLDM Topic by JorgeCarrasco 15 May 2007

Hi all,I would like to know what is the reason for modeling the demographics of a party in the CLDM, FSLDM with the posible values already set in the DEMOGRAPHIC VALUE entity vs creating a column in the PARTY DEMOGRAPHIC HIST like Party_Demographic_Val VARCHAR(50) and put any value in there. Maybe similar to FEATURES in the FSLDM.ThanksJorge

43384 views
5 replies, 7 years ago
When can Aggregate Join Index (AJI) be accessed? Topic by Charudatt 19 Oct 2012

 
 

Hi Gurus,

 

Requirement is to establish the efficient ROLAP performance; for that we are looking to create AJI. There are OLAP views created for users and queries will be based on joins between them including the Fact table. Most of our AJI are working except for below scenarios.

3150 views
0 replies
Passing parameter in macro/procedure Topic by Kalidasrajendran 18 Oct 2012

Hi,
 
Is there any option available in Teradata to set a default value, while initializing a parameterised variable?
 
Example:
In Oracle, we have like
Create or replace procedure sample (firstname varchar(20) DEFAULT NULL, lastname varchar(20) DEFAULT NULL)
as 
BEGIN
--- statement block
END sample;
 

6577 views
1 reply, 7 years ago
Case statement returning "Bad character in format or data...." Topic by gfuller40 17 Oct 2012

 

I'm trying to run the following code to return a policy# formatted correctly so that I can join up with other tables and I'm receiving the following error "Bad character in format or data of TLTC900_CLM.C_POL

 

 

 

Any help would be great!

 

 

7860 views
7 replies, 7 years ago
Calling a bteq Script from informatica Topic by maheksi 05 May 2009

Hi,through Informatica session: post session command, I am trying to call a shell script : test.sh which inturn calls a BTEQ scripttest1.bteqI am getting below error :test.sh[6]: test1bteq: cannot openCan anybody tell me what I am missing here?

13515 views
2 replies, 7 years ago
how to fetch rows from a teradata cursor when i am not sure about no of columns Topic by prashanth.bose 16 Mar 2010

Normally we do this :

DECLARE EmpCur CURSOR FOR
SELECT employee_number , department_number FROM employee
WHERE employee_number < 1005 ORDER BY 1 ;

14658 views
2 replies, 7 years ago
HOW to export to excel use right format? Topic by peihsuan 16 Sep 2008

i need to export some contract number to excel,the contract number's format is 000012345.when i tried to export to excel,the contract number became 12345..SET SEPARATOR ' '(i used "TAB tO separator);thx~~

14984 views
1 reply, 7 years ago
R functions & Teradata Topic by eddie.baldo 10 Sep 2012

Hello,

I am using Revolution R & Teradata. Can I use all the R functions (example "rpart" for regression trees or the "pamk" function for cluster analysis) against Teradata or I can use only the functions provided by the "teradataR" package ?

 

Thanks,

 

Edoardo

3235 views
1 reply, 7 years ago
Counting working days Topic by Reece260 02 Sep 2012

Hi

I have a table with a list of delivery dates for orders that have failed to go out. I need to report on how many working days these are passed that delivery date.

For example I have a table like this:

OrderNo, RequestedDeliveryDate
Order1  , 2012-08-27
Order2  , 2012-08-31

So if I was to run this today (2012-09-03) I need an output of:

7437 views
4 replies, 7 years ago
Need to calculate days Topic by deva_048 31 Aug 2012

Date Table:
Table name:control_date
cols: Processdate

For E.g)
Processing date will have 8/30/2012

Query: (Its failed for invalid date)
select processdate + (INTERVAL '1' DAY) - (INTERVAL '26' MONTH) FROM CONTROL_DATE;

Actual OUTPUT:
6/31/2012 (We don't have 31st for June month)

Expected output:
7/1/2010

6966 views
6 replies, 7 years ago
Connecting to csv in R with the teradataR package Topic by kfbecker 21 Aug 2012 csv odbc teradatar

Hi all,

 I am trying to connect to a csv file through ODBC. It looks like R is seeing the directory correctly (no error for tdConnect), but does not see the file within. Does anyone have any thoughts?

 

3371 views
3 replies, 7 years ago
JOIN - Need to include a.tkt_num = b.tkt_num And (a.tkt_num not = b.tkt_num) Topic by Chuken22 23 Aug 2012

Hi,

Can you please assist me with the following Join Query… I’d like my query to always show everything from the pedw_tmp.tickets_ccb_tmp even if there’s nothing in the pedw.tickets b, and pedw_tmp.sadf_rec40_stg.  They (.b, .c) can be NIL or BLANK if there are no tkt_num matches but I must have all data from tickets_ccb_tmp a.

Thank you for your help!

 

3942 views
1 reply, 7 years ago
Embedded Selects statements within a select stmt Topic by FM 24 Sep 2008

Hi,I am new to Teradata but have worked previously with Oracle.I want to embed a select statement within another select statement likeselect t.col1,t.col2,(select x.colname from another_table x)from test tI am getting the following error:3706: Syntax error: expected something between '(' and the 'sel' keyword. Any ideas on how to get around this?Thanks

19011 views
3 replies, 7 years ago
Teradata Services Topic by rajdaksha 25 May 2009

HiI have installed the teradata express edition 12.0. i got message from service control. Msg:-- "reboot system to start teradata services"please help on the same.byraj

15295 views
10 replies, 7 years ago
Examples using the TeradataR package Topic by thurley 06 Aug 2012

Hi,

I downloaded the TeradataR package. It doesn't include any examples - does anybody have any examples they can share?

Thanks,

 

Tom.

4672 views
1 reply, 7 years ago
small SQl query Topic by psyam 16 Jul 2009

I have a table with dataColumn 1 Column 2A 1A 2A 3B 1B 2 C 4c 6c 7i need to get the output as (based on group by first column)A 1 2 3B 1 2C 4 6 7Please let me know the SQL to achieve this

16759 views
7 replies, 7 years ago
Why are the rows missing? Topic by Dantes 27 Jul 2012 teradata, sql

 

Hello,

 

Is there any tool or method or something else which can help me with analysis of the process.

The process contains around 15 steps and each job step is represented with one SQL script. I am working with Teradata.

4983 views
1 reply, 7 years ago
Query Analyzer Topic by Dantes 26 Jul 2012 query, software, analyzer

Hello,

 

I have to analyze some really complex queries. I would like to have a general overview of the whole process which contains about 15 sql scripts.

It would be a tremendeous help if I could find some software that could helm me do that.

Does anyone know about that type of software and could anyone give some suggestions?

 

Thanks,

4612 views
0 replies
Is an embedded process atomic, or can it be dynamic per record? Topic by TimManns 25 Jul 2012 embedded process

Hi guys,

I'm just starting to look into Embedded Process in Teradata.  I'm a dataminer / advanced SQL coder, so my intention is to use an Embedded Process to manage predictive scoring and similar analytics.

4265 views
0 replies
Teradata Database Name change in BO Universe Topic by Kanchan 25 Jul 2012

Hi ,

 

We are developing a universe that contains tables on Teradata. There are 3 environments, development, test and production. Teradata database is on a single machine where the tables for 3 environments can be identified by their database prefixes. For example calendar table in 3 environments would be:

DD_HLP.calendar
DT_HLP.calendar
DP_HLP.calendar

4431 views
0 replies
Multiple Rows Into 1 Question Topic by Chuken22 18 Jul 2012

Hi All,

I was wondering if i could get some expert advise on the best way to receive the following output.

 

 

POSTDATE

TRANS_TYPE

BILLING_CRCY_CDE

CC_TYP_CDE

TKT_NUM

CC_WIP

FARE_WIP

TAX_WIP

Sum(RADF_AMT_PD)

2012/06/28

CCD32D         

?

5305 views
6 replies, 7 years ago

Pages