88 | 13 Mar 2016 @ 05:56 PDT | Tools | Reply | TPT script: error while executing TPT script | Try listing both your tpt script and the output files at the prompt with complete path.
Ex:
ls /teradata/tpt/scriptname.extension
ls /teradata/tpt/output/outfilename.extension
Ensure yo... |
87 | 13 Mar 2016 @ 05:51 PDT | Database | Reply | Generic Mload script for UPSERT | You need to use the shell script capabilities (or windows batch program/powershell) to do this.
So it would be become a fram work for your robust development. Below is an high level idea -
1) Rea... |
86 | 13 Mar 2016 @ 05:44 PDT | Tools | Reply | Receive an error message while trying to use fast load | . (dot) not manditory in fastload. But it is a good practice to keep the dot.
I think you need to check two things.
1) ping the server from your command prompt and see if the server is up or not
... |
85 | 13 Mar 2016 @ 05:28 PDT | Database | Reply | How to display mismatched columns from table differences | Hi You can try giving the column conditions at the bottom to compare if both have same value or not.
sel a.* , b.* from table a, table b
where a.col1<>b.col1 or a.col2 <> b.co... |
84 | 02 Jan 2016 @ 09:46 PST | Training | Reply | Any best Training Centres you guys know in Hyderabad?? | Sunil, for you my suggestion would be download the teradata VM ware versions and practice the SQLS along with OLAP and the utilities. If you don't have much time to do self exploration, better ... |
83 | 02 Jan 2016 @ 09:34 PST | Teradata Applications | Reply | Performance tuning question | May try MLPPI with Source sys Id also on your huge target table. I mean Multi level partition source sys id along with transaction date.
I guess you have limited sources and so you can use hash va... |
82 | 02 Jan 2016 @ 09:29 PST | Training | Reply | Any best Training Centres you guys know in Hyderabad?? | Better you know basics of RDBMS, SQL, Datawarehouse concepts and ETL concepts to understand teradata. Unix or Mainframe basic underatnading also important
|
81 | 02 Jan 2016 @ 08:49 PST | Training | Reply | Need help to find out Teradata certification material |
I don't think dumps are available for TD 14.
You can get train from Manohar. He quotes that the
training would help up to 3 levels of certification.
Can attend a demo and try the s... |
80 | 02 Jan 2016 @ 08:16 PST | Training | Reply | Teradata DBA Traninig in Hyderabad? | I had good expeience with Manohar's (sunmanu9@gmail.com) online training on Teradata development and DBA. (I 've done development 2 years agao and DBA recently)
Yes i agree... |
79 | 02 Jan 2016 @ 08:07 PST | General | Reply | Posting topics into the correct forum | I guess you can use TPT . In TPT, temporarily load data from oracle to teradata and with in same script, compare the temp table and corresponding teradata table, export results into an output file&... |
78 | 02 Jan 2016 @ 08:00 PST | General | Reply | Need logic in teradata (SCD TYPE 2) | Hope you already had the logic to find the delta (change capture process) by comparing two versions of data and derive the indicator either 'I' (For new inserts), 'U' (for updates),... |
77 | 30 Dec 2015 @ 09:58 PST | Database | Reply | Simple merging of records based on Date | Try this -
Select min(eno), name, min (strt_dt) , max(end_dt) from emptable group by 1,3,4; -- for simple scenario of continuos dates are assured.
For other cases need to ... |
76 | 07 Oct 2015 @ 10:42 PDT | 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... |
75 | 11 Aug 2015 @ 07:27 PDT | Cloud Computing | Reply | How do I access a VMWare hosted Teradata Express from a local TD Mapping Manager |
You can use below link Lokesh -
http://downloads.teradata.com/download/database/teradata-express/vmware
|
74 | 21 Nov 2014 @ 03:23 PST | Database | Reply | Connecting Multiple Teradata Servers | I think you can use TPT. TPT only can conect both the servers simultaneously and stream data from source to target in parallel. or need to use any ETL GUI tools like informatica or data... |
73 | 21 Nov 2014 @ 03:21 PST | Database | Reply | help on tuning a query | I didn't try SI. as it is very huge table and loaded by multiload. Even i proposed compression on both the columns as distinct values are less but as it is a DDL change need to take a complete ... |
72 | 19 Nov 2014 @ 02:03 PST | Database | Topic | help on tuning a query | SELECT
col1,col2
FROM
staging_table STG
INNER JOIN
target_table TGT
ON
STG.SRC_TRAN_ID=TGT.SRC_TRAN_ID
WHERE
TGT.ROW_STAT_CD='Active'
AND TGT.SRC_SYS='sourcename'
... |
71 | 28 Sep 2014 @ 10:50 PDT | Training | Reply | Any best Training Centres you guys know in Hyderabad?? | Hi Dieter,
Exactly, I asked the same question to Manohar when i had connected with him for DBA training. He said that his login was revoked by the admin some how (That's what he said).
... |
70 | 27 Sep 2014 @ 11:07 PDT | Database | Reply | self join of table based on PI is spooling out | Hi Dieter,
Partition colum is part of PI in this scenario.
I don't think i can share the DDL (company has secured network)
Thank you.
Srilakshmi
|
69 | 26 Sep 2014 @ 11:11 PDT | Database | Topic | self join of table based on PI is spooling out | Hi,
I've a join requirement between two huge tables which are partitioned on same column and having same PI (composit).
I thought, it would be very much efficient, if i use partition col... |
68 | 26 Sep 2014 @ 11:00 PDT | Database | Reply | Text File to load table | A simple way of finding the utilities in our system would be - go to command prompt and type below commnds -
Ex:
C:\Bteq
c:\mload
c:\fastload
c:\fexp
These command would give... |
67 | 27 Mar 2014 @ 07:59 PDT | Tools | Reply | BTEQ Parallel Execution to speed up executing SQL statements | Hi Krishna, increasing the sessions would make the time lesser which is the objective.
And can you clarify if the sqls are not dependet and written in MSR fashion (semicolon befor... |
66 | 26 Mar 2014 @ 08:08 PDT | Tools | Reply | BTEQ Parallel Execution to speed up executing SQL statements | You can try as below set more sessions and as a multi statment request -
.set sessions 8;
SQL statement1
;SQL statement2
;SQL statement3
;SQL statement4
...etc
;SQL state... |
65 | 24 Mar 2014 @ 08:12 PDT | Tools | Reply | Teradata tools in VMWare Teradata Express | Please try installing Teradata tools on your host machine (windows 7) through below link and configure the DSNs for SQL assistant and administrator,bteq...etc with IP number of Teradata 14 linux ho... |
64 | 24 Mar 2014 @ 08:10 PDT | Training | Reply | Immediat TERADATA Online training available...,Interested people drop a mail @navench@gmail.com | Hi Ashok,
With a basic understanding of RDBMS and SQL it is easy to learn Teradata.
Similar discussions happend about the trainigs in this and other threads also. please gothrugh below... |