#DateForumTypeThreadPost
69818 Apr 2014 @ 11:10 PDTDatabaseReplySkew FactorThe order of columns in defining PI doesnt matter.   No harm in adding Timestamp column, given it makes sense as per the table type and data it contains. What is the type of table? Is it sta...
69718 Apr 2014 @ 06:25 PDTDatabaseReplyHow to find if system has AMFS enabled?Do you mean 'Multiple Virtual Storage'? Details below:     https://www.teradata.com/brochures/Teradata-Virtual-Storage-eb5944/  
69618 Apr 2014 @ 05:57 PDTDatabaseReplyIdentify Set - Multiset Tables in TD 14Can you export the DDLs and then do a search on it?
69518 Apr 2014 @ 05:53 PDTGeneralReplyConvertion from SQL Server to TeradataAlso, you can load it as varchar.
69418 Apr 2014 @ 05:52 PDTGeneralReplyConvertion from SQL Server to TeradataGuys, in SQL Server .... timestamp .... is no where close to DATE and/or TIME.   See below for further details:   http://technet.microsoft.com/en-us/library/ms182776.aspx
69317 Apr 2014 @ 01:42 PDTGeneralReplyNo Spool space errorWhich kind of table is it? Is it for staging? Or DWH table? Row-count?
69217 Apr 2014 @ 01:22 PDTDatabaseReplyPartition Primary IndexThere is only one point to consider .... and that is .... you need to do some anaysis at your end on 'how' the tables are going to be used. And if there is some analysis on which partitioni...
69116 Apr 2014 @ 11:20 PDTViewpointReplyTDExpres is downHave you configured the Viewpoint?   Visit the following link, it contains the full information:   http://developer.teradata.com/database/articles/teradata-express-14-0-for-vmware-use...
69016 Apr 2014 @ 11:18 PDTGeneralReplyWhen we need to collect stats on tableIn case columns usage is not known, just collect the stats on index columns.   If possible, try to find out the logical PKs of the tables which might be used for joining and getting the requ...
68916 Apr 2014 @ 11:15 PDTGeneralReplyWhen we need to collect stats on tableWe had a similar scenario in one of the implementations  .... and we had two options: - to create a BTEQ script for collecting stats and call it as a last task in Informatica - to revert...
68816 Apr 2014 @ 11:10 PDTDatabaseReplyHow to reduce skew factor on stage tables with NoPI?Collect stats should be used once the data in underlying tables have changed significantly. It is usually done at the end of running daily/weekly batch. It gives a better view for the system to def...
68716 Apr 2014 @ 11:07 PDTDatabaseReplyCurrent Month End DateTrue, the correct query is:   SELECT ADD_MONTHS(cast('2014-03-24' as date)-EXTRACT(DAY FROM cast('2014-03-24' as date))+1,1)-1   Other one also messes up the leap year...
68616 Apr 2014 @ 10:58 PDTDatabaseReplyFind Calling Script in DBQLNo, you can find the TD tool/connectivity source that fired the query .... but not the script name.
68516 Apr 2014 @ 10:55 PDTThird Party SoftwareReplyBi tool cannot read from different databases in teradata?Its more related to BI tool, but as a usual practice you can expose tables to BI with a view layer .... which resides in a single DB hence they can access it.   And you can define those view...
68415 Apr 2014 @ 11:36 PDTGeneralReplyNo Spool space errorWhat are the demographics of these tables .... e.g unique values per column? No more spool-space error occurs when it is running out of space on 1 AMP, so the way you write the SQL also matter. &n...
68315 Apr 2014 @ 11:33 PDTDatabaseReplyImplementing system generated keysWell, for one .... youo dont need to generate it yourself. But it is better to generate it within your process .... SQL or though ETL tool. It gives you more control on data and can change/fix valu...
68215 Apr 2014 @ 08:52 PDTConnectivityReplyApplication not started because all AMPs are in NewProc or Fatal StateCan you shed some light on your setup of Teradata? Systems, versions, etc.?
68115 Apr 2014 @ 08:52 PDTToolsReplyBTEQ - Parametrize output FileYou can't do that using TTUs. Yet you can achieve the same results using a little coding in any language .... to give an interface to get variables and replace & execute the scripts.
68015 Apr 2014 @ 01:34 PDTDatabaseReplyPartition Primary IndexPPI on 80 tables? Feels like an over-kill. What is the total tables count?   How much data is your system been tested on? Are there any specific reports/area which requires performance impro...
67915 Apr 2014 @ 01:31 PDTCloud ComputingReplyTeradata on Amazon RDSFrom their website, it doesnt seem possible. And they dont have a generic ODCB connecter either which may have worked.
67815 Apr 2014 @ 01:26 PDTDatabaseReplyDaily Increase in Space for Database ?You can schedule the following SQL as an INSERT to a table:   SELECT  databasename ,CAST(SUM(maxperm)/1024/1024/1024 AS DECIMAL(7,2)) max_perm ,CAST(SUM(currentperm)/1024...
67714 Apr 2014 @ 07:51 PDTToolsReplyShow View Definition - Teradata SQL Assistant 14.01.0.04Can you please elaborate what you mean by activation?
67614 Apr 2014 @ 07:50 PDTToolsReplySQL Assistant Copy Errors 14.10Strange .... i am using the same version .... it works fine. Can you check if it gives you the same error via ODBC connection?
67513 Apr 2014 @ 12:06 PDTDatabaseReplyDifference between X and V viewsNot all views need to have X or V views. Having X or V view for dbc.ErrorMsgs doesnt make sense as it is there for all error-codes.   To find a difference between these views, please have a ...
67412 Apr 2014 @ 11:14 PDTGeneralReplyUnable to import data from notepad or csv fileIf the data format is not as per the DDL format, you can load the dates in table as VARCHAR and then CAST them to date.

Pages