|22350||16 Dec 2011 @ 02:42 PST||mbaig_88||UDA||Reply||Extract Data from Teradata using SSIS||
i am facing some problems in ssis.
1) [ODBC teradata driver] query timeout expired.
data i am fetching is around 250 rows and 5 columns. while p... |
|22349||16 Dec 2011 @ 02:37 PST||TeradataRecruitment||Jobs||Reply||Teradata Architect - 2 Month Contract, West London, UK||
Please send your CV to email@example.com
|22348||16 Dec 2011 @ 02:36 PST||TeradataRecruitment||Jobs||Topic||Teradata Architect - 2 Month Contract, West London, UK||
We are urgently seeking a Teradata Architect for a 2 month contract.
For this role you must have over three years experience in this area.
You will understand the corporate fi... |
|22347||16 Dec 2011 @ 01:21 PST||dnoeth||Database||Reply||killing a particular query in a session with out viewpoint/pmon||
Of course all queries within a session are logged with the same LogonTime, beause it's the session's logon time.
Just put a SELECT SESSION; before the long running queries in SQL Ass... |
|22346||16 Dec 2011 @ 12:49 PST||CarlosAL||Database||Reply||killing a particular query in a session with out viewpoint/pmon||
>>So the "SessionNoIn" parameter in abortsessionfunction represents the "queryid" in dbqlogtbl instead of the "sessionid" in the dbqlogtbl?
|22345||16 Dec 2011 @ 12:12 PST||youngchap||Database||Reply||killing a particular query in a session with out viewpoint/pmon||
Thanks carlosal and Dieter for your responses
I am assuming from your response that if a user logs into the system using SQL Assistant and run a first query the query will run wi... |
|22344||15 Dec 2011 @ 10:04 PST||Poongundrandk||General||Reply||Join Index with derived tables or subquery||
I have two scenario.I tried many things with my DA and thought Join Index can help.
1. I have one big table it may have 100 million records and have 3 medium siz... |
|22343||15 Dec 2011 @ 08:01 PST||NetLib||Database||Reply||Teradata Express for Windows - where are database files?||
Turns out that they are stored in files with names like:
Amp?-Pdisk0 (no extension), and
I don't know if there ... |
|22342||15 Dec 2011 @ 07:42 PST||madhugraju||Tools||Topic||Teradata JDBC Driver User Guide for 13.10/14.0||
Hello, I could not find the Teradata JDBC driver user guide for TTU 13.10 nor for TTU 14. I am specifically looking for the install steps and the variables (classpath) values that nee... |
|22341||15 Dec 2011 @ 04:30 PST||fgrimmer||Tools||Reply||teradata studio express - Connecting for the first time||
You can filter out schemas you don't need or include only those you want. If you right click on the connection profile and select Properties, there is an option to create a Schem... |
|22340||15 Dec 2011 @ 03:59 PST||AlekseyBaz||Cloud Computing||Reply||Performance issue with Teradata Express for VMware Player ||
I see the issue on two different host systems.
One is a workstation with Intel Core 2 Quad 2.66 GHz with 3 GB memory and the second is a designated remote server to host VM images. I d... |
|22339||15 Dec 2011 @ 02:56 PST||Jim Chapman||Cloud Computing||Reply||Performance issue with Teradata Express for VMware Player ||
That query takes 2 seconds on my 13.10 VM, but it is installed on a fast workstation. Perhaps your host machine is underpowered.
|22338||15 Dec 2011 @ 02:28 PST||AlekseyBaz||Cloud Computing||Topic||Performance issue with Teradata Express for VMware Player ||
Hi ALL, I am new to Teradata so sorry if my questions seem trivial and obvious for you.
I downloaded and successfully launched Teradata Express for VMware Player 13.10... |
|22337||15 Dec 2011 @ 02:26 PST||stubbsz||Tools||Topic||teradata studio express - Connecting for the first time||
Connecting to Terdata though this tool is taking a LONG time. I think it may be because it is downloading tons of Schema information... the progress tells me "Loading Core provider&qu... |
|22336||15 Dec 2011 @ 01:14 PST||feinholz||Tools||Reply||Teradata TPT Script||
Ok, looked a little further and that error message does not look like it comes from TPT.
Also, in the environment setup you showed me earlier, from what file was that text?
|22335||15 Dec 2011 @ 01:09 PST||NetFx||Connectivity||Reply||SQL Server linked server to Teradata specifying authentication mechanism (LDAP)||
See my Blog:
|22334||15 Dec 2011 @ 01:03 PST||MikeDempsey||General||Reply||Teradata SQL assistance for MICROSOFT Code Completion||
What version of SQL assistant are you using?
thisfeature was added in 13.11. If you have an older version it will not be available.
|22333||15 Dec 2011 @ 12:54 PST||TheClarityGroup||Jobs||Reply||Teradata FSLDM Architect Opportunity - 125,000 - Providence, RI||
For consideration, please send an updated resume to firstname.lastname@example.org
Visa Transfer assistance is not available for this position.
|22332||15 Dec 2011 @ 12:52 PST||TheClarityGroup||Jobs||Topic||Teradata FSLDM Architect Opportunity - 125,000 - Providence, RI||
As a Senior Teradata Physical Architect in this exciting role, you lead the development of all phases of deliverables through the firm’s implementation of Teradata FSLDM in orde... |
|22331||15 Dec 2011 @ 12:22 PST||Private Forum |
|22330||15 Dec 2011 @ 12:16 PST||feinholz||Tools||Reply||Teradata TPT Script||
Just want to make sure that when you ssh to the remote system, you indeed pick up the correct environment.
I have searched through the code and do not see that particular error message, but ... |
|22329||15 Dec 2011 @ 11:45 PST||feinholz||Tools||Reply||Problem using RowErrFileName||
Upgrade to the latest patch for 13.10, which should be 13.10.00.07.
That should fix this problem.
|22328||15 Dec 2011 @ 11:29 PST||VasuKillada||General||Reply||Join Index with derived tables or subquery||
It is not always true that the solution to improve the performance of your long running query is create a JI. If you think you have evaluated all options of tuning and only left... |
|22327||15 Dec 2011 @ 10:57 PST||Geemo||General||Topic||Teradata SQL assistance for MICROSOFT Code Completion||
Does anyone know how or where to turn on
Code Completion In Teradata SQL assistance for MICROSOFT. Because the text is suppose to be
To Display suggestion lists
|22326||15 Dec 2011 @ 10:28 PST||dnoeth||Database||Reply||Tenure in years and months between two dates||
2 is only "incorrect" for a human being, but "correct" for Standard SQL :-)
DATE '2007-01-31' AS dt1,
DATE '2005-07-01' AS dt2,... |