225 Apr 2007 @ 06:08 PDTUDAReplyadvantages of teradata over other databasesSingle Version of Truth, Parallel aware optimizer, reduces dba activities andGood warehouse incase of huge data...Maintain as DW is not so easy in terms of cost.cheers,Maanchaala
117 Apr 2007 @ 07:48 PDTUDAReplySQL Query to modify a column datatype lenght.!!!It can be achieved by using CAST in TD.Ex:SELECT CAST(first_name AS CHAR(5) UPPERCASE)FROM employeeWHERE department_number = 401;regards,hari