Teradata free tutorial

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