|52775||08 Oct 2015 @ 02:41 PDT||Fred||Database||Reply||How to create a table in CTE in Teradata||You can't execute a CTE by itself, it can only be prefixed to a SELECT statement.
|52774||08 Oct 2015 @ 12:19 PDT||oshun||Database||Reply||IN Clause ||There is no difference.
|52773||08 Oct 2015 @ 11:49 PDT||Alexander K||Analytics||Reply||Teradata In-database R and Python Analytics with the SCRIPT Table Operator||It's out, it's new, it's bigger and better... You can visit the links in the main post above to obtain the C02 update version of this Orange Book. A brief changelog for the new version ... |
|52772||08 Oct 2015 @ 10:42 PDT||ydeepthireddy||Database||Topic||How to create a table in CTE in Teradata||I am trying to create a table in CTE named CATERGORYLIST in CTE. I used the below query
WITH CATERGORYLIST AS
|52771||08 Oct 2015 @ 10:17 PDT||Niesh20us||Database||Topic||IN Clause ||Hi Experts,
Can anyone tell me the difference between below 2 queries . I know result will be same for both the queries but which one will better performance and why ?
delete from tableA ... |
|52770||08 Oct 2015 @ 09:48 PDT||tejasopalli||Database||Reply||skew factor||could any one please tell how we choose our primary indexes
|52769||08 Oct 2015 @ 09:30 PDT||Scomo||Database||Topic||Cast variable length VARCHAR date/time strings to TIMESTAMP||I'm very familiar with casting a date/time into various formats to timestamp, but I'm hoping there's an EASY way to cast variable length items to TIMESTAMP.
|52768||08 Oct 2015 @ 04:42 PDT||rohit.lalwani1||Teradata Applications||Topic||DataBase Migration from Teradata to Oracle and viceversa||HI
We are working in project where we need to reuse some of ETL jobs of one project into another project but the only issue is Target DB is different in both projects but ETL tool is same (D... |
|52767||08 Oct 2015 @ 03:50 PDT||BernieLee||General||Reply||Teradata CIM - Supported Browsers||Can anyone from Teradata answer this question, seriously i posted this a week ago?
|52766||08 Oct 2015 @ 03:03 PDT||chethanr07||Connectivity||Reply||Not able to connect to teradata remotely using perl DBI(DBD::TERADATA)||Hi all,
I think this is a right forum to post questions on connectivity. If this is solved please share the link.
|52765||08 Oct 2015 @ 01:42 PDT||Vinay151||General||Reply||Tuning the SQL query||Hi,
This is the explain plan I got:
1) First, we lock a distinct QA_RMAP_1."pseudo table" for read on a
RowHash to prevent global deadlock for
|52764||07 Oct 2015 @ 11:45 PDT||gkskumar||Database||Topic||Row to column for grid||I have data like below
|52763||07 Oct 2015 @ 10:42 PDT||sgarlapa||Database||Reply||Spool Space Error while running a select query||Hi Sangamesh,
Hope you have the partition on your huge fact table and the partition condition exist in your query.
Ensure the stats exist not only on primary but on the aggregated columns, and ot... |
|52762||07 Oct 2015 @ 09:11 PDT||Fred||General||Reply||What is wrong with this syntax?||Sometimes embedded formatting codes, e. g. in Rich Text Format can cause issues.
Paste the SQL as plain text (e.g. into NotePad) and then copy the plain text version and paste that ... |
|52761||07 Oct 2015 @ 08:57 PDT||Fred||Tools||Reply||OMD API error||You can ignore this warning, unless you have Unity EcoSystems Manager. The Operational MetaData API is the integration between ESM and Teradata Utilities.
|52760||07 Oct 2015 @ 02:23 PDT||cgchawla||Database||Topic||Oracle timestamp (DD-MM-YY HH.MI.SS) to terdata format (YYYY-MM-DD HH:MI:SS)||I am new to teradata and working on migration of data from oracle to teradata.
Date in Oracle is in "DD-MM-YY HH.MI.SS" and want to migrate to teradata. Year in TD gets converted to 4 di... |
|52759||07 Oct 2015 @ 02:10 PDT||sangameshe||Database||Topic||Spool Space Error while running a select query||
We are facing Spool space issue with one of the query in our PROD environment.
1.The result set has 10 million records and after running for 40 minutes we are getting ... |
|52758||07 Oct 2015 @ 01:16 PDT||ToddAWalter||General||Reply||Dropping PI from a table||In the original post it sounds as if there is an impression that adding the PI after the data is loaded would improve load performance or perhaps that the index build would be cheaper if done after... |
|52757||07 Oct 2015 @ 01:01 PDT||crorella||Teradata Studio||Reply||Teradata Studio Express laggy on Mac||It's the same for me, I've have tried the same and the problem persists.
|52756||07 Oct 2015 @ 10:34 PDT||raj_2008||General||Reply||Dropping PI from a table||If I drop PI from an empty table then does it automatically become a NoPI table ? I mean is that possible even without having to specify the "No Primary Index" clause ?
|52755||07 Oct 2015 @ 08:23 PDT||ToddAWalter||Database||Reply||ALTER TABLE - Adding already existing columns||Interesting. You will have to test then to see if it recognizes that there is no work to do and optimizes it to a no-action ALTER.
|52754||07 Oct 2015 @ 07:30 PDT||oshun||Database||Reply||ALTER TABLE - Adding already existing columns||The ALTER TABLE works, f you don't alter the column attributes and no statistics are defined on the column(s).
|52753||07 Oct 2015 @ 06:59 PDT||Bkhan||Database||Reply||Numeric overflow for decimal (38,4)||Hi Dnoeth,
I created a ssis package and I can upload csv multiple files in teradata. Furthermore I can also move my file to archive folder. Now I have to import data from tera data to sql server, ... |
|52752||07 Oct 2015 @ 05:41 PDT||qwedsa||Database||Reply||Before Insert trigger with "join"||up
Thanks a lot
|52751||07 Oct 2015 @ 04:06 PDT||IK186007||General||Reply||Teradata SQL Assistant 12 slow on fetching data to answer sets ||I have the same problem in SQL Assistant.
Cuople additional points:
Slow answerset I have only with ODBC driver. With .NET everything OK.
The same problem with Teradata MDS ODBC connection.
I u... |