Teradata Free Tutorial
Introduction to TeraData It is an RDBMS that Drives companies data ware housing OLTP,OLAP, DSS,DATA MART Appliances.
•An "OPEN SYSTEM", which executes on Unix MP- RAS(Discantioned in TDD) Windows 2000,xp,NOVEL,SUSE LINUX etc The Above operating system •Compatible with 'ANSI' standard •Acts like a SERVER •Run on single(or)Multiple NODES •Built in parallelism
Teradata Administrator Tool Navigation a) Start run b) Start programs teradata administrator Select TD Admin click ok i)Database creation:- click yellow box ii)Creating user click iii)privileges
Memory Management in TeraData Memory Management a) Permanent Memory All tables, procedures, generals, indexes, sub tables etc Required permanent memory Views, Macro, Trigger doesn’t required any permanent memory A DATA BASE can be created without permanent memory] b) Spool Memory i) It stores intermediates result and calculation(Select statement result, join operation data etc) ii) View, macros, derived tables etc, store under spool memory C)Temporary Memory i) It holds intermediate result and calculation[generally session level information] ii)global temporary tables store under temporary memory
Indexes in Teradata
Hash Maps in TeraData Hash Maps
Data Recovery And Protection in Teradata
And Also Issues Interview Questions How to’s For More Teradata Free Tutorials Please Visit: http://bit.ly/1EXWrRN