469 | 12 Jun 2016 @ 04:26 PDT | Tools | Reply | Arcmain | Hi,
If you have access to tays, then you can download the Arcman cleint from downloads on Tays. The installation steps depends on your OS. you will find the installation guide there as well.
Br,
... |
468 | 09 Jun 2016 @ 12:56 PDT | Database | Reply | Teradata demo version 13.1 | Hi,
If you are looking for a free Teradata version for practice, you can download the VmWare edition from the below link:
http://downloads.teradata.com/download/database/teradata-express-for-vmwa... |
467 | 29 Jul 2015 @ 11:33 PDT | Database | Reply | How to get the statement that was used to create a table in Teradata? |
SELECT REQUESTTEXT FROM DBC.TABLES
WHERE TABLENAME LIKE '%MYTABLE%';
|
466 | 02 Jul 2015 @ 01:40 PDT | Database | Reply | Script to compare two databases (Tables and Views definitions) |
I did it using the below query:
SELECT DatabaseName,TableName,requesttext FROM dbc.tables
WHERE DATABASENAME = 'DATABAE_TO_COMPARE' AND TableKind = 'T' and req... |
465 | 16 Apr 2015 @ 01:11 PDT | Database | Reply | Response Row size or Constant Row size overflow | Hi,
I was facing the same issue in one of my queries, and I investigated and found that I used oreplace function multiple times, I removed the oreplace function and it worked without any issue. So... |
464 | 25 Jun 2014 @ 01:27 PDT | General | Reply | How can we rectify spool space issues. | If you are going out of spool spce, you need tune your query and check for the product joins in the explain plan.
Generate the explain plan and then carefully analyze if there is any product join,... |
463 | 25 Jun 2014 @ 01:06 PDT | General | Reply | queries on casting in teradata | Samath,
In the first query, as the count is Integer, and integer requires 11 char for its representation, when integer is converted into Char it is right aligned and result is only left sid 4 char... |
462 | 25 Jun 2014 @ 12:46 PDT | Tools | Reply | TPT Load Operator Table Lock | I would like to advise you use Update operator, or Multiload to load load ready tables, and then use merge to apply data to target.
In some cases, if the target table has been locked by update ope... |
461 | 25 Jun 2014 @ 12:35 PDT | Tools | Reply | Fastload exit code verification | yes you can do it using shell script. Put the following command in your shell script:
ERROR_HANDLER()
{
echo " "
echo "Error occured!!!"
echo "ERRORLEVE... |
460 | 17 Jun 2014 @ 07:07 PDT | Database | Reply | Multiplication of Decimals | Hi,
You have created the col in table X as varchar and while comparing this number to a decimal it will try for an implicit conversion into the default maxdecimal 38 percision. Real number... |
459 | 17 Jun 2014 @ 01:18 PDT | UDA | Reply | Importing delimiter text file!!!!!!!! | Ramesh,
You can use TAB as {Tab}
.IMPORT VARTEXT '{Tab}' FILE=D:\ABC.txt;
|
458 | 17 Jun 2014 @ 01:12 PDT | Database | Reply | Help needed in Bteq Export | Hi King,
One possible option is to split the single large data set to mutiple file based on a condition. Can you please paste the TPT termination error message?
|
457 | 03 Apr 2014 @ 04:12 PDT | UDA | Reply | Loading Unicode data from Oracle to teradata | Hi,
I am facing a similar issue while processing arabic text. In fact I have to process text files containing arabic text. The default file encoding is ASCII, I convert it into UTF8, that ... |
456 | 02 Mar 2014 @ 02:51 PST | General | Reply | Samples database and create database | Sundeep,
It is quite simple, once you are logged in as DBC user, you can access all the databasees below it in hirarchy. DBC is the most powerfull user in Teradata. Further there is a database nam... |
455 | 25 Feb 2014 @ 08:44 PST | Database | Reply | SQL Issue - Qualify partition by issue | Try this:
CREATE VOLATILE SET TABLE OLB_CUST_SCL1 AS
(
SELECT CAST ( C.ACCOUNTID as DECIMAL(18,0)) AS ACCOUNTID , C.SOR_ID , C.EMAIL
FROM PEDW_SECURED.OLB_PRFL C
INNER JOIN SE... |
454 | 25 Feb 2014 @ 09:55 PST | Database | Reply | Unicode Substr issue with special characters | Irfan,
Can you please tell what issue exactly you are facing?, I have tried the same code with a little change and it is working fine. The code I used is
SELECT
CASE WHEN TRIM(price) ... |
453 | 25 Feb 2014 @ 09:27 PST | Tools | Reply | TTU 13.10 | Yes, it works :)
|
452 | 24 Feb 2014 @ 04:29 PST | General | Reply | Teradata Express for Windows | Andre,
Teradata 14 has discontinued an executable version on Windows or Linuex, the only option available is to use VM Ware. So in order to learn Teradata, you need to use VmWare version. Before t... |
451 | 22 Feb 2014 @ 03:21 PST | Database | Reply | Delete table from within SSIS | Great :)
|
450 | 20 Feb 2014 @ 02:26 PST | Database | Reply | Order by Date | AFAIK, You can not use Order by inside a view, You can only use Order by within a view with last select of a set operation e.g Union
Create view Test
(
SELECT....
UNION
SELECT
Order by 1,2,3.... |
449 | 20 Feb 2014 @ 12:51 PST | Database | Reply | ODBC client on windows | I think your machine is 64 bit, please confirm, if you machine is 64 bit then you will not able to see any drivers in 64 bit ODBC, rather you should use 32 bit odbc. Go to the Start -> All progr... |
448 | 20 Feb 2014 @ 12:49 PST | General | Reply | FYP ideas | Natasha,
I suggest you should go for a team, a team of two people will be good. The second thing is you can discuss it with your internal project coordinator.
I would suggest you shold go for a c... |
447 | 20 Feb 2014 @ 12:45 PST | Connectivity | Reply | Teradata with SSIS | Hi,
The best way to use SSIS with Teradata is through Microsoft Attunity connector. You can get this driver from this URl, and it will help to use TPT operators through SSIS.
http://www.microsoft... |
446 | 20 Feb 2014 @ 12:25 PST | Database | Reply | Keep getting StatusCode="2802",ErrorMessage="SQLState =23505" after delete and reinsert | This jump around is normal, AFAIk TD generates id with gaps. So dont worry about that, but as long as the table is being deleted and reinserted the issue can occure.
|
445 | 19 Feb 2014 @ 11:46 PST | Database | Reply | Keep getting StatusCode="2802",ErrorMessage="SQLState =23505" after delete and reinsert | Hi,
AFAIK, The identity value is cached in PE, and also saved in some table, So it will start from 1 only when you recreate the the table, other wise the number might be repeated. you have defined... |