|40471||15 Apr 2014 @ 11:50 PDT||n_shashi||Database||Reply||Partition Primary Index||Thanks for the responses.
I'm not sure where to start with. I know the theory regarding PPI. However, when it comes for realtime implementation, I'm not sure where to star... |
|40470||15 Apr 2014 @ 11:36 PDT||Adeel Chaudhry||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.
|40469||15 Apr 2014 @ 11:33 PDT||Adeel Chaudhry||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... |
|40468||15 Apr 2014 @ 11:01 PDT||ramnathjk||Database||Topic||Optimizer confidence level and understanding explain plan||Hi Guys,
I have a doubt regarding the confidence levels of the optimizer in the explain plan.
Below is the scenario that i created:
1. Created 2 tables Location and Employee with... |
|40467||15 Apr 2014 @ 02:47 PDT||bmani||General||Topic||No Spool space error||Hi,
I have two tables (both tables have 4 integer columns) one table with 70k records and other with 1.1 million records. I need to join both of them without any... |
|40466||15 Apr 2014 @ 02:45 PDT||islanderman||Tools||Reply||fastload error message: Not enough fields in vartext data record number: 1||So the older teradata DBD interface, 'DBD::Teradata' was able to do Fastload and MLoad, but not 'DBD::ODBC' ?
I am not familiar enough with JAVA, so I would need to run this either... |
|40465||15 Apr 2014 @ 02:15 PDT||vhari||Connectivity||Reply||DBD::ODBC Connects from command line, not thru crontab||Check the odbc.ini ($ODBCINI) file and see what is directory is assigned to "InstallDir" entry under [ODBC] section. And verify, the DataDirect ODBC DM message files odbc.m & od... |
|40464||15 Apr 2014 @ 01:55 PDT||rraghuram64||Database||Topic||Implementing system generated keys||Hi..
Could some one tell me the positive impact of implementing system generated keys via use of identity columns?
|40463||15 Apr 2014 @ 01:04 PDT||wenjin||Tools||Topic||where to download the installation for Teradata Schema Workbench||Do you know where to download the installation for Teradata Schema Workbench?
|40462||15 Apr 2014 @ 12:53 PDT||Qaisar Aftab Kiani||Database||Reply||Partition Primary Index||Couple of things I would add, Adding the PPI doesn't guarantee the improvement in execution time until and unless they are being used properly in most of the queries. So basically you need to a... |
|40461||15 Apr 2014 @ 12:48 PDT||Qaisar Aftab Kiani||Database||Reply||Fallback technique in Teradata||You can make the tables fallback using ALTER table statement, and can take a lot of time depending on the records in the tables as the opertaion is a full-table scan. The system reads all the rows ... |
|40460||15 Apr 2014 @ 12:29 PDT||Qaisar Aftab Kiani||Database||Reply||Skew Factor||Read the above post by ulrich.
In short yes, if you want to reduce the skeweness you need to check which columns or combination of columns provide better distribution.
|40459||15 Apr 2014 @ 12:09 PDT||Tnewbee||Third Party Software||Topic||Bi tool cannot read from different databases in teradata?||Hi,
We have some BI queries which run on Teradata. Now these queries create a temp table in the base tables database and then read from another transaction table again in the base tables daabase. ... |
|40458||15 Apr 2014 @ 10:35 PDT||Sivakumar.thota||Viewpoint||Topic||Spool Alert on Viewpoint 14.10||Hi,
I am trying to create an alert to monitor spool usage at the session level. I want to send an alert only when any session uses 5 TB spool for 30 mins. I don't see any option to... |
|40457||15 Apr 2014 @ 10:26 PDT||islanderman||Tools||Topic||TTU Installation on Linux RedHat||Can anyone tell me how I can get hold of the TTU download for Linux RedHat? I've seen a few posts for requests but the only answers I've seen is pointing to documentation about the in... |
|40456||15 Apr 2014 @ 09:35 PDT||ToddAWalter||Database||Reply||Which is efficient?||Spool will remain the same, execution cost after the initial table reads will be the same. Overall performance of the query will not be the same because the underlying table has to be read in order... |
|40455||15 Apr 2014 @ 08:52 PDT||Adeel Chaudhry||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.?
|40454||15 Apr 2014 @ 08:52 PDT||Adeel Chaudhry||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.
|40453||15 Apr 2014 @ 08:47 PDT||ggo||Connectivity||Reply||TPT TeraData Parallel Transporter API (x64) and Visual Studio 2012||ok, it seems that the components are built with Visual C++ 2005 on windows, so I guess I have already already been lucky that it works with vs2008.
There is probably at least one major differ... |
|40452||15 Apr 2014 @ 08:44 PDT||taj786||Database||Reply||Skew Factor||hi
i am new to teradata, HOW REDUCE SKEW FACTOR IF IT IS >60 . IN TABLE I HAVE NUPI, SHALL I GO FOR COMBINATION OF COLUMN AS PI TO CHECK SKEW FACTOR . WHAT ARE OTHER APPROACH TO REDUCE SK... |
|40451||15 Apr 2014 @ 07:23 PDT||Harpreet Singh||Database||Reply||Which is efficient?||and spool will remain same also? in TD14.
|40450||15 Apr 2014 @ 07:19 PDT||Harpreet Singh||Database||Reply||Which is efficient?||Does it mean that Tables can have any number of columns and this will not impact performance as long as select is retrieving few columns?
select a1,a2,b3 from A join B on A.a1=B.b1
--A has 200 co... |
|40449||15 Apr 2014 @ 06:49 PDT||aneelkumar04||Tools||Topic||TPT10508: RDBMS error 2583 error in teradata tpt||Hi,
I am trying to insert data from prod to dev by using TPT Update operator. By mistake i have deleted all error tables including work table, log table.
Agin when i submit the script am got TPT1... |
|40448||15 Apr 2014 @ 06:27 PDT||dnoeth||Database||Reply||Convert integer to TIME||How is the time stored within the INT?
|40447||15 Apr 2014 @ 06:24 PDT||dnoeth||Analytics||Reply||REGEXP_SPLIT_TO_TABLE doesn't work ||Hi Raja,
i don't know about 14.10, but in 14 the initial one was too close to 00.00 and quite buggy version :)
There's 14.10.01.01 available which is approx. 5 month later than the 14.10.... |