All forum activity

#DateUserForumTypeThreadPost
154204 Aug 2006 @ 11:04 PDTabhijitvyasDatabaseReplyNUSI Bitmapping?Just to Add a Line to it as Fred Elaborated it absolutely correct.. Purpose of NUSI Bitmapping is to Create one Strongly selected NUSI By Clubbing Few weakly selected NUSI's so that It can be used ...
154104 Aug 2006 @ 10:54 PDTabhijitvyasDatabaseReplyConnecting between Different BoxesYeah we can not Join the Tables located in different Boxes. If the Table is not that Big you can also copy to Dev Box Through queryman that is indeed a good option for small Tables otherwise you ca...
154004 Aug 2006 @ 09:58 PDTFredDatabaseReplyConnecting between Different BoxesThere is no "built in" support for joining between two Teradata systems. In V2R6.1 you may be able to simulate this by writing an external table function to access the other system.
153904 Aug 2006 @ 09:53 PDTFredDatabaseReplyDate CalculationHow about justSELECT SomeDate - BirthDate YEAR(4) FROM ...Or if you want the result to be numeric rather than an "interval",CAST((SomeDate - BirthDate YEAR(4)) AS SMALLINT)
153804 Aug 2006 @ 06:34 PDTtrying_to_learnDatabaseTopicConnecting between Different BoxesI am trying to join two tables which are located in two different boxes. Ex: I am working on a table called Employee that is available in Development box and I need to join it to Department table w...
153704 Aug 2006 @ 06:19 PDTtrying_to_learnDatabaseTopicDate CalculationI am trying to calculate a date, given a birthdate how can you calculate age on any given day with the assumption that the person turns to 1 year older on the last day of February if they were born...
153604 Aug 2006 @ 02:27 PDTFredToolsReplyMLOAD RestartabilityBe careful. This works as long as MLOAD has not started the Apply phase. After that, "starting over" is problematic since MLOAD does not use Transient Journal logging (cannot be backed out). Don't ...
153504 Aug 2006 @ 11:49 PDTispalenyToolsTopicTeradata Parallel Transporter 8.1 - How to disable new EscapeTextDelimiter, else I must pre-process extractsHi,I am trying to use Teradata Parallel Transporter 8.1.I came into problems with new feature - "optional" EscapeTextDelimiter attribute of DataConnector operator. It is an optional attribute with ...
153404 Aug 2006 @ 09:29 PDTabhijitvyasToolsReplyteradata fast loadFastLoad performes operation on only 3 tables during Begin Loading Phase. first one is Empty Fastload Table and two error tables.after begin Loading Phase Locks are released from this 3 tables so E...
153304 Aug 2006 @ 09:02 PDTmahyanToolsReplyMLOAD RestartabilityHi Abhijit,1. Drop the ET, UV, WT, ML tables, release mload on the table & restart the load.2. Fload can not load duplicate records. I know that this does not answer your question, but That's how i...
153204 Aug 2006 @ 08:53 PDTabhijitvyasToolsTopicMLOAD RestartabilityHiI do have a scenario where in which I need to Restart MLOAD from the begining rather than from the Latest checkpoint. can any body tell how to do so?One more que is regarding Fastload as fastload...
153104 Aug 2006 @ 08:04 PDTvinod_sugurDatabaseReplyTop FunctionHi Aravind,I hope you are working on V2R6.
153004 Aug 2006 @ 06:56 PDTaravind-3019DatabaseReplyTop FunctionTeradata also supports TOP function.Try Select Top 5 * from Tablle1 order by col1
152904 Aug 2006 @ 06:51 PDTSuhas JoshiToolsTopicIs there an equivalent of glogin.sql in TeradataI am using an application that generates a sql query and executes this query on a database specified by the user; Whenever the sql is executed on Teradata (using bteq), the output columns are trunc...
152803 Aug 2006 @ 07:13 PDTmmuddamToolsReplyHow to fetch chunks of data in Teradata. Urgent!!!!Hi ,Is there any easy way to load data present in Excel on to Teradat database.Tx,Mohan
152703 Aug 2006 @ 04:26 PDTdnoethDatabaseReplySpool Space IssuesAs Nytewynd already proposed, try to filter on the 540M table in bn before the join to reduce the number of rows to be joined.Replacing the MAX-subquery with a RANK will probably help also. Of cour...
152603 Aug 2006 @ 03:01 PDTNytewyndDatabaseReplySpool Space IssuesI just ran into a similar problem the other day. It had to do with the fact that Teradata's plan was left outer joining to my dimension table on the step where I still had millions of rows, rather...
152503 Aug 2006 @ 01:31 PDTMChooJobsTopicTeradata DBA Needed in Phoenix, AZ!!!!!!!!!Safeway's IT Technology Support Center, located in Phoenix, Arizona has an opening for Teradata DBA.Key Responsibilities include: 1. Work with Operations Support and End Users to solve database rel...
152403 Aug 2006 @ 01:08 PDTshaik.feroz@aaa-calif.comDatabaseReplySpool Space Issuesdo an explain on this query withdiagnostic helpstats on for session;This will show if there are any statistics that should be collected.collect the statistics and then run your query.that will help.
152303 Aug 2006 @ 01:01 PDTMattW At ATTDatabaseReplyTop FunctionThis worked great. Thanks for the help. It's a bit of a spool hog, but that's another issue entirely...
152203 Aug 2006 @ 12:21 PDTdnoethToolsReplyMultiple Nullif checks for a field in FastloadYou can stop looking for the syntax, it just can't be done using FastLoad.The only way would be writing an INMOD doing the check.Dieter
152103 Aug 2006 @ 12:17 PDTdnoethAnalyticsReplyFailure 7453 Interval field overflowEven better, use day(4) to second, this will cover up to 27 years difference :-)Dieter
152003 Aug 2006 @ 08:05 PDTkuldeepsinghAnalyticsReplyFailure 7453 Interval field overflowI will try and report the errors/results.Thank you for your help.Kuldeep
151903 Aug 2006 @ 06:12 PDTmanjaToolsReplyteradata architectureA Teradata node requires three distinct pieces of software: 1)Trusted Parallel Application (TPA)2)Parallel Database Extensions (PDE)3)Operating SystemThe Parallel Database Extensions (PDE) software...
151803 Aug 2006 @ 05:32 PDTvinod_sugurAnalyticsReplyFailure 7453 Interval field overflowI am able to re-produce the error with the below example:Table vinod_12 has column ts of type timestamp with following records:ts=================2006-05-01 02:14:262006-05-03 02:14:262006-08-03 02...

Pages