39802 Feb 2013 @ 11:47 PSTDatabaseReplyCreating a view from multiple tables in SQL 2012What is the error you get?   And do you have a valid/working SELECT statement for which you want to create a view?   Regards, Adeel
39702 Feb 2013 @ 11:24 PSTDatabaseReplyDifference Between Restore Job and Copy JobIn my opinion its just a matter of understanding .... which that situation at hand may be the best thing was to copy and not restore. Technically they are 3 different things to achieve same purpose...
39630 Jan 2013 @ 12:47 PSTDatabaseReplyCan we access a table from SQL UDF in TD 14?Are you converting fuctions from other RDBM (e.g SQL Server) to Teradata? What will be the use of this fuction?   Regards, Adeel
39530 Jan 2013 @ 12:24 PSTDatabaseReplyCreating a recursive script to handle Oracle scriptHi,   Instead of keeping it recursive, you should better change the logic to sequencial and then implement it .... it will have much better performance that way.   Regards, Adeel
39403 Nov 2012 @ 06:38 PDTTeradata ApplicationsReplyQuery on Big Table sized approx 1 TBFirst of all, it needs to be analyzed before concluding what needs to be done.   Initial thoughts drag me to ask .... if stats are collected?   The main idea is to minimize two things...
39303 Nov 2012 @ 06:33 PDTCloud ComputingReplyPerformance issue with Teradata Express for VMware Player Check if your system is capable enough .... and also VMWare is allowed to use sufficient amount of memory.
39203 Nov 2012 @ 06:30 PDTConnectivityReplyHow to Call Teradata Stored ProcedureAdd new questions as new post. You will have better chance to get your answer.
39126 Sep 2012 @ 09:40 PDTTeradata ApplicationsReplyQuery to convert Decimal(15) to date format 'yyyy-mm-dd'Is it the epoch date you have in DECIMAL(15,0)? .... any samples would help.
39026 Sep 2012 @ 09:39 PDTGeneralReplyPosting topics into the correct forumGuess you didnt read what Neil wrote above.
38917 Sep 2012 @ 03:59 PDTDatabaseReplyIdentifying The DDL From The System TablesI wrote something in 2008 .... which am attaching here .... hope that helps.   As far as i know, you cannot come up with 100% identical output as that of SHOW TABLE command, but it might jus...
38803 Jul 2012 @ 05:13 PDTGeneralReplyFailure 2646 No more spool space in First of all, please put seperate questions in seperate threads.   Next, have you analyzed the query generated by Informatica? Is it a Full-PDO? Have you collected stats for underly...
38703 Jul 2012 @ 05:09 PDTDatabaseReplyneed help Please use the "Code" icon to put SQL next time .... its there for a reason. :)
38603 Jul 2012 @ 05:08 PDTDatabaseReplyneed help Whats the current execution time for this query?   Whats the data volume we are talking about?   Why are you writing joins in where clauses? Your data is being redistri...
38503 Jul 2012 @ 04:52 PDTGeneralReplyTeradata Functions Please post your question in a seperate thread and be more descriptive.
38402 Jul 2012 @ 01:41 PDTAnalyticsReplyNeed to cast an invalid date to a valid Try by adding ":00" at the end of your concatenated field for seconds .... e.g. "2009-07-01 07:54:00" and it should be fine.   HTH!
38302 Jul 2012 @ 01:33 PDTToolsReplyNeed of Collect Statistics 1. Stale stats are out-dated stats .... e.g stats are not collected for a long period of time while data has been changing in the table .... so we have stale stats that needs to be refreshed or ...
38202 Jul 2012 @ 01:28 PDTToolsReplyRequest size exceeds maximum. Usually, this error comes up when the size of SQL issued to Teradata is greater than the allowed length (1 MB).   Can you check if the generated SQL is large enough to cause this er...
38102 Jul 2012 @ 01:15 PDTDatabaseReplyTable Load Timestamp Are there multiple tables you are working with or is it just one table?
38002 Jul 2012 @ 01:11 PDTDatabaseReplyinsert failed [2803] secondary index uniqueness violation Which session mode are you using? ANSI or Teradata?
37902 Jul 2012 @ 01:09 PDTDatabaseReplyidentify the table immediately where any DML operation happened You can achieve that using DBQL tables, if enabled. But it will be a resource consuming process.   Can you put some more light on why do you need to do this?
37802 Jul 2012 @ 01:05 PDTGeneralReplyHow do we calculate te cost of query in Teradata? The unit primarily depends on the purpose for what you need this calculation.   For example, for one project we were asked to calculate on the basis of type of joins. For another, i...
37702 Jul 2012 @ 01:01 PDTPrivate Forum
37602 Jul 2012 @ 12:53 PDTDatabaseReplyHow to add space to database Another option can be as follows:   - Assign CREATE DATABASE rights to database C1 - Move space from DBC to C1   HTH!
37502 Jul 2012 @ 12:48 PDTDatabaseReplyCharacter to Date Conversion Which tool you are using to display output format? ODBC may enforce its own date format on the data visible. On BTEQ though, the query above will work just fine.   HTH!
37402 Jul 2012 @ 12:43 PDTDatabaseReplyJoining on derived column which is derived in the same view Derived tables and string operations usually end up in product join, what you can do is perhaps store a value of a derived column in a table and then use it as it is.   HTH!