Useful SELECT queries in Teradata SQL
A quick tutorial on Select Queries in Teradata SQL. It describes the syntax of select statement, its use, a few useful examples and users' comments....
http://readvitamin.com/2007/07/25/some-useful-select-queries-in-teradata-
A quick tutorial on Select Queries in Teradata SQL. It describes the syntax of select statement, its use, a few useful examples and users' comments....http://readvitamin.com/2007/07/25/some-useful-select-queries-in-teradata-
Date and time manipulation in Teradata
A tutorial article on how to handle date and time variables in Teradata (including discrapancies listing between V2R4 and V2R5). It contains information on timestamp data type sys_calendar.calendar, date intervals calculations and more. Clear examples help...
http://www.teradataforum.com/l040409a.htm
A tutorial article on how to handle date and time variables in Teradata (including discrapancies listing between V2R4 and V2R5). It contains information on timestamp data type sys_calendar.calendar, date intervals calculations and more. Clear examples help...http://www.teradataforum.com/l040409a.htm
String operations in Teradata
A tutorial article on how to handle character variables (strings) in Teradata SQL. The tutorial show how to concatenate strings, convert strings to hexadecimal value using CHAR2HEXINT function, locating characters in a string (INDEX, POSITION functions),...
http://readvitamin.com/2007/08/08/string-manipulations-in-teradata-sql/
A tutorial article on how to handle character variables (strings) in Teradata SQL. The tutorial show how to concatenate strings, convert strings to hexadecimal value using CHAR2HEXINT function, locating characters in a string (INDEX, POSITION functions),...http://readvitamin.com/2007/08/08/string-manipulations-in-teradata-sql/
Teradata tutorial
A good Teradata tutorial which is divided into the following sections: Teradata components and introduction to Teradata database model Fundamental information on Teradata SQL Utility commands (HELP, SHOW, SESSION) Data transformations in Teradata Aggregate...
http://readvitamin.com/teradata/
A good Teradata tutorial which is divided into the following sections: Teradata components and introduction to Teradata database model Fundamental information on Teradata SQL Utility commands (HELP, SHOW, SESSION) Data transformations in Teradata Aggregate...http://readvitamin.com/teradata/
Teradata TPump Tutorial
The Teradata tutorial presentation of using Teradata TPump in an Active Data Warehouse Environment shows the use, features and architecture of using TPump in great detail. It outlines the reasons why TPump is suitable for active datawarehousing and refers to...
http://www.ifs.tuwien.ac.at/~bruckner/dwh/TPump_Tutorial.pdf
The Teradata tutorial presentation of using Teradata TPump in an Active Data Warehouse Environment shows the use, features and architecture of using TPump in great detail. It outlines the reasons why TPump is suitable for active datawarehousing and refers to...http://www.ifs.tuwien.ac.at/~bruckner/dwh/TPump_Tutorial.pdf
Teradata MultiLoad Guide
The Teradata MLoad tutorial guides through the process of importing, updating and deleting data on Teradata RDBMS using Teradata MultiLoad loading tool. The tutorial recommends when MultiLoad and FastLoad should be used and shows how to use loading...
http://www.cs.wright.edu/~schung/TERA/MiniHowToMultiLoad.pdf
The Teradata MLoad tutorial guides through the process of importing, updating and deleting data on Teradata RDBMS using Teradata MultiLoad loading tool. The tutorial recommends when MultiLoad and FastLoad should be used and shows how to use loading...http://www.cs.wright.edu/~schung/TERA/MiniHowToMultiLoad.pdf