All Forums

Have questions related to the interaction of non-Teradata software with Teradata? This is the place to ask questions about any of our partners' software.

You must login to post to the forums.
Teradata and Ascential Data Stage Topic by Raj Radhakrishnan 15 Feb 2005

Hi,Following is the background of the problem and my questions:Problem Background:I have a SELECT query that takes 16sec to return the answer set using Queryman or BTEQ. The optimizer chooses a plan that has 5 or 6 steps.When I run the same SELECT query through Ascential Data Stage tool, the optimizer chooses a plan that has 9 steps, which is different from the one when EXPLAINed using Queryman. The query takes forever to return the answer set.I collected stats on the join columns and the query run using Queryman took 10min to return the answer set.Questions:1. Did anybody experiened similar problem when using Teradata with ETL tools like Ascential Data Stage, Informatica?2. Is there a way to make the query to perform at its best(16sec elapse time to return answer set) in Data Stage tool?Thanks,Raj

32233 views
2 replies, 13 years ago
BTEQ VS informtica load Topic by msthompson37 17 Sep 2006

Does Loading data using BTEQ faster than loading through Informatica workflows?Anyone?

23178 views
1 reply, 13 years ago
how to extract only mondays in 2007 Topic by chinnababu 01 Mar 2007

Needs extract only mondays in 2007.how can i achevie using Teradata SQLThanksChinna

26952 views
2 replies, 13 years ago
Issue using Informatica to load Teradata tables. Topic by shaik.feroz@aaa-calif.com 21 Jun 2006

I have an issue while loading data from sql server to Teradata database. It takes a very long time to load 100K rows. when i checked the log I guess it is doing a row level insert instead of a bulk load. Here is a part of the session logMASTER> PETL_24006 Starting data movement.MAPPING> TM_6660 Total Buffer Pool size is 12000000 bytes and Block size is 64000 bytes.READER_1_1_1> DBG_21438 Reader: Source is [SA3ADLSQL02], user [ABCDEF]READER_1_1_1> BLKR_16003 Initialization completed successfully.WRITER_1_*_1> WRT_8148 Writer: Target is database [JQU], user [ABCDEF], bulk mode [N/A]WRITER_1_*_1> CMN_1021 Database driver event...CMN_1021 [Teradata Event Using array fetches. Teradata Event Using Single Row Inserts. connect string = [Siebel_Warehouse_Dev]. userid = [ABCDEF]]WRITER_1_*_1> WRT_8124 Target Table JQU_ProspectOwnerTracker :SQL INSERT statement:Now how can i set the option to do a BULK LOAD.? I remember there is a place to do that but I cant find it. I'd appreciate your help.Thanks.

43538 views
4 replies, 13 years ago
solaris exam preps for 315-055 ? Topic by juasht 12 Nov 2006

anyone have dumps of certmagic.com for 315-055 ? . i need it very urgently ... i can exchange it for hotcerts.com dump for 315-055 ... plz let me know asap

16429 views
0 replies
strange thing-interactional of two different database connection Topic by sxjcarl 17 Aug 2006

I found a strange phenomenon happened in NCR-CLI.I want to use two different database connection in one process.according to the CLISAMP.c, I think that DBCAREA will keep all connection info.so I defined two DBACAREA, one is dbc_a, dbc_b. corspondingly, I copy the codes(initial, connect, disconnect, etc)to make sure that two connection is irrelative.the test code is very simple. following is pseudocode: DBCAREA dbc_a DBCAREA dbc_b dbc_a.connect dbc_b.connect dbc_a.disconnect dbc_b.disconnect --------there is a error when running here. "disconnect failed -- CLI : 304 Message Not Found!" If so, I can not use multi database connection to imporve the performance. Hope some one can tell the reason and how to deal with it.Thanks a lot.

16620 views
0 replies
What are the TD components do we need to on Linux with Datastage server Topic by ven_vick 14 Aug 2006

Hi, I am trying to connect to Teradata which is on a windows machine while the Datastage is on the Linux sever. What do I need to install on the linux side apart from the ODBC in order to use the DataStage Teradata StagesThanks.

16679 views
0 replies
What are the TD components do we need to on Linux with Datastage server Topic by ven_vick 14 Aug 2006

Hi, I am trying to connect to Teradata which is on a windows machine while the Datastage is on the Linux sever. What do I need to install on the linux side apart from the ODBC in order to use the DataStage Teradata StagesThanks.

16758 views
0 replies
Calling sp through ODBC Topic by sharma.anurag 07 Mar 2006

Hi All,I am facing a problem while call an stored procedure from odbc driver.I m working with asp.net and my database is teradata. The page gets hanged while i call stored procedure.If anyone have some code to call SP with in and out parameter please send it. May be it will held me

22831 views
1 reply, 14 years ago
SSH for MP-RAS Topic by frarap 22 Feb 2006

Where can I download the SSH package for NCR MP-RAS? Or if opensource, which SSH? I am running MP-RAS 3.02 on a Dell S2600.Thanks in advance.Frank

29531 views
2 replies, 14 years ago
WII Topic by iliakn 06 Dec 2005

Does somebody know about using WII with Teradata in the efficient way?

22808 views
1 reply, 14 years ago

Pages