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.
1 MB data block size in 14.10 Topic by radsubra 26 Aug 2015

By increasing the data block size can we improve the performance of complex report queries. What are the pros and cons of increasing data block size?
Has anyone noticed improvement in performance by increasing data block size?
Thanks,
Radha
 
 
 

854 views
4 replies, 4 years ago
Converting SQL Server Query to Teradata Topic by kiranrajpv 28 Sep 2015 Converting SQL Server Query to Teradata

It's basically Date Consolidation & getting minimum price from the overlapping dates 

DROP TABLE tmp_mtrl_price

CREATE TABLE tmp_mtrl_price

(

  Frcst_Altr_Id varchar(100),

  Item varchar(100),

  Geo_Cd varchar(10),

  Start DATETIME,

  [End] DATETIME,

  Price DECIMAL(13,2)

)

 

670 views
0 replies
Using TD express VM Topic by sxtech 25 Sep 2015 #database #teradata express #support utilities

I want to setup a sandbox environment in my office for folks to learn Teradata. Can I use TD Express VM for this? If not, what other options do i have? Thanks.

737 views
0 replies
Minimum space needed for a database during Online Archiving Topic by varanasianup 24 Sep 2015 online archive logging, backup

Hi All,
 
Our Backup failed due to "no room in database" error,
The offending database had max perm of 54 mb,.. and current perm of 10mb..
My question how much minimum space is required for creating online logs during Online Archiving ?
 
Thank you
Anup

805 views
0 replies
Regular Expression guide for regular expression functions Topic by anishgoyal007 22 Sep 2015

Is there any document available for understanding the regular expressions used by regular expression functions like REGEXP_SUBSTR, REGEXP_SIMILAR etc.

896 views
2 replies, 4 years ago
COGNOS Online Training Topic by likitha83 22 Sep 2015

SURYA TRAININGS offers best COGNOS Online Training. It is great opportunity whoever wants to learn COGNOS course through online because we have highly dedicated and experienced COGNOS professional trainers. Our trainers will teach from basic level to advanced level with real time projects. We also providing complete set of COGNOS material for our students.

426 views
0 replies
How to get unique ID for the concurrent jobs Topic by Vani1 19 Feb 2015

Hi:
 
One of our prod table is facing duplicate id issue. Please give me suggestions on how can we avoid the duplicate id generation.
Here is the senario:
we have 4 differrent SPs and they are on active for 24/7.
Each proc loads the data to same target table from 4 diff stage tables whenever the data is available.
Below are 4 queries which run by SP's.

2167 views
8 replies, 4 years ago
Which DBS Control Settings Should be changed for changing TIMEZONE? Topic by mihirdhakan93 16 Sep 2015 dbs control, timezone, dbs settings, timezone change, data issue

Hi Guys,
i have come up with a situation where the data comes from different server and now i want to get them all in Common TIMESZONE - i.e AEST (Australia Eastern) , so Help me in Identifying what all Settings in DBS needs to be changed for the Same?
Thanks in Advance.
 
 

590 views
1 reply, 4 years ago
pick a NUPI over an UPI because the NUPI column may be more effective Topic by chill3che 12 Jan 2013

Hi Experts,
I am a beginner in Teradata and would like to know the below 
You might pick a NUPI over an UPI because the NUPI column may be more effective for query access and joins.
 
Can you please elucidate this.
 
 
 

9422 views
4 replies, 4 years ago
Row header, table header and block header Topic by shivkumar 06 Sep 2015

Hi All,
 
Please give detail explanation about the row header, block header and table header 
 
Thanks,
Shivkumar

1073 views
2 replies, 4 years ago
Infographic: Custom Code in BI Environments Topic by Deever 17 Sep 2015 custom code, enterprise data architecture, data lineage, data flow, business intelligence, enterprise intelligence

Hi,

 

we are dealing with massive amounts of custom code in BI and we've put together an infographic to illustrate which parts of business intelligence environments suffer the most from heavy loads of handcoded scripts.

 

Picture is attached to this message. 

 

773 views
0 replies
Cylinder and blocks Topic by radsubra 16 Sep 2015

We have large cylinder with 23232 sectors. When I create a table and insert data how do I find out how many blocks it is using.

 

 

1131 views
0 replies
Getting Error "Error Translating column value to target data typeReached LOB segments threshold limit." Topic by PAVAN1K 12 Sep 2015

While working with the XML data type. I am getting the Error "Error in function XML Table:Error Translating column value to target data typeReached LOB segments threshold limit."
 
Can any one have idea, how to work on this error.
Thanks & Regards,
Pavan

430 views
0 replies
Teradata Express VM documentation Topic by gbaren 09 Sep 2015 VM documentation

Where can I find documentation for using the Teradata Express VM? Things like the user id and password for the VM as well as some basic up-and-running information.
Any documentation on Teradata SQL syntax and such would also be helpful.
Thanks.
 

409 views
0 replies
Teradata Ccontrol Framework and relevant documentation Topic by koibito99 08 Sep 2015

Hello All,
I have been trying to find details about TCF and any available documentation for the same but the effort was not fruitful.
Could you please help by sharing more about it?
Thanks in advance.

416 views
0 replies
Build Teradata module for Kundera Topic by kundera 07 Sep 2015

Hi ,

356 views
0 replies
How to find CONSECUTIVE values coming in a column(TERADATA) Topic by VJAIN786 03 Sep 2015

HI,
I have a table A having 1 column which is having integer values( Consecutive & Non-Consecutive) like below:

column1

7

4

2

3

5

6

9

10

11

 

Now i need to write a query which shows YES for consecutive values and NO for Non-Consecutive values like below:

 

724 views
3 replies, 4 years ago
to show the special character while selecting from table Topic by fayaz87 04 Sep 2015

In TD the value for interest_1 is getting displayed as ‘¸koda Yeti’ , But the actual value is “Škoda Yeti”.

487 views
1 reply, 4 years ago
Return Code for script Shell In Bteq Topic by bsaadan 03 Sep 2015

Hello,
Please I need Help,
I want to know How to test a return code for Shell Called in Bteq with OS command
Example :

bteq <<! > $FIC_LOG 2>&1

$User

.set errorout stdout

.set echoreq on

 

.OS sh ./exit_12.sh $1 $2 $3

 

.quit 

 

!

 

429 views
0 replies
Spoil Table information in Data Dictionary Topic by radsubra 01 Sep 2015

Iam getting SPLTBL(Spoil Table information in Data Dictionary)  as one of the step(last step before End transaction) when Iam trying to insert into a table .
  This insert runs every 15 minutes since this is NRT( NEar real time) and we also delete the data from the table before inserting.
Once insert is completed we collect stats.
So this is the process
 

396 views
0 replies
Spoil Table information in Data Dictionary Topic by radsubra 28 Aug 2015

What is the meaning of Spoil Table information in Data Dictionary . Will this affect performance?
 
Iam getting this while executing as one of the query in the explain plan --steps SPLTBL

722 views
4 replies, 4 years ago
convert julian 5 digit number to regular date Topic by Alsallam 31 Aug 2015 Julian to regular date

I have the following field with julian numbers:

Date_Created
14304
14365
and so on.
I used the following formula
SELECT  CAST(CAST(Date_Created AS CHAR(7)) AS DATE FORMAT 'yyddd') FROM US_DWRP_TMO_R01.TDAIMFO
However, the returned date was in the wrong year (1900), for example:

677 views
1 reply, 4 years ago
How to create a dynamic concatenation Topic by Alsallam 28 Aug 2015 Dynamic Concatenation

I am trying to concatenate 2 fields ACCT_NO and BR_NO where both fields should add up to 12 character and if not I should add leading zeros. concatenation must have a suffix of TDA. For example:
000007560486TDA
However, the BR_N0 can be one, two, three, or more digits and hence the number of concatenated zeros will change. Here is an example:

936 views
6 replies, 4 years ago
SQL (combine multiple insert-sel statements into one ) Topic by Abhishektd 26 Aug 2015 #sql

Hi ,
I want to merge following multiple insert - select statements into a single insert-select statement without using UNION/UNION ALL. Please suggest.
 
INSERT INTO Fact
SELECT DATE AS LOAD_DT
, key_id
, 200 AS S_id
, device_id
, seg_id
, insight_id
, 5040 AS m_id
, SUM(no_pmt) AS VAL
FROM Payment

909 views
4 replies, 4 years ago
Teradata Express tbuild Error Topic by Chris_1776 28 Aug 2015

Hi everyone. Thank you for the effort you put into the Teradata message forums, it is greatly appreciated. While I know Teradata express is not supported, I have ran into an obstacle and thought someone may be familar with it, the information is below. If anyone else has had similar issues or can contribute ideas I would be grateful.

724 views
1 reply, 4 years ago

Pages