1417 | 18 Jul 2006 @ 11:47 PDT | Fred | Tools | Reply | MLOAD VARTEXT FORMAT | VARTEXT says the input file is delimited text. The input fields can then be converted/CAST to Teradata datatypes using standard SQL expressions or in some cases will be implicitly CAST by Teradata ... |
1416 | 18 Jul 2006 @ 11:44 PDT | Aquent | Marketing IT | Chicago | Jobs | Topic | Teradata opportunities in Chicago and elsewhere | We have several Chicagoland opportunities in the financial services industry for technology professionals with Teradata experience:Senior Associate (22239 - Teradata)Statistical Modeler/Analyst (22... |
1415 | 18 Jul 2006 @ 11:05 PDT | sunitha-2928 | Tools | Topic | teradata architecture | What are trusted parallel application,Parallel database extension? |
1414 | 18 Jul 2006 @ 10:47 PDT | sunitha-2928 | Tools | Topic | teradata architecture | Is there any way to view the background process in teradata like in the case of oracle.Is it possible to see the background process by logging into unix(in the unix environment). |
1413 | 18 Jul 2006 @ 10:43 PDT | sunitha-2928 | Tools | Topic | teradata architecture | 1.How to get row_id information in case of teradata.Like in the case of oracle you can give sel row_id from table_name and get the row_id information.2.Where can i get information on table_header w... |
1412 | 18 Jul 2006 @ 10:42 PDT | sunitha-2928 | Tools | Topic | teradata architecture | 1.How to get row_id information in case of teradata.Like in the case of oracle you can give sel row_id from table_name and get the row_id information.2.Where can i get information on table_header w... |
1411 | 18 Jul 2006 @ 10:42 PDT | sunitha-2928 | Tools | Topic | teradata architecture | 1.How to get row_id information in case of teradata.Like in the case of oracle you can give sel row_id from table_name and get the row_id information.2.Where can i get information on table_header w... |
1410 | 18 Jul 2006 @ 10:42 PDT | sunitha-2928 | Tools | Topic | teradata architecture | 1.How to get row_id information in case of teradata.Like in the case of oracle you can give sel row_id from table_name and get the row_id information.2.Where can i get information on table_header w... |
1409 | 18 Jul 2006 @ 10:34 PDT | sunitha-2928 | Tools | Topic | teradata fast load | Does fast load maintain a temporary work table that is loaded in the phase1 and then in the phase 2 data is put into target table(vdisk).Then the temporary work table dropped.Is there anyway to acc... |
1408 | 18 Jul 2006 @ 10:23 PDT | deeps_v_37 | UDA | Reply | confidence showned in explain plan | No Confidence indicates that cardinality is a pure guess.FK Confidence indicates that the cardinality estimate is based on the optimizer's belief that a foreign key join is being performed. It's a... |
1407 | 18 Jul 2006 @ 09:53 PDT | abidmanzoor | Tools | Reply | Problem in fast load (Urgent) | Its work............Thanks you very much Feroz Shaik sb. |
1406 | 18 Jul 2006 @ 09:24 PDT | dnoeth | Database | Reply | PreCompiler | In Teradata it's called Preprocessor, search the manual for it. But IMHO it's hardly used anymore, in most environments it's replaced by ODBC/JDBC access...Dieter |
1405 | 18 Jul 2006 @ 08:58 PDT | deeps_v_37 | Database | Topic | PreCompiler | I have been reading about Oracle proc (precompiler) that enables the appl developer to embed SQL statements into high level source programs(in C,C++).Was wondering if there is any such similar thin... |
1404 | 18 Jul 2006 @ 07:34 PDT | ANGEL | Tools | Reply | MLOAD VARTEXT FORMAT | Hi,No i dont think so it will support. You can use integer format ThanksAngel |
1403 | 18 Jul 2006 @ 03:19 PDT | balaji.s | Database | Reply | teradata and oracle architecture | The basic difference is that in teradata we have the concept of AMPs which takes care of the part of database virtually assigned to it. It takes care of all the operation relating to the data which... |
1402 | 18 Jul 2006 @ 12:11 PDT | giri | Tools | Topic | MLOAD VARTEXT FORMAT | HAII am new to mload. will vartext file format support integer and date format.Thank u. |
1401 | 17 Jul 2006 @ 03:09 PDT | dnoeth | Database | Reply | Please Help on view update | Hi yujing,all manuals are available at www.info.ncr.comInstead of seperate manuals, it's better to download the documentation CD, then you can search within all manuals.Dieter |
1400 | 17 Jul 2006 @ 02:45 PDT | alvinying | Connectivity | Reply | Teradata ODBC Trouble in MS/Access | I had the same problem. And in add/remove it shows that I already had ODBC 3.04.00. I downloaded the latest ODBC driver, un-installed the old one and install ODBC driver 3.04.00.01. The problem is ... |
1399 | 17 Jul 2006 @ 02:22 PDT | yujing | Database | Reply | Please Help on view update | Thank you dieter. Would you please tell me Where did you get this messages manual. Is it online? |
1398 | 17 Jul 2006 @ 02:09 PDT | dnoeth | Database | Reply | Please Help on view update | Hi yujing,Messages manualChapter 6: Teradata Database Messages3000-Series Messages3823 VIEW ’%VSTR’ may not be used for HelpIndex/Constraint/Statistics, Update, Delete orInsert.Explanation: The... |
1397 | 17 Jul 2006 @ 01:53 PDT | Stacey Epstein | Jobs | Topic | Data Warehouse Manager position | We are looking for a Data Warehouse Manager with experience in Teradata. This is a hands-on, management position. Will be responsible for 2 other developers, and will grow with position as the wa... |
1396 | 17 Jul 2006 @ 01:52 PDT | yujing | Database | Topic | Please Help on view update | I tried to insert a record in to a view and I got this messsage:3823: view xxx may not be used for Help Index/constraint/statistics, update,delete or insert.Would you please give me some hint about... |
1395 | 17 Jul 2006 @ 01:38 PDT | Barry-1604 | Connectivity | Reply | Efficiency UDF scalar function vs.conventional SQL | I don't use the is_number function, but I use a variation of the to_number function on v2r6.0. I just ran a benchmark against 8 million rows and am seeing that the UDF in unprotected mode runs fas... |
1394 | 17 Jul 2006 @ 12:46 PDT | sourcyanide | Database | Reply | somebody help me its very urgent!!!!!!! | well i have started the teradata service by maunally starting it from service manager.... thanx |
1393 | 17 Jul 2006 @ 12:46 PDT | Barry-1604 | Database | Reply | difference between Hash join and Merge join | When the small table is very small (I don't know where the exact cutoff is, but I would guess that it's one data block), the optimizer will choose a product join. As the size of the small table ge... |