All forum activity

#DateUserForumTypeThreadPost
141718 Jul 2006 @ 11:47 PDTFredToolsReplyMLOAD VARTEXT FORMATVARTEXT 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 ...
141618 Jul 2006 @ 11:44 PDTAquent | Marketing IT | ChicagoJobsTopicTeradata opportunities in Chicago and elsewhereWe have several Chicagoland opportunities in the financial services industry for technology professionals with Teradata experience:Senior Associate (22239 - Teradata)Statistical Modeler/Analyst (22...
141518 Jul 2006 @ 11:05 PDTsunitha-2928ToolsTopicteradata architectureWhat are trusted parallel application,Parallel database extension?
141418 Jul 2006 @ 10:47 PDTsunitha-2928ToolsTopicteradata architectureIs 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).
141318 Jul 2006 @ 10:43 PDTsunitha-2928ToolsTopicteradata architecture1.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...
141218 Jul 2006 @ 10:42 PDTsunitha-2928ToolsTopicteradata architecture1.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...
141118 Jul 2006 @ 10:42 PDTsunitha-2928ToolsTopicteradata architecture1.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...
141018 Jul 2006 @ 10:42 PDTsunitha-2928ToolsTopicteradata architecture1.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...
140918 Jul 2006 @ 10:34 PDTsunitha-2928ToolsTopicteradata fast loadDoes 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...
140818 Jul 2006 @ 10:23 PDTdeeps_v_37UDAReplyconfidence showned in explain planNo 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...
140718 Jul 2006 @ 09:53 PDTabidmanzoorToolsReplyProblem in fast load (Urgent)Its work............Thanks you very much Feroz Shaik sb.
140618 Jul 2006 @ 09:24 PDTdnoethDatabaseReplyPreCompilerIn 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
140518 Jul 2006 @ 08:58 PDTdeeps_v_37DatabaseTopicPreCompilerI 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...
140418 Jul 2006 @ 07:34 PDTANGELToolsReplyMLOAD VARTEXT FORMATHi,No i dont think so it will support. You can use integer format ThanksAngel
140318 Jul 2006 @ 03:19 PDTbalaji.sDatabaseReplyteradata and oracle architectureThe 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...
140218 Jul 2006 @ 12:11 PDTgiriToolsTopicMLOAD VARTEXT FORMATHAII am new to mload. will vartext file format support integer and date format.Thank u.
140117 Jul 2006 @ 03:09 PDTdnoethDatabaseReplyPlease Help on view updateHi 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
140017 Jul 2006 @ 02:45 PDTalvinyingConnectivityReplyTeradata ODBC Trouble in MS/AccessI 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 ...
139917 Jul 2006 @ 02:22 PDTyujingDatabaseReplyPlease Help on view updateThank you dieter. Would you please tell me Where did you get this messages manual. Is it online?
139817 Jul 2006 @ 02:09 PDTdnoethDatabaseReplyPlease Help on view updateHi yujing,Messages manualChapter 6: Teradata Database Messages3000-Series Messages3823 VIEW ’%VSTR’ may not be used for HelpIndex/Constraint/Statistics, Update, Delete orInsert.Explanation: The...
139717 Jul 2006 @ 01:53 PDTStacey EpsteinJobsTopicData Warehouse Manager positionWe 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...
139617 Jul 2006 @ 01:52 PDTyujingDatabaseTopicPlease Help on view updateI 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...
139517 Jul 2006 @ 01:38 PDTBarry-1604ConnectivityReplyEfficiency UDF scalar function vs.conventional SQLI 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...
139417 Jul 2006 @ 12:46 PDTsourcyanideDatabaseReplysomebody help me its very urgent!!!!!!!well i have started the teradata service by maunally starting it from service manager.... thanx
139317 Jul 2006 @ 12:46 PDTBarry-1604DatabaseReplydifference between Hash join and Merge joinWhen 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...

Pages