|15152||30 Mar 2010 @ 03:10 PDT||Random_Thought||Database||Reply||I'm a learner of teradata. And could you advise me How to study teradata?||If you have experience of other databases, go on the 1 day initial introduction to teradata course, it will give you an understanding of the differences.
If you have no experience of databases, go... |
|15151||30 Mar 2010 @ 02:25 PDT||nycle||Database||Topic||I'm a learner of teradata. And could you advise me How to study teradata?||hello,every one, I'm nycle. I like database very much. But I am a learner of teradata. And I find that there are a few resources on the internet. And could you advise me How to study teradata? Co... |
|15150||30 Mar 2010 @ 02:11 PDT||swati savalagi||General||Reply||Welcome to the Teradata Developer Exchange discussion forums!||Hi all,
2 sec ago
i want to merge the results of many rows including duplicate values to one row.for example like consider column empid
|15149||30 Mar 2010 @ 02:11 PDT||Random_Thought||Database||Reply||How to gain performance in manipulating and querying huge tables ?||Gott,
I hate to see a posting go unanswered, (Especially mine!) but I think to answer fully people may need a little more information.
What is your teradata node configuration? How big is the... |
|15148||30 Mar 2010 @ 01:43 PDT||nycle||Database||Reply||Multi-Partitioning - how to hit the partition?||I think the condition nerver use the column "day", so it doesn't hit the partition. If you want to hit the partition, so you should filter the conditon of column "day". |
|15147||29 Mar 2010 @ 10:23 PDT||sundeep.bose||Connectivity||Reply||How to mention default database when using Teradata OLEDB provider for connection(DSN LESS). ||thanks. |
|15146||29 Mar 2010 @ 09:05 PDT||dilip_023||Tools||Reply||error occured in TPUMP utility||revert to me if any issues |
|15145||29 Mar 2010 @ 09:04 PDT||dilip_023||Tools||Reply||error occured in TPUMP utility||hey just look into the macro if u have any conflicting defintion i.e. in tpump u have the insert and inside the maro u have delete statement. |
|15144||29 Mar 2010 @ 02:05 PDT||Greyghost||Tools||Reply||Windows 7 & SQL Assistant/Teradata Administrator||Where could I download vesion 13 of the Teradata Utilities? I would like to try this with Windows 7, it may work since no one has heard of issues with this release.
|15143||29 Mar 2010 @ 08:50 PDT||waqasshami||Tools||Reply||SUN Solaris SPARC & Teradata 12 Utilities||On Average these 5 utilities requires about 500 MB of space. this space is just for installation of these utilities. |
|15142||29 Mar 2010 @ 04:08 PDT||klnleela||Marketing & CRM||Topic||Buffer clearing options are not working||Hi,
We are using the Automatic buffer claering, but it is not working fine. weekly we need to do manually. Please can any one explain why it is not happening.
|15141||29 Mar 2010 @ 03:35 PDT||vishwa||Training||Reply||regarding learning teradata basics||
This is vishwa I am new to Teradata, I worked on EDI tools like AxS & zentran I want to learn teradata on my own i am just aware of the database concepts . Can anyone suggest me how ... |
|15140||29 Mar 2010 @ 01:49 PDT||dnoeth||Tools||Reply||insert into problem in BTEQ||INSERT INTO tableName (col1, col2, col3)
SELECT :next_var + row_number () over (order by ???)
col2, col3 FROM tableName;
|15139||29 Mar 2010 @ 01:36 PDT||dnoeth||UDA||Reply||joining table A to table B only once where condition satisfied||Hi Chris,
only SPs with Dynamic SQL (not in this case) or DDL statements must be created within the creator (this limitation is lifted in TD13).
So for a first try you might to drop/create the Vo... |
|15138||28 Mar 2010 @ 11:34 PDT||WAQ||Tools||Topic||insert into problem in BTEQ||i want to insert some values in my table using INSERT INTO SELECT SQL as:
INSERT INTO tableName (col1, col2, col3)
SELECT col2, col3 FROM tableName;
for col1 i need to pass the value comming... |
|15137||28 Mar 2010 @ 09:20 PDT||barcoo||UDA||Reply||joining table A to table B only once where condition satisfied||Oh cool, you are still looking at this Dieter. Thanks
What you have typed above is what I've been trying to write up, but stored procedures are outside my understanding. Currently reading the ma... |
|15136||28 Mar 2010 @ 09:01 PDT||Fred||Database||Reply||Multi-Partitioning - how to hit the partition?||You can't get "static" partition elimination, but you may be able to get a join plan that is "enhanced by dynamic partition elimination". What stats have you collected on t_day? How about multicolu... |
|15135||28 Mar 2010 @ 08:52 PDT||Fred||Database||Reply||difference of values with datatype Time||But duration would be an INTERVAL datatype. It's logically incorrect to assign an INTERVAL value to a TIME field. If you absolutely insist on storing the result as TIME(0) instead of the proper typ... |
|15134||28 Mar 2010 @ 06:50 PDT||QuantRec||Jobs||Topic||Teradata Application DBA Large Financial Company / NYC Senior, Team Member level Application DBA. 125K base +bonus. Email resume||http://bit.ly/c6AQFQ
Candidate invites of all types welcome. Send to email listed, and there may be positions for you in the near future, broaden and expand your contacts!
If qualified, email... |
|15133||28 Mar 2010 @ 06:48 PDT||codesai||Connectivity||Reply||Error 7583 when calling external stored procedure||did anyone find a solution to this?..
i login to a different machine and get this error when i try to run a java udf. i login to vmware on that machine and try to run the udf. i get this same e... |
|15132||27 Mar 2010 @ 11:47 PDT||venky3057||Database||Reply||NUSI Vs. FTS||Hi,
I have similar request where my base table have around 2400 Million records :(. I have to join it to another table(with around 100 millions of data) based on a NON-INDEXED column.
Is it prefe... |
|15131||27 Mar 2010 @ 04:56 PDT||dnoeth||Tools||Reply||usage of check point in fastload||If Teradata restarts during a FastLoad it just waits for the DBMS to recover and then finishes the load, without resending data.
If the FastLoad job has to be restartet (e.g. FastLoad crashes or... |
|15130||27 Mar 2010 @ 04:13 PDT||tmrmodest1||Tools||Topic||usage of check point in fastload||Hi,
Checkpoints is used to resume the paused job, at a point where it was paused, because of the error caused by the client or by the RDBMS. Am i right with the definition.
Assume checkpoints ar... |
|15129||26 Mar 2010 @ 05:35 PDT||Anyuta||Database||Topic||Cannot start db :(||Hi everyone,
I couldn't get my db started after I rebooted my host. I get this error:
PDE not accessible: Cannot open PDE device
What does it mean and how to fix it?
I had to reboot the... |
|15128||26 Mar 2010 @ 10:27 PDT||Jim Chapman||Database||Reply||TD 13||The most significant new features of each release are itemized the Release Summary in the documentation set for that release, which you can find at this site (http://www.info.teradata.com/). |