698 | 18 Apr 2014 @ 11:10 PDT | Database | Reply | Skew Factor | The 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... |
697 | 18 Apr 2014 @ 06:25 PDT | Database | Reply | How to find if system has AMFS enabled? | Do you mean 'Multiple Virtual Storage'? Details below:
https://www.teradata.com/brochures/Teradata-Virtual-Storage-eb5944/
|
696 | 18 Apr 2014 @ 05:57 PDT | Database | Reply | Identify Set - Multiset Tables in TD 14 | Can you export the DDLs and then do a search on it?
|
695 | 18 Apr 2014 @ 05:53 PDT | General | Reply | Convertion from SQL Server to Teradata | Also, you can load it as varchar.
|
694 | 18 Apr 2014 @ 05:52 PDT | General | Reply | Convertion from SQL Server to Teradata | Guys, 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
|
693 | 17 Apr 2014 @ 01:42 PDT | General | Reply | No Spool space error | Which kind of table is it? Is it for staging? Or DWH table? Row-count?
|
692 | 17 Apr 2014 @ 01:22 PDT | Database | Reply | Partition Primary Index | There 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... |
691 | 16 Apr 2014 @ 11:20 PDT | Viewpoint | Reply | TDExpres is down | Have 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... |
690 | 16 Apr 2014 @ 11:18 PDT | General | Reply | When we need to collect stats on table | In 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... |
689 | 16 Apr 2014 @ 11:15 PDT | General | Reply | When we need to collect stats on table | We 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... |
688 | 16 Apr 2014 @ 11:10 PDT | Database | Reply | How 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... |
687 | 16 Apr 2014 @ 11:07 PDT | Database | Reply | Current Month End Date | True, 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... |
686 | 16 Apr 2014 @ 10:58 PDT | Database | Reply | Find Calling Script in DBQL | No, you can find the TD tool/connectivity source that fired the query .... but not the script name.
|
685 | 16 Apr 2014 @ 10:55 PDT | Third Party Software | Reply | Bi 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... |
684 | 15 Apr 2014 @ 11:36 PDT | General | Reply | No Spool space error | What 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... |
683 | 15 Apr 2014 @ 11:33 PDT | Database | Reply | Implementing system generated keys | Well, 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... |
682 | 15 Apr 2014 @ 08:52 PDT | Connectivity | Reply | Application not started because all AMPs are in NewProc or Fatal State | Can you shed some light on your setup of Teradata? Systems, versions, etc.?
|
681 | 15 Apr 2014 @ 08:52 PDT | Tools | Reply | BTEQ - Parametrize output File | You 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.
|
680 | 15 Apr 2014 @ 01:34 PDT | Database | Reply | Partition Primary Index | PPI 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... |
679 | 15 Apr 2014 @ 01:31 PDT | Cloud Computing | Reply | Teradata on Amazon RDS | From their website, it doesnt seem possible. And they dont have a generic ODCB connecter either which may have worked.
|
678 | 15 Apr 2014 @ 01:26 PDT | Database | Reply | Daily 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... |
677 | 14 Apr 2014 @ 07:51 PDT | Tools | Reply | Show View Definition - Teradata SQL Assistant 14.01.0.04 | Can you please elaborate what you mean by activation?
|
676 | 14 Apr 2014 @ 07:50 PDT | Tools | Reply | SQL Assistant Copy Errors 14.10 | Strange .... i am using the same version .... it works fine. Can you check if it gives you the same error via ODBC connection?
|
675 | 13 Apr 2014 @ 12:06 PDT | Database | Reply | Difference between X and V views | Not 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 ... |
674 | 12 Apr 2014 @ 11:14 PDT | General | Reply | Unable to import data from notepad or csv file | If 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.
|