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
BY Best Interview Question ON 06 Mar 2019