All Forums

For topics that do not belong to another forum. This includes general development topics, such as Java, .NET, User Interface design, etc., as well as discussion of the Teradata Developer Exchange itself. For articles, blogs and more, see the General section of the site. Do not post SQL or database questions here; they belong in the Database forum. JDBC/ODBC questions belong in Connectivity.

You must login to post to the forums.
Could you please provide Guidence for learning Teradata SQL Topic by ahmed1729 04 Feb 2016 Learning Teradata SQL

Hi Gurus,

 

 

Could any one please provide guidence for learning Teradata SQL.

 

My problem is i don't know where to start. I know SQL and database concepts from Engineering,

have used SQL (moslty select statements) while doing ETL Testing in 4 years of my career.

 

137 views
2 replies, 3 years ago
Round function in Teradata Topic by b4ahmad 07 Mar 2016 decimal not rounding, Round function oracle vs teradata

Hi everyone,
I am using teradata version 14
          I found a strange behavoir in teradata by applying Round function.. Here is an example
select  ROUND(178.22/100,5)
it gives the result as 1.78 --  and in other databases like oracle it gives the result 1.7822 

436 views
4 replies, 3 years ago
Need help in pointing out the exact issue leading to high CPU usage to improve query performance. Topic by sou2011mik 11 Sep 2015 performance issues
2. We do an all-AMPs RETRIEVE step from TEST_DB.TEST_TABLE by way of
an all-rows scan with no residual conditions into Spool 5
(all_amps) (compressed columns allowed), which is built
locally on the AMPs.  Then we do a SORT to order Spool 5 by
the hash code of (TEST_DB.TEST_TABLE.col_A,
TEST_DB.TEST_TABLE.col_B, TEST_DB.TEST_TABLE.col_C,
503 views
2 replies, 3 years ago
REMOVE SPECIAL CHARACTERS USING MLOAD Topic by vinay4125 26 Feb 2016 REMOVE SPECIAL CHARACTERS USING MLOAD

Hi Team, 
            Can you please guide me, how can we remove the Special Characters using mload script
Special Characters (¿ Ã Â � Ó Ø)  , I want to replace it with space...
Ex: i/p :  A¿B
 o/p: A B
 
 
Sample Mload Script :
 
.Layout InputFileLayout;

.Field Col1 * VARCHAR(1000);

.Field Col2 * VARCHAR(1000);

111 views
0 replies
Teradata Express 15.0 - This Virtual Machine Requires AVX2 but AVX is not present. Topic by srinig.dw 15 Feb 2016

Trying to start the TDExpress Virtual Machine
Getting the following error:
TDExpress15.10.0.7_Sles11_40GB_vp - VMWare Workstation
This Virtual Machine Requires AVX2 but AVX is not present. This virtual machine can't be powered on.
Anyone experianced this error?
 
 

478 views
5 replies, 3 years ago
.COMPILE throws error 7947 in spite of having only one Replace Procedure Statement in BTEQ Topic by larun1616 25 Jan 2016 .COMPILE, bteq

I have a 430 Lines of Stored procedure in a SQL file. When i compile it using .COMPILE FILE <Filename> command in BTEQ, i get ERROR 7947:Only create/replace procedure allowed. My file contains only one statment replace procedure stament with includes DECLARE, EXCEPETION HANDLING AND BODY sections, but still I keep getting this error.

255 views
2 replies, 3 years ago
Is dropping/creating tables over and over an ok or should you leave the table structure in place? Topic by dsldsl1980 12 Feb 2014

I have heard that Teradata does not like dropping and re-creating tables in production processes.  In cases where a volatile table is not possible due to multipule sessions is it prefered to leave an empty table structure in place or drop and recreate it?  Please provide detail as to why one is better than another if possible.

2201 views
11 replies, 3 years ago
Unable to open firefox on TD14 express Topic by Nishanthi 22 Feb 2016

I am new to Tearadata, i tried to open firefox , but it keep on saying "unable to connect". 

84 views
0 replies
Teradata Roles Based Privileges And User Based Privileges Topic by Sean_Kelly 18 Feb 2016 privileges

Hello,
Looking for some advise,

194 views
2 replies, 3 years ago
Dirty Reads <Requesting Guidance> Topic by niranjan_nr000 15 Feb 2016 dirty read, lock

Hi All,
Please consider a scenario:
A table (contains 10 records) is being loaded with some records (20 records).
It takes 5 mins to retrieve the records from the table.
While User 1 is running a select on the table , in parallel select User 2 runs an insert which inerts 1 records in 60 seconds.

157 views
2 replies, 3 years ago
Looking for guidance on building a Teradata warehouse from scratch. Topic by rorydph 02 Oct 2015 agile, data warehousing, tools, GCFR, data transformation

We have a shiny new Teradata appliance that we're about to embark on developing a new data warehouse with (FSLDM format). We have DataStage to land the data into Acquisition but I can find little information on best practices for setting up my Agile team to succeed when it comes to the in-database ELT processes e.g.

723 views
1 reply, 3 years ago
Teradata Driver][Teradata Database] Invalid operation for DateTime or Interval. Topic by sanjeev_ranjan 12 Feb 2016

Can somebody help please . Thanks in advance :)

 

 

SELECT 

StartDate, GRP_CD, Sum(ORG_SCH_STAFF_VAL) "Plan_Staff", SUM(ORIG_FCST_VOL) "Plan_Offered"

FROM 

 

(SELECT 

to_char(to_date('30-12-1899', 'DD-MON-YYYY') +

 ((forDet.STRT_TM - (SELECT BIAS_IN_MIN FROM EWFM_TM_ZN_DTL TZ 

106 views
2 replies, 3 years ago
Teradata Groups Topic by fanigadu20 11 Feb 2016

Hi all,
I am new to teradata. 
I would like to know like in AD there are builtin groups along with with other local groups, are there a similar builtin groups and all other groups exist in teradata?
 
Thanks In Advance.

98 views
1 reply, 3 years ago
AWP DATA Topic by Gustavo Woltmann 10 Feb 2016

Hi All,
 
Could anyone help me out on how many AWTS are used by the below utilities:
1) BTEQ
2) Fast Load
3) Multiload

64 views
0 replies
Teradata perm space release issue Topic by Tdusersam 07 Feb 2016 Perm space release, space, empty table perm

We have a scenario in our teradata database where perm space is not getting released even when we delete all rows from the tables. Also, under the same condition the current perm of 2 replica tables with same rowcount, same structure and same index are deviating by 300% . when in a manual effort, we dropped and recreated the table, the currentperm was back to expected.

170 views
2 replies, 3 years ago
Unicode (German) characters are not getting displayed properly in Teradata SQL Assistant Topic by sunilsaw 02 Feb 2016

Environment -
Data Base Version: Teradata 15.00.0404
ODBC: ODBC 15.00.00.01
Teradata SQL Assistant 15.00 (Installed on Windows 7 Ultimate)
German Display Language is also installed in Windows 7

489 views
2 replies, 3 years ago
ROW_NUMBER, ROW_OVER, OVER(PARTITION BY), QUALIFY Topic by LMC.0101 02 Feb 2016

When is it best to use ROW_NUMBER, ROW_OVER, OVER(PARTITION BY), QUALIFY? 
What is the best way to remove duplicates from queries, and does it hurt performance/tuning?

113 views
0 replies
Encryption Topic by radsubra 01 Feb 2016

We are looking to encrypt data in pur system Is there any UDF which we can use it for encryption ?

112 views
0 replies
Teradata Front End Web Application ? Topic by Subhash.Gander 01 Feb 2016 Front End Web Application

All,

 

I am exploring the opportunities to have front end web based application on Teradata Enterprise Data Warehouse.

 

Intend of this application is to pilot automation of Reference Data Management capability with Business users.

 

130 views
0 replies
Query looping Topic by vinay4125 29 Jan 2016

How to write a query... looping, please find the attached image

84 views
0 replies
Replace View - expected something between the word... Topic by hancieta 27 Jan 2016

Hi, I have very little time in Teradata and have found quite interesting. However I have a technical problem, I want to replace a view but gives me an error, however, the SELECT works perfectly. Please help. First of all, Thanks!!

133 views
2 replies, 3 years ago
virtual machine performance Topic by b4ahmad 27 Jan 2016 amps, vm, virtual machine, download, performance

Hi, I am new to teradata learning, I have download vm Express edition for testing purpose, but this is a very limited in performance, i want to test a machine have a little bit big data, ALL i have to face that, when ever i run a query especially with aggregation, i takes lots of mins to perform the result having 0.5 millions of rows

270 views
6 replies, 3 years ago
FETCH TABLE NAMES WITH INDEX COLUMN NAMES Topic by vinay4125 25 Jan 2016 FETCH TABLE NAMES WITH primary INDEX COLUMN NAMES

Hi, 
  i have nearly 5000 tables in my DB, I want all the list of table names and primary index column names for those tables.
for all the tables there are Primary Index(may be on single or multiple columns), Can you please send me the sql statment to get reach my requirement 

98 views
1 reply, 3 years ago
Importing data to several datatables with BTEQ Topic by nartla 25 Jan 2016

Hello,
My problem is the following :
- I use FLOAD to import data from flat files to a temporary datatable.
- Next, I want to transfer the data from the temporary table to my definitive table with BTEQ.

86 views
0 replies
PMCP Topic by Raja_KT 27 Dec 2013

Hi,
Is PMCP coming along with TD installation ? I am curious since I am not able to see PMCPINFO  views.
Thanks and regards,
Raja

1093 views
4 replies, 3 years ago

Pages