remove "whitespaces" and "." in a string
Topic by gmoney
2 days ago
I have a table with a column of alpha-numeric data the currently has multiple
(periods) "." and spaces in the string.
I need to remove them for data compare in another DBMS.
I have searched not only through this forum but others as well and can not
seem to find the solution.
Note: orereplace is not an option as it is not installed and have no way to
get it installed.
Here are a few examples of how the data is currently formated:
99.ABCD.123456..ABCD
|
80 views
|
2 replies,
1 day ago
|
Date Function
Topic by Vimal
21 May 2007
I want select month name and date from a date column. For Ex. My output
should be '15-JAN'. Plz help me how to do it in Teradata, coz i am new to it.
|
25279 views
|
5 replies,
1 day ago
|
TERADATA CERTIFICATION
Topic by ruchi
24 Nov 2008
Hi I want to give Teradat cerification .(Basic & Sql ). can anyone suggest me
which book is good for the preparation .Any input is appreciable
Thanks
Ruchi
|
33261 views
|
13 replies,
1 week ago
|
Multiple Database connections in a query
Topic by woodje
12 Aug 2011
Hello, I am pulling data from an oracle 11g database. And would like to
connect to our teradata data warehouse to enrich this data. I am using Toad
for Analytics and have connections setup and can run queries seperatly from
the two databases. However I want to Inner join the two in one query. Can
this be done? If so can you direct me to some examples so I can learn how to
accomplish this. Thanks, Jeff
|
1898 views
|
1 reply,
2 weeks ago
|
Query with FORMAT'$$$,$$9.99' Not displaying $ as expected.
Topic by gmoney
2 weeks ago
I have a query that runs fine except in my results I am not getting a $ in my
currency column.
Here is the line I am using:
sum(CHRGE_AMT)(FORMAT'$$$,$$9.99') MRC,
my results are still simply 136.25 not $136.25 as expected.
Any thoughts on what might be preventing it from displaying?
Trivial Yes, but I am sure you have had that boss at one time or another as
well.
Release is 12.00.02.44 *Version* 12.00.02.40
Thanks for looking.
|
293 views
|
2 replies,
2 weeks ago
|
Date gap analysis
Topic by Sudhar
14 Nov 2011
Hi All,
I am trying to find out the records with dates overlapped or continous and
then making it as a single record with the minimum date to the max date.
Here is the example of what i am trying to achieve.
Table 1
|
1900 views
|
4 replies,
3 weeks ago
|
insert Data
Topic by eejimkos
8 weeks ago
Hello,
When you insert data in a table (from zero point,with no data ...),it is
better to drop it or delete it?Meaning,keeping the stats will help or will
slow down the performance of inserting.It is better to drop the indexes and
then re-create them?Or,leave them and let them built during inserting?
Thanks.
|
984 views
|
1 reply,
3 weeks ago
|
Need Help for TWM
Topic by dinesh.agrawal
7 weeks ago
hi,
i am using TWM.and i want to know is anybody knew that how to detect fraud
using Teradata warehouse miner and how it can be inplemented in it? or any
example anybody have or studycase for it. please share it?
thanks in advance,rgds,Dinesh Agrawal
|
839 views
|
1 reply,
3 weeks ago
|
run queries in parallel and serial
Topic by eejimkos
8 weeks ago
Hello,
I have a question ,
I want to execute three sql statements,sql1 - sql2 -sql3.
I want to run them from bteq.
How can i run sql1 and sql2 in parallel and then sql3?
I tried with cmd,calling seperate files of bteq but nothing.
By ".run file" the same.
By putting the ";" at the next line is just an implicit transaction,no
parallel.
how can I manage this situation?
Thank you very much.
|
1015 views
|
0 replies
|
How to use Fastexport exit codes in UNIX Shell Script
Topic by terankit
8 weeks ago
Hi,
In my shell script I am using BTEQ, which is doing Fastexport. I will get two
return codes. One from BTEQ and another from Fast Export. I want to use the
Fast Export Return code in my Unix script to do the further processing.
I found that return codes automatically stores in $? and we can use that. but
it is not working.
If RC !=0 then
do not merge the files
else
merge the files
fi
Thanks,
Terankit
|
1042 views
|
2 replies,
8 weeks ago
|
Teradata Services
Topic by rajdaksha
25 May 2009
Hi
I 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.
by
raj
|
7658 views
|
8 replies,
8 weeks ago
|
group data by ranges
Topic by CuriaG
01 Sep 2011
Hi
I'm new to this but i need to make this:
I have the following values
|
1930 views
|
2 replies,
8 weeks ago
|
Query_Discussion_HELP
Topic by eejimkos
10 weeks ago
Hello,
First of all thanks for your time.
I am very new in Teradata and I would like your opinion about this query.. (=
execution plan)
The query just joins 10 times my fact table(1 Billion rows).The dimension
tables are really small.
So every time I need to access my main enormous one table.Even to make join
index for each join,I am out of spool,I increased until 10Gb, ..
1)statistics are ok
2)many secondary indexes
3)no skew
Here is the execution plan.
|
1904 views
|
10 replies,
8 weeks ago
|
To find record counts for all tables in a particular database
Topic by Sandi
07 Oct 2008
Hi,
Can someone help me to write a query to pull Record counts for all tables in
a particular database or record counts for all tables present in Teradata.
Thanks a lot
|
9271 views
|
5 replies,
9 weeks ago
|
Connecting remotely through TeradataR with LDAP Authentication
Topic by jquinn2
9 weeks ago
Hi All-
I have a puzzling situation. I've been using the TeradataR package in R to
connect to my company's teradata databases for a while now, but I can't seem
to figure out why I can't connect remotely. I thought when I originally
started using teradataR, I could connect remotely, but I can't any more.
|
965 views
|
0 replies
|
Need help with adding an integer column to a date column in teradata
Topic by divyarajnarain
9 weeks ago
Hello,
I am trying to create a measure in business objects using the formula:
(order_date + pflt)
where the order_date is a normal date and the pflt is an integer column in
teradata
When I try to add the pflt to the date field, I get the error: Invalid date
supplied for dbname.pflt
sql used: select order_date + pflt as duedate from dbname.viewname;
Can someone please help me with this query?
Thanks in advance,
Divya
|
1180 views
|
4 replies,
9 weeks ago
|
Combining 4 tables and prioritize the data in them?
Topic by terankit
10 weeks ago
Hi All,
I am new to Teradata world and in trouble. I have a requirement, hope I will
get help from you guys. I will try to be as much clear as I can, further
clarification will be provided if needed.
|
1118 views
|
8 replies,
10 weeks ago
|
I want to extract number from String
Topic by RahulG
14 Jul 2008
Suppose I have string like
RD_S0310
RD_153
RDH_S0906
RD_S0083
I want output
0310
153
0906
0083
How can I do this
|
13126 views
|
2 replies,
10 weeks ago
|
Connecting to Business Objects without ODBC
Topic by sid19840
10 weeks ago
Are there ways to connect Teradata to Business Objects (BO Webi/BO Analyzer)
without using an ODBC connection?
|
797 views
|
0 replies
|
Concatenate Rows In A Table
Topic by pmhere
21 Mar 2007
Hi,
I am looking for a query that can do the following.
Input
Column1 Column2
1 A
1 B
1 C
2 D
2 E
2 F
3 G
4 H
4 I
Output
Column 1 Column2
1 A,B,C
2 D,E,F
3 G
4 H,I
Please suggest.
Thanks
Prashant
|
20221 views
|
3 replies,
10 weeks ago
|
buy oak wood
Topic by alprofcolet
10 weeks ago
teak wood buy raw wood for sale keighley timber merchants wood pellet boilers
for sale [1] wood fence panels for sale where to buy koa wood wood gates for
sale purple heart wood for sale [2] where can i buy wood buy rough cut lumber
dark oak wood wood screen doors for sale [3] outdoor lumber fisher wood stove
for sale cocobolo lumber wood logs for sale [4] timber merchants tamworth
reclaimed hardw
[1] http://www.woodfromukraine.com/en/products
[2] http://www.woodfromukraine.com/en/products
[3] http://www.woodfromukraine.com/en/products
[4] http://woodfromukraine.com
|
999 views
|
0 replies
|
how to compute the kpi using sql
Topic by tong
19 Aug 2007
Hi,I need to compute a kpi named "Low-grade Silent Customers"
which means customers that haven't use our specific service for
3 months to 1 year.In our data warehouse,we store specific service
usage records in separate tables by month,and each table has more
than one hundred million recodes,who can give me a smart sql?
|
37268 views
|
9 replies,
10 weeks ago
|
SELECT Failed. 3706: Syntax error: expected something between '(' and the 'select' keyword.
Topic by bdwebman
31 Mar 2011
I am troubling over this error as I am not sure what the cause might be. Any
help would be greatly appreciated. select Id, (select case when Fall_score =
b.MaxScore then 'Fall' when Spring_score = b.MaxScore then 'Spring' from
sandbox.testtable t where t.Id = b.Id ) as MaxScoreCategory,MaxScore from
(select Id, max(Score) as MaxScore from (select Id, 'Fall', Fall_score from
sandbox.testtable union all select Id, 'Spring', Spring_score from
sandbox.testtable) a (Id, Category, Score)
|
5652 views
|
8 replies,
12 weeks ago
|
get the max from table that has 2 columns unique and one duplicate
Topic by geom
12 weeks ago
Ok I was sure I knew how to do this but for some reason what I was working on
was not working.
I have a table with structure like this
AccountNO TelephoneNO Start_Date
1234567 5191111111 01/03/2011
7654321 5191111111 04/03/2011
|
1220 views
|
1 reply,
12 weeks ago
|
AJI Hits Report from DBQLObjTbl table - Query?
Topic by soumyasin
28 Nov 2011
Hi,
I guess we can find out the relevance/ frequency of usage of an AJI from the
table DBQLObjTbl. Can someone please let me know how?
The purpose is to find out the unused or less used AJIs in the system and
thereby dropping them or finding a way to use.
Appreciate any help in this matter.
|
1668 views
|
1 reply,
13 weeks ago
|
