Explain Teradata vs. redshift?
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