All Forums

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

You must login to post to the forums.
Teradata-OLAP-Connector Topic by Raja_KT 10 Nov 2013

Hi,
Can I use Teradata-OLAP-Connector with excel 2007 when my ram size is 2 GB?
Thanks and regards,
Raja

1558 views
0 replies
Surrogate key when need Topic by Raja_KT 10 Nov 2013

Hi,

 

I feel that if I need ;a surrogate key, I can generate from my query itself, even though if my edw is fed from heteregeneous sources, I can identify my sources with constant concatenation.

Also at the reporting side, based on the knowledge of the system, the users can just obtain on the fly.

 

Please tell me which scenarios I have not covered.

1373 views
0 replies
Suggestions to clean up phone numbers Topic by bassrick 17 Oct 2013 number, conversion, formatting

Hello,
I am receiving phone numbers from multiple tables.  No standardization was done on any of these tables for formatting.  I have values such as:
(888) 123-4567
(888)-123-4567
(888)  123-4567
888-123-4567
888 123-4567
8881234567
888.123.4567
 

1541 views
1 reply, 6 years ago
MAX, SUM OLAP Functions Topic by kinsie 15 Oct 2013

Hi
I have been working on the query below and can't for the life of me get the result I need.
In short, I need a single row per SU_SUBSCRIBER_ID that is the MAX(d.effective_date)AND the SUM (c.BILL_PYM_RECEIVED_AMT). 

6122 views
2 replies, 6 years ago
Running query under certain condition Topic by jasonezheng 21 Aug 2013

Hi, 
I am wondering if Teradata has any function for running query under "rules".
 

1521 views
1 reply, 6 years ago
Casting 9/18/2013 6:08:46 AM , 9/9/2013 6:08:46 AM into TIMESTAMP(3) format Topic by Bhavuk_jain 03 Oct 2013

Hi  ,
We need to cast these following timestamps in to TIMESTAMP(3) Format.

9/18/2013 6:08:46 AM

9/9/2013 6:08:46 AM

 

we are recieving these from the source.

We dont want to extract day , and month part and padd zeroes in case less than 10.

Is there any other sollution then this ?

 

Please help.

 

1245 views
0 replies
Casting 9/18/2013 6:08:46 AM , 9/9/2013 6:08:46 AM into TIMESTAMP(3) format Topic by Bhavuk_jain 03 Oct 2013

Hi  ,
We need to cast these following timestamps in to TIMESTAMP(3) Format.

9/18/2013 6:08:46 AM

9/9/2013 6:08:46 AM

 

we are recieving these from the source.

We dont want to extract day , and month part and padd zeroes in case less than 10.

Is there any other sollution then this ?

 

Please help.

 

1226 views
0 replies
Need to select Date range from Table A which does not fall under Date range of Table B Topic by abilash36 24 Sep 2013

Hello, Im new to Teradata and i need some help in following scenario
Table A
PK    Start Date      End Date
100   01-01-2005  30-06-2006
100   01-01-2011  31-01-2011 ---- This record need to be selected
100   01-02-2011  31-07-2013
100   01-08-2011  31-12-8888
 
Table B
PK    Start Date      End Date
100  01-09-2000    30-06-2006

1468 views
1 reply, 6 years ago
Teradata SQL assistant: limiting the number of rows returned in "Export results" Topic by m_nardone 02 Oct 2006

I'm running some pregenerated queries that contain several (100+) subqueries, each of which is returning data to (spawning?) a separate answerset window.All of the answersets are to be copied to a single document as testing documentation. I know I can limit the number of rows returned for each answerset window (tools/options/Answerset/max numbers...) but I have so many answersets, I can't cut/paste each answerset to a single text document. I'm using Export Results to return the results from all the queries directly to a single text document, but then I lose the ability to limit the number of rows returned in each query. Is there a way to do that? I want to Export Results, but only keep the first 50 rows from each answerset.ThanksMat

48654 views
7 replies, 6 years ago
substring(accno,7,10) Topic by nichunchun 10 Mar 2009

Hi, I run query including "substring(accno,7,10)" in queryman ( query teradata directly ) and returned some result. I tried to use same query in SAS, show " Error: Teradata prepare: Syntax error: expected something between the word 'accno' and ','" . Somebody knows how to fix it? How to replace substring?

63276 views
5 replies, 6 years ago
Partial or full column(s) compression Topic by Raja_KT 02 Sep 2013

Hi,
With technologies and requirements coming up, I feel there is a need to have databases or appliances where the entire column(s) can be compressed partially or fully. I see that Teradata and Greenplum have made gigantic gallops on this. The most important topping required is the robust in-memory intelligence on an-already cheap rate storage cake for EDW. Quo vadis?
 

1446 views
0 replies
REPORT FROM MULTIPLES QUERY BEST APPROACH Topic by MBSconnection 19 Aug 2013

I do not know the Best Approach and I am a total Newbie with databases and SQL. Learing from Several Platfrom.

 

I have to create a Report by pulling data from database Views and exporting it into Excel Sheet.

 

The Columns of the Excel sheet has to be in correct sequence. The first 7 columns of the excel sheet will always be filled with fixed data.

 

1831 views
6 replies, 6 years ago
Hadoop Online Training in India by real time Expert Topic by rehanunicom 28 Aug 2013

Hi,
UNICOM is conducting  Hadoop Online  training Batch  from 31st  August 2013. This training will help you to understand Big Data Hadoop Ecosystem and will give hands on trainings. We also provide Hadoop Classroom Trainings.
For more details you can drop a Email at contact@unicomlearning.com or you can give us a call at  +91 080 4202 3134.
Regards

1414 views
0 replies
AJI ignored with analytic function's usage Topic by SANJI 26 Aug 2013 aji, Analytic

I am testing AJI usage on a query and am trying to understand why the using the analytics would ignore the AJI….

The following query snapshot uses the JI (JI3_TRANS_DETAIL_GL)

1612 views
0 replies
group the records based on date Topic by Gowtham 12 Aug 2013 dnoeth

Hi all, could you please help me to group the records based on date. sample data and the excepted result given below.
 
Table
ID  TYPE  STDT   ENDT
 
1    A     1Aug    10Aug
1    A     11Aug  20Aug
2    B     21Aug  30Aug
2    B     31Aug  9Sep
1    A     10Sep  20Sep
 
expected result
 

1923 views
7 replies, 6 years ago
Date format transfer Topic by jasonezheng 22 Jul 2013

Hi, just wondering if there is an easy way to transfer date in number key in to date format. For example, "20130701" into "2013-07-01". The cast function will translate the number into a very wired date. 
Thanks.
Jason

1886 views
3 replies, 6 years ago
Extract Date and rebuild table view Topic by jasonezheng 18 Jul 2013

Hey Guys,
 
I have trouble to do the following work and hope you can help. PLS take a look over following example data:
 
Product_key    Start_date     End_date
A                     2013-01-01     2013-01-30
B                     2013-01-15     2013-02-07
C                     2013-02-02     2013-03-01
.
.
.
 

1592 views
1 reply, 6 years ago
Cardinality : Populate missing/non-existent elements Topic by suyog 26 Jun 2013 cardinalitydistributionmock up data

Hi,
I would like you to see teh example below and share your thoughts on the approach or solution -
Table 1
consumer, dept,frequency,recency
12345, a, 20 , 100 days
22345, a, 22 , 100 days
32345, a, 20 , 101 days

1739 views
2 replies, 6 years ago
Design change / Perf Optimization Suggestion required Topic by mjasrotia 04 Jul 2013

Table: RETAIL_SHIPMENT / Records - 7 Billion / Partitions  - 120 Weekly Partitions 
Table: CURR_YAGO_CAL - Has Weekend Dates and their Corresponding Year Ago Dates. Sample 2 records

Cal_Dt            Yago_Dt

12/26/2009    12/27/2008

12/26/2009    12/26/2009

1/2/2010        1/3/2009

1/2/2010        1/2/2010

1417 views
0 replies
Error Code 3807 not working even if .Label Topic by Niesh20us 20 Jun 2013

Hi,
bteq <<!
.set session transaction BTET;
.run file=$HOME/.tdlogon
.set errorout stdout;
.set maxerror 2;
.set width 65000;
.set titledashes off;
.set errorlevel on;
DELETE FROM UD466.FF_ACTIVE_INTAKE;
.IF ERRORCODE = 0 THEN .GOTO ACTIVEREC; /*table existed so got errorcode zero*/

4428 views
2 replies, 6 years ago
Fine tuning a query Topic by Tnewbee 10 May 2010

Hi all!

I want to optimize this query given below. There are 50 such queries and each query takes about 2 min. These queries are auto-generated and are dependent on the user interface.
So if the user logic changes these queries can get updated,deleted or added.As of today there are 50 such queries. Each of this query is joined
with the 'BIG' table which has 2 million records. Also this part of the query(SELECT DISTINCT FLD1, NEWFLD, FLD3 FROM DB.RUN2 WHERE

10728 views
8 replies, 6 years ago
UII and PJI? Topic by ahtandon 11 Jun 2013

Hi All
 
Could anyone please advise as to what are UII and PJI while calculating the query cost and how to calculate these parameters, thanks.
 
Regards.
 
AH.

7063 views
2 replies, 6 years ago
TeradataR Question about kemans analysis Topic by attackover 24 Apr 2013 teradatar, td.kmeans, cluster, analysis

HI,
I am using teradataR (1.01) to do some clustering analysis, but I found the td.kmeans function can only receive a full table as the input.
So my question is can I assign some columns to td.kmeans and make it do analysis only on these columns?
like this way:
>  test <- td.data.frame("test", "testdb")
>  td.kmeans( cbind(test["x"], test["y"]) )

1749 views
2 replies, 6 years ago
IBM DataStage Self Self Learning, Topic by ManishNayek 29 May 2013 IBM DataStage Self Self Learning

 
Sort value and Range Map : http://www.scribd.com/doc/132789841
Implementing Change Data Capture : http://www.scribd.com/doc/133374543

1958 views
0 replies
Translate loop into Teradata Stored Procedure Topic by adtrombley 28 May 2013 #sql, #STOREDPROCEDURE, #teradata

How can I translate this loop into Teradata SQL?
 

DECLARE @logdate DATETIME  

DECLARE @hrinput1 INTEGER

DECLARE @hrinput2 INTEGER

SET @logdate = '2013-03-01' 

SET @hrinput1 = '0'

SET @hrinput2 = '1'

 

while @logdate <= '2013-04-01' 

BEGIN 

--reset parameter values

set @hrinput1 = '0'

1873 views
0 replies

Pages