All Forums

For topics on Teradata’s Unified Data Architecture and associated enterprise-level features and products. Potential topics could include integrations in and around Teradata, Aster, and Hadoop as well as supporting technologies like Connectors, QueryGrid, Backup/Restore, Multi-Systems, and the Unity product suite (Director, Loader, Data Mover, Ecosystem Manager).

You must login to post to the forums.
Select (SHOW sometable) into volatile table Topic by pxr 30 Oct 2009

hi,i am a tester. After changes in some object (or in some source object etc) the first thing we have to test is to compare old and new object whether only the changes documented are done. I would like to somehow make this process automatic.To compare two sometables (prod and test) we just manually compare the output of "SHOW sometable" from different environments.

10590 views
3 replies, 11 years ago
Any DBC tables to find the row length of a table? Topic by EDW ETL 14 Mar 2008

Hi,Is there any DBC tables that I can use to find out what's the Total Row Length of a row in the TERADATA table?Thanks

30654 views
2 replies, 11 years ago
Interval Overflow Error Topic by papvan 29 Oct 2009

Hi,I am having a column where the time is sorted as ddd hh:min:ss. The col has many 3 digit days & when database sums them all...the total is more than "4 digit days".If I try for interval: day(5) to second(0)....its not working.Is there a way to accomodate sum of days more than 4 digits? 953 21:34:15 846 19:54:20 748 03:24:65 702 11:34:94 675 23:42:58 644 20:13:40 562 23:08:55 534 16:12:39 468 12:53:58 394 15:25:14 343 08:12:28 298 07:30:98 250 05:39:74Let me know, how it can be resolved. Thanks

9517 views
1 reply, 11 years ago
Altering a table Topic by Greyghost 03 Sep 2009

Hello,Can I add a key and partitions to a table by using the Alter statement, or are these best handled by creating a new table with the keys and partitions defined and then inserting the old table data into the new? The table is very, very large.Thanks!Paul

15019 views
2 replies, 11 years ago
SQL Question. Topic by RGlass 26 Oct 2009

User would like a view built on table that would return a record for each date between eff_bgn_dt and eff_end_dt having invry_qty constant for each group of records.Table Structure:CREATE TABLE PRODUCT.RTL_INVRY_RDF_EOD( Loc_Id SMALLINT NOT NULL , Wd_Cd INTEGER NOT NULL , Eff_Bgn_Dt DATE NOT NULL FORMAT 'YYYY-MM-DD' , Eff_End_Dt DATE NOT NULL FORMAT 'YYYY-MM-DD' , Invry_Qty DECIMAL(9,2) NOT NULL , Adt_Id INTEGER NOT NULL ) PRIMARY INDEX RTL_INVRY_RDF_EOD_NUPI ( Loc_Id, Wd_Cd );sel loc_id,wd_cd,eff_bgn_dt,eff_end_dt,invry_qty from dsb.rtl_invry order by 3 ;Loc_Id Wd_Cd Eff_Bgn_Dt Eff_End_Dt Invry_Qty2 200,041 2009-10-13 2009-10-17 35.002 200,041 2009-10-18 2009-10-19 33.002 200,041 2009-10-20 2009-10-20 30.002 200,041 2009-10-21 2009-10-21 21.002 200,041 2009-10-22 9999-12-31 33.00View:example:sel loc_id,wd_cd,eff_bgn_dt ,invry_qty from dsb.rtl_invry order by 3 ;Loc_Id Wd_Cd Eff_Bgn_Dt Invry_Qty2 200041 2009-10-13 352 200041 2009-10-14 352 200041 2009-10-15 352 200041 2009-10-16 352 200041 2009-10-17 352 200041 2009-10-18 332 200041 2009-10-19 332 200041 2009-10-20 302 200041 2009-10-21 212 200041 2009-10-22 33RDBMS 12.00.02.17Any Ideas appreciated.Thanks, R Glass

8537 views
2 replies, 11 years ago
Tpump loader Error Topic by UpaMishra 23 Sep 2009

I got the following Error while executing a Tpump loader script.**** 14:23:05 UTY3401 End of file was reached with an unbalanced number of quotes being found in the text.Please suggest if anyone is familiar with this type of error

9745 views
1 reply, 11 years ago
A bit of mathermatics Topic by marcmc 06 Oct 2009

Hi.I have a formula to calculate a unique transaction sequence number that works as follows:transaction sequence(TS) * 100 + record sequence(RS)So take two examples:118(TS) * 100 + 103(RS) = 1190399(TS) * 100 + 50 = 9950From the results I need to be able to get back to determine the original TS and RS.The solution has to work for both examples above.So in the case of 11903 I need to get back to

8899 views
3 replies, 11 years ago
Data Warehousing/BI Software Topic by john_sm 03 May 2008

Hey guys, I was just wondering, what software do you primarily use in Business Intelligence/Datawarehousing, and are their any significant cutbacks in any proposed projects

17048 views
3 replies, 11 years ago
Regarding Active Access response times Topic by Ritter 07 Oct 2009

What coding techniques are best to get a few rows access under half a second?

8868 views
1 reply, 11 years ago
performance tuning or query tuning Topic by R lal 25 Sep 2009

DELETE FROM A_BCIDDB.CREDIT_ENTRIES_CT T1WHERE EXISTS(SELECT '1' FROM L_DLYBCIDDB.CREDIT_ENTRIES_TEMP T2 WHERE T1.MI_ACCOUNT_IDENTIFIER = T2.MI_ACCOUNT_IDENTIFIER AND T1.ENTRY_AMOUNT = T2.ENTRY_AMOUNT AND ( (T1.ENTRY_SOURCE_CODE = T2.ENTRY_SOURCE_CODE AND T1.ENTRY_CODE = T2.ENTRY_CODE AND T1.ENTRY_DATE <= T2.ENTRY_DATE ) OR T1.ENTRY_SEQUENCE_NUMBER = T2.ENTRY_SEQUENCE_NUMBER) ) AND T1.ENTRY_AMOUNT_CODE = 4; CREDIT_ENTRIES_CT has nearly 2.2 billon rows.CREDIT_ENTRIES_TEMP has nearly 6 million rows.i have all the recommended stats.can we change the query ?Please help .....

13128 views
4 replies, 11 years ago
Date Range Syntax Topic by andscott 07 Oct 2009

I have a syntax question on Teradata date ranges. I Have the following SQL, and am getting the following error.

18974 views
1 reply, 11 years ago
Table alter timestamp Topic by UpaMishra 06 Oct 2009

Is there any metadata table/view where one can find the last modification time of the table. If we alter a table to add a new column, or drop an existing column, or any chnage to table structure, in Oracle, there is a metadata table (all_objects) where we can find the last modification timestamp.I am looking for the same functionality in TERADATA. Please suggest.

10115 views
1 reply, 11 years ago
Help with Table Partitioning Topic by tony123 03 Sep 2009

Can some please help me as I am quite new to teradata.I've created a fact table as follows:CREATE MULTISET TABLE FACT ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT ( ACCOUNT_ID VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC, PERIOD_DATE DATE, REGION VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC, AMOUNT DECIMAL )PRIMARY INDEX ( ACCOUNT_ID )PARTIONED BY REGION; 1. There are multilpe jobs/scripts performing DELETE and INSERT commands to this table at the same time in parallel. For instance Job 1: DELETE FROM FACT WHERE PERIOD_DATE BETWEEN '2009-01-01' and '2009-10-01' AND REGION = 'ABC'; /* Start inserting into FACT for REGION = 'ABC' and for PERIOD_DATE BETWEEN '2009-01-01' and '2009-10-01' */ INSERT INTO FACT FROM TMP.TABLE; For instance Job 2: DELETE FROM FACT WHERE PERIOD_DATE BETWEEN '2009-01-01' and '2009-10-01' AND REGION = 'DEF'; /* Start inserting into FACT for REGION = 'DEF' and for PERIOD_DATE BETWEEN '2009-01-01' and '2009-10-01' */ INSERT INTO FACT FROM TMP.TABLE; For instance Job 3: DELETE FROM FACT WHERE PERIOD_DATE BETWEEN '2009-01-01' and '2009-10-01' AND REGION = 'GHI'; /* Start inserting into FACT for REGION = 'GHI' and for PERIOD_DATE BETWEEN '2009-01-01' and '2009-10-01' */ INSERT INTO FACT FROM TMP.TABLE; I've created my FACT table as a MULTISET with a NON-UNIQUE primary key, partitioned by REGION prevent locking when inserting into the table. 1) Since all 3 jobs are deleting and inserting at the same time, will there be any issues with locking ? I've read that row hash locking will still occur . 2) Any performance issues ? It is anticipated that the data for each REGION period will be in the 10's million's. tony

14785 views
3 replies, 11 years ago
Data integration tool in Chinese? Topic by ofdabler 22 Sep 2009

Hello to all, Being in a pretty much international company, I have come here to ask a few things about ETL tools and their different languages. We have offices in the US, in Europe (Italy, France) and in China. We think English is fine but our European team and Chinese team especially would like to get software in their language.

8483 views
1 reply, 11 years ago
Teradata Schema Topic by Ansh 06 Sep 2009

Hi,Could you please tell me which schema does Teradata follows:Star Schemaor Snow Flake Schemaor 3rd Normalized schema

12438 views
3 replies, 11 years ago
What mean TotalCPUTime Topic by Dramis 14 Sep 2009

I would like to know how to interpret the column TotalCPUTime in the table DBC.DBQLogTbl.I have 251.83, is it 251.83 millstones ?Thank you

8817 views
1 reply, 11 years ago
ROW_NUMBER() - numeric overflow error Topic by deagle 14 Sep 2009

Hi,I am trying to run the following SQL but I get a 2616: Numeric overflow occured during computation error.Can someone explain why this happens and maybe suggest a solution.Thanks,KarenSELECT (CAST(((100000 * 100000000) + Ms_handler_key_id) AS NUMERIC(18))) lw_ms_tr_key_id, a.Ms_handler_id FROM MSt_lu_handler_mgmt_key aWHERE a.ms_handler_active_from_date_id < :v_start_of_week_dateQUALIFY ROW_NUMBER() OVER (PARTITION BY a.Ms_handler_id ORDER BY a.ms_handler_active_from_date_id desc , a.ms_handler_eff_date_id desc, a.ms_handler_seq_id DESC) = 1)

13801 views
2 replies, 11 years ago
Could any one help me in learning teradata Topic by praween 07 Sep 2009

Hi friends, This is praveen. I heard about this software recently and I would like to learn this software. Could any one help me in learning this software. I would like to how to start. I am from computer science background. I don't have any tutorials.I would appreciate this help.

9292 views
1 reply, 11 years ago
Training on an ETL tool Topic by Jstatic 01 Sep 2009

Hi all, We are in the process of getting an ETL program. We need it to perform some basic extract, transform and load jobs. But we want to get an open source tool with good training. Our team is mainly business oriented, with some computer knowledge. We would like to have someone come to our company and explain to all the team how to operate the tool. I can operate the tool on my own, but I am not experienced enough to show other people how to operate the software. So would someone know which open source companies offer ETL tools with good training and how much time would it take? Thanks.

9046 views
1 reply, 11 years ago
Last updated date and time of any table in Teradata Topic by Hardik 01 Sep 2009

Can somebody help me in getting the Last updated date and time of any table in Teradata Database?

14240 views
2 replies, 11 years ago
String manipulation in a MACRO Topic by UpaMishra 28 Aug 2009

REPLACE MACRO mydb.emp_mac_test(in_emp_id varchar(300) )AS(sel * from db.emp where emp_id in (: in_emp_id););The requirement is that the macro will be executed as follows:exec mydb.emp_mac_test('A101,A102,A103,A104');How to modify the input string and convert it as 'A101','A102','A103','A104' in the macro.

9484 views
1 reply, 11 years ago
MLoad Issue Topic by Greyghost 26 Aug 2009

I have asked this before, but have never received an answer. So, I will try again.Our production load jobs are abending with this message:**** 23:13:34 UTY4015 Access module error '34' received during 'read' operation on record number '5789498': 'pmunxRBuf: fread error (Invalid argument)'What is causing this to occur? When I restart the job, it will sometime complete successfully, with no changes being made, or it abends with a different record being flagged. This is large file 6+ million recs, but this error seems to randomly appear. Is it space related? Server space issues? Is this a Teradata issue?What can I do to prevent this error from happening in the future?Thanks!Paul

8680 views
0 replies
Load Balancing & Security Topic by larry200 26 Aug 2009

Load balancing============I have two teradata boxes by names Box1 and Box2. How do I make sure the query requests are load balanced between these two boxes? Do I need another hardware component for that? OR Do I need to write my own code for load-balancing?Security=======I have a single teradata box Box1. How do I configure this box and the dbms, so that two of my clients would use the same hardware and database. But, it must be highly secure. Client-1 should not be able to view client-2's data and vice versa. Amp/node failure for client-1 should not affect client-2 and vice versa.Thanks,LarryThanks,Larry

8738 views
0 replies
BTEQ Topic by sweet_melody 17 Aug 2009

is BTEQ a free tool? Can i download it over the net for free?Thank You

13057 views
5 replies, 11 years ago
How to get the position of special char in a string? Topic by Venkatesh G 25 Aug 2009

How to get the position of special char in a string?I need to convert the string given below under type A into Type B.Type A Type B'Jiby Jose' 'Jiby''Jiby: Jose' 'Jiby''Jiby?: Jose' 'Jiby''Jiby(A) Jose' 'Jiby'for this I need to find the position of the special char and space in a string.Please help me in this regard.If possible please email me to venkatesh.gubba@gmail.com

9368 views
0 replies

Pages