Explain Teradata vs. redshift?

Answer»

S.no	Teradata	Redshift
1.	DBMS primarily used for data analytics	A large SCALE data WAREHOUSE SERVICE to be used with business INTELLIGENCE tools.
2.	Not BASED cloud	Cloud-based only
3.	Linux server operating system	Hosted server operating system
4.	Offers XML support.	No XML support.
5.	Offers secondary indexes.	I have restricted secondary indexes.
6.	Has triggers	No Triggers

Discussion